multiple ReplaceChar(String, y, z)

[DennyChan]

Hello

Is there a formula that I can use to do a multiple ReplaceChar(String, y, z)

for example My field is a String of amount below

($1,450.65)

I need to remove both brackets, dollar sign and comma

the result being 1450.65 I would like to do this formula in one

alternatively is there another way to convert the above string of ($1,450.65) to extract 1450.65 from the original

many thanks

Denny

[Joe_Lipski · Accepted solution]

Hi @DennyChan

REPLACECHAR([Field1],"($,)","")

Should do it - Change [Field1] for whatever your field is.

Thanks,

Joe

[DennyChan]

Thank you Joe for your speedy response, it worked a treat

Happy holidays

Denny