Code problem

Atlas_IRL

Hey just wondering if someone can tell me the right line of code to use.

Basically my product codes for an ecommerce site all begin with three letters and an '/' sign

e.g ABC/1234 would map to the brand ABC in my excell file(product upload mapping)

This was done as the csv generating from my POS database wasnt generating brand names.

See line in code it basically says that after the first three letters that are separated with the '/' symbol they will map the brand name right.

Now we have changed 2 products to contain a '-' symbol instead of '/'

ABC-1234 instead of ABC/1234.

I need the right sql code to say anything with a - is added just like the / sign.

 public static string GetBrandNameFromStockref(string StockRef)
        {
            String strb = String.Empty;
            Hashtable brand = new Hashtable();
            brand.Add("ABC", "ABC PRODUCT");

 IDictionaryEnumerator iEnum = brand.GetEnumerator();
          [COLOR="Blue"]  string[] fbrand = StockRef.Split('/');[/COLOR]
            while (iEnum.MoveNext())
            {
                if (iEnum.Key.ToString().ToLower() == fbrand[0].ToLower())
                {
                    strb = iEnum.Value.ToString();
                    break;
                }
            }
            if (strb == "")
                return fbrand[0];
            else
                return strb;
        }
        public static string GetProductNameFromStockref(string StockRef)
        {
            string[] prdName = StockRef.Split('_');
            return prdName[0];
        }
    }
}

The line in question is this line string[] fbrand = StockRef.Split('/');

My friend said just need to change the regex string to work for either "/" or "-" but i cant get it working, any ideas?

Tobias Greeshman

I don't have java handy here to try this out, a character class should handle this for you.

try:

string[] fbrand = StockRef.Split("[/-]");

Atlas_IRL

Hi Tobias cheers for the reply unfortunately it did not work.

Have tried

string[] fbrand = StockRef.Split('/|-');
string[] fbrand = StockRef.Split('/', '-');
string[] fbrand = StockRef.Split("[/-]");

Axe Rake

http://www.mikesdotnetting.com/Article/46/CSharp-Regular-Expressions-Cheat-Sheet

You are probably looking for \/ and \-