## Formula Extracting Numeric from String, with £

## Formula Extracting Numeric from String, with £

(OP)

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?

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?

## RE: Formula Extracting Numeric from String, with £

Stringvar x := {FreightJobs.SpecialCharacter06};

If not isnumeric(x[1]) then

Tonumber(Mid(x,2)) else

Tonumber(X)

-LB

## RE: Formula Extracting Numeric from String, with £

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?

## RE: Formula Extracting Numeric from String, with £

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