topic string into number (LOAD) in QlikView

string into number (LOAD)

robert_gansel — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: string into number (LOAD)

Anil_Babu_Samineni — Fri, 18 Aug 2017 10:34:28 GMT

Yes, You must use like below from your environment

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

Re: string into number (LOAD)

sasiparupudi1 — Fri, 18 Aug 2017 11:36:29 GMT

May be try

KeepChar(YourField,'0123456790') as NewField

Re: string into number (LOAD)

sunny_talwar — Fri, 18 Aug 2017 11:45:48 GMT

You can also try this

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

or this for your field

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

Re: string into number (LOAD)

divya_shinde — Fri, 18 Aug 2017 11:48:54 GMT

Try this

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

Re: string into number (LOAD)

robert_gansel — Fri, 18 Aug 2017 12:21:30 GMT

That's exactly what I was searching for.

Many thanks!

Re: string into number (LOAD)

sunny_talwar — Fri, 18 Aug 2017 12:31:02 GMT

Great

Re: string into number (LOAD)

sasiparupudi1 — Fri, 18 Aug 2017 12:42:54 GMT

Hi Robert

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

Sasi