I am stumped and hope you can help.

I have a table of alphanumeric strings. The max length of each strings are 6 characters. There is at most one letter in each string. Its location within the string is inconsistent from record to record. The letter is never the first character. I would like to create a function in Crystal reports which will return the position of the letter within the string relative to the left side. 1 being the first character, 2 being the second etc. and 0 if no letters are found. Note: I do not know the actual letter in this string all I know is it not a number.

typical field looks like 102b02, 12d09, 9k12 etc.
for reference we can refer to the field name as {Inv.Bin}

ultimately I want to return the numbers to the left of the letters, but I can do this if I can find the position of the letters in each field.

I appreciate any help you can provide. Thank you all.
regards


Edited by EVSchmidt - 10 Dec 2019 at 12:47pm

I declared the I variable and it worked perfect. Thankyou so much for your help