Extracting......................Very Urgent

[buh]

Hi all,

How can i extract only the numbers from the string. Is there any function?

Early reply solicited,
Regards,
Buh

 

[Ngolem]

hmmm I suppose the numbers could be sprinkled anywhere, eh!

I am going to assume you have CR 8.0 or better


Try this formula:

WhilePrintingRecords;
Stringvar temp := {table.mixedstring};
StringVar result := "";
numbervar icount;


for icount := 1 to Length(temp) do
(
if isnumeric(temp[icount]) then
result := result + temp[icount];
);

result; // or tonumber(result) if you want a real number

Hope this helps



Jim
JimBroadbent@Hotmail.com