Trim problem

[Ayala]

Hi all,

I have a string field which length I don't know (given by
the user), what I know is that the string will have a
number at the beginning and then letters, but I don't know
how many numbers and letters. I need to pick only the
number and save it in other variable. ex.

I get I want
12345adkcvjgr ---> 12345
3dfg ------------> 3
67gfhhted ---------> 67
89765454a ---------> 89765454

The only pattern is that the number will be at the
beginning...



any thoughts?

 

[Cheryl Fischer]

Ayala,

Try the Val() function. It will return the number part of a string, as
long as that number is found at the beginning of the string.

hth,

 

[Ayala]

Thank you very much Cheryl

-----Original Message-----
Ayala,

Try the Val() function. It will return the number part of a string, as
long as that number is found at the beginning of the string.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.