i have high priority issue where i have vendor name where it can be like below names:
12th Ave Bearings
10-K Laser Printing
10 2nd Avenue Houghton Estate
if it is a number as we see above it should ignore and take the first character of the name.
ex : name : 101 computers - first letter should be 'C'.
name : 12th Ave bearings - first letter should be 'A'.
name : 10-k Laser printing - first letter should be 'L'.
so if this is the case how can i get the first letter.
if it where to be number and number i would have ignored the number but this scenario has both number and character.
how can i determine the first letter of the character in above case.
your valuble contribution is really highly appriciated.