topic Re: Separate String in QlikView

Separate String

jumiprado — Thu, 27 Oct 2016 15:04:40 GMT

Hey guys!

I need your help, again!...

I have an excel file with one column with strings like this:

0A001101068646800000200000001665744520160601000000000000000000000016657445000000000000000000684

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!

Peter_Cammaert — Thu, 27 Oct 2016 16:38:06 GMT

[...]

jumiprado — Thu, 27 Oct 2016 18:10:33 GMT

@peter cammaert

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!

Frank_Hartmann — Thu, 27 Oct 2016 21:20:34 GMT

Have a look at attached file

hope this helps

jumiprado — Thu, 27 Oct 2016 21:36:00 GMT

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!?

Thanks!@Frank Hartmann

Frank_Hartmann — Thu, 27 Oct 2016 21:36:33 GMT

i updated the qvw!

Frank_Hartmann — Thu, 27 Oct 2016 21:40:59 GMT

And use this in script for Header2:

num(evaluate(right(purgechar(right(subfield(Data,',',1),15),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'),6)),'#0') as Header2

hope this helps

jumiprado — Thu, 27 Oct 2016 22:19:09 GMT

THANKS YOU!