Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys!
See if you can help me ...
-I have a field called Text.
-I need to filter all rows in that field, through a keyword 'CNPJ' and 20 more characters in front of the word.
-After filtering need to put them in a field called 'CNPJ-Filtered'
How to do this in QlikView?
Follows the type of file that receives the field called Text.
Many thx...
Hi Matheus,
one solution could be:
tabInput:
LOAD Text,
If(WildMatch(Text, '*CNPJ*') and WildMatch(TextNumPattern, '*00.000.000/0000-00*'),Text) as [CNPJ-Filtered];
LOAD @1 as Text,
Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(@1,
'1', '0'),
'2', '0'),
'3', '0'),
'4', '0'),
'5', '0'),
'6', '0'),
'7', '0'),
'8', '0'),
'9', '0') as TextNumPattern
FROM [http://community.qlik.com/servlet/JiveServlet/download/580793-118485/DO8687_02_06_2014.txt]
(txt, codepage is 1252, no labels, delimiter is ';', msq);
hope this helps
regards
Marco
Thanks Marco !
This is a solution for my problem.