string into number (LOAD)

[robert_gansel]

Hi,

I am currently searching for a simple way to convert a string into a number.

E.g.: I have the string "€ 5000". As it is not possible to calculate with this I would like to just load the number out of this string and save it as a num value.

Is there any simple solution for this?

Thanks in advance,

Robert

[Anil_Babu_Samineni]

Yes, You must use like below from your environment

SET MoneyFormat='€#,##0.00;(€#,##0.00)';

[sasiparupudi1]

May be try

KeepChar(YourField,'0123456790') as NewField

[sunny_talwar]

You can also try this

Money#('€ 5000', '€ ###0')

or this for your field

Money#(FieldName, '€ ###0') as FieldName

[divya_shinde]

Try this

num(keepchar('€ 5000',0123456789))

[robert_gansel]

That's exactly what I was searching for.

Many thanks!

[sunny_talwar]

Great

[sasiparupudi1]

Hi Robert

Please close this thread by marking a correct answer and any helpful answers

Sasi