Good morning. I am new to Crystal reports and need some help with a formula.
What I am facing is I have a field in which data is being captured as 9-12A and I need the data to be 009-12A so I wrote:
if Length ({myString}) = 5 then "00" + {myString}
else if Length ({myString}) = 6 then "0" + {myString}
else {myString}
Now this works fine but I also need a way to delete the letter at the end of the string so it displays 009-12 only.
Is there a way to detect only a alpha character and delete it while not destroying the integrity of the existing formula? I will even take a formula on a formula if that is possible.
Thanks in advance
Task
Edited by taskhill - 05 Sep 2008 at 11:43am