Skip to Content
Former Member
Mar 15, 2010 at 08:09 AM

fetch first letter ex : 101th avenue.


hi Expertes,

i have high priority issue where i have vendor name where it can be like below names:

101 Computers

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.

thank you,