Discussion Board for collaboration on QlikView Scripting.
I need your help, again!...
I have an excel file with one column with strings like this:
1A001101068646800000000000000000000000000000075657VARA, NICOLAS MARIANO3279
2A001101068646900000000000000000000000000000080804FRECHA, MARIA EMILIA3280
3A001101068647000000000000000000000000000000053208PLUGOBOY, MARIA DEL CARMEN3281
424A001101068689100000000000000000000000000000115142ABBATE, GONZALO EMANUEL7243
427A001101068689400000000000000000000000000000004296MARIN, FACUNDO LUCIANO7256
587A001101068705400000000000000000000000000000077563GUGLIOTA, NATALIA MARCELA8846
I need to separate this info in two columns like this
Thanks for your help!
Go to Solution.
And use this in script for Header2:
num(evaluate(right(purgechar(right(subfield(Data,',',1),15),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'),6)),'#0') as Header2
hope this helps
Thanks for your help, I need to take the numbers that are before the name and not those who are after, how can I replace that ?
Thanks you again for your help!
Have a look at attached file
FRANK, thanks for your help! but in that cases where you put
purgechar(purgechar(right(subfield(Data,',',1),15),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'),'0') as HEADER_2
the cases where you have a value like "4300" the scripts returns "43" and i need "4300", how can i change the script!?
i updated the qvw!