Formula Extracting Numeric from String, with £ 1

[codrutza]

Hello

I have a formula:
@extract
if isnumeric ({FreightJobs.SpecialCharacter06})
then tonumber({FreightJobs.SpecialCharacter06})
else 0;
and when it has to extract from £10,000, the 10,000, it gives me 0, so it says that are not numeric in £10,000. The formula works fine for €500, $30,000, ...

What do I do wrong, please?

 

[lbass]

Try:

Stringvar x := {FreightJobs.SpecialCharacter06};
If not isnumeric(x[1]) then
Tonumber(Mid(x,2)) else
Tonumber(X)

-LB

 

[codrutza]

Thank you, LB.
It works for £10,000, but stops at some record saying: the string is not numeric and highlights Tonumber(Mid(x,2)).
Could you explain the formula, please?

 

[lbass]

Try this:

stringvar x := {FreightJobs.SpecialCharacter06};
if trim(x) = "" then
0 else
if not isnumeric(x[1]) then
tonumber(mid(x,2)) else
tonumber(x)

You can then format the field->customize->suppress if zero.

If this still doesn't work, please provide a sample that includes all variations that can occur in the field.

-LB