How to format string to number

[#1]

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 · Accepted solution]

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]

Hi,

     Try with this

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

or

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

Celambarasan

[SunilChauhan]

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

or

for field

keepchar( fieldname,'0')

hope this helps

[#5]

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