topic Re: Splitting string into coloumns in QlikView

Splitting string into coloumns

Anonymous — Fri, 19 Dec 2014 15:50:52 GMT

Hi Friends,

I have a string like b-bghy-gnhytr-df-fgt.Need to split into 5 coloumns.

As well its size is not fixed..

Can any one help on this..

Re: Splitting string into coloumns

consenit — Fri, 19 Dec 2014 15:59:48 GMT

Hi there.

Look up the SubField() string function.

Kind regards,

Ernesto.

Re: Splitting string into coloumns

saurabh5 — Fri, 19 Dec 2014 16:29:07 GMT

hi shiva,

As Ernesto mentioned use subfield function, below is script which will help you split into 5 columns

trigger:

load * inline [
word, number
b-bghy-gnhytr-df-fgt, 1

];

trigger2:
load number,
SubField(word,'-',1) as one,
SubField(word,'-',2) as two,
SubField(word,'-',3) as three,
SubField(word,'-',4) as four,
SubField(word,'-',-1) as five
resident trigger;

Re: Splitting string into coloumns

maxgro — Fri, 19 Dec 2014 18:42:57 GMT

RESULT

SCRIPT

a: 
load * inline [
word, number
b-bghy-gnhytr-df-fgt, 1
];

b:
load number,
SubField(word,'-') as newfield
resident a
;

Re: Splitting string into coloumns

MarcoWedel — Fri, 19 Dec 2014 23:29:53 GMT

Hi,

one solution could be:

tabStrings:
Generic
LOAD RecNo() as %ID,
    'Sub'&Autonumber(RowNo(),RecNo()) as ColNo,
    SubField(string,'-') as substring
Inline [
string
b-bghy-gnhytr-df-fgt
sdf-sfdsfd-sdf-sdf-sf
sdfs-sfd-sdf-sf
egr-rht-tzj
tjt-iuk
wre
wrer-retz-zu-wre-tzo
zuk-rt-we-jhk-fh-etr
];

hope this helps

regards

Marco

Re: Splitting string into coloumns

rustyfishbones — Sat, 20 Dec 2014 11:48:01 GMT

Use SUBFIELD Function like below image

Re: Splitting string into coloumns

alkesh_sharma — Sat, 20 Dec 2014 11:55:56 GMT

Use SubFiled() Function

Re: Splitting string into coloumns

MarcoWedel — Mon, 22 Dec 2014 21:46:41 GMT

Any luck testing the proposed solutions so far?

Re: Splitting string into coloumns

Anonymous — Thu, 07 May 2015 09:36:19 GMT

Hi yes i tried and its working

Re: Splitting string into coloumns

MarcoWedel — Thu, 07 May 2015 11:05:29 GMT

Hi,

good to hear.

Please close this thread.

thanks

regards

Marco

Re: Splitting string into columns

venkat1 — Tue, 03 Dec 2019 06:43:21 GMT

i tried this but creating synthetic tables.