topic How to format string to number in QlikView

How to format string to number

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I have a excel sheet with a number format in a column as following '00.000.000/0000-00'.

How can I format this into 00000000000000 in Qlikview?

I am using this field to associate with another table.

I look forward to your help.

Best regards,

Jorge

Miguel_Angel_Baeyens — Wed, 25 Apr 2012 13:14:31 GMT

Hi Jorge,

Use the PurgeChar() function along with the Num() function:

Num(PurgeChar('00.000.000/0000-00', './-')) AS Number

The second parameter in PurgeChar() may be any other non numeric character.

Hope that helps.

Miguel

CELAMBARASAN — Wed, 25 Apr 2012 13:22:39 GMT

Hi,

Try with this

Text(KeepChar(FieldName,'0123456789')) as NumberField

Text(PurgeChar(FieldName,'./-')) as NumberField

Celambarasan

SunilChauhan — Wed, 25 Apr 2012 13:40:52 GMT

keepchar( '00.000.000/000000','0')

for field

keepchar( fieldname,'0')

hope this helps

Wed, 25 Apr 2012 13:41:00 GMT

Thanks for the prompt reply. That was of a good help.