topic formating in QlikView

formating

Mon, 20 Sep 2010 09:37:47 GMT

I am trying to find a function QlikView to format a character string.
For example:
Transforming "H * / 2Q_?*Z6" to "H2QZ6".
That is to say, I want to keep only the letter and number in the character string

formating

jonathandienst — Mon, 20 Sep 2010 09:48:18 GMT

From the manual:

KeepChar( s1, s2 )
Returns the string s1 less all characters not contained in string s2.
Example:
keepchar( 'a1b2c3' , '123' ) returns '123'.

In your case: =KeepChar('H * / 2Q_?*Z6','ABCDEFGHIJK:LMNOPQRSTUVWXYZ0123456789');

Jonathan

formating

Miguel_Angel_Baeyens — Mon, 20 Sep 2010 09:50:20 GMT

Hello,

Using KeepChar and PurgeChar functions will work for you:

=PurgeChar('H / 2Q_?*Z6', '/ _?*')

=KeepChar('H / 2Q_?*Z6', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789')

Hope that helps