Split values in the column

[Anonymous]

Hi All,

I am having values in the column below format

COLUMN                       Expected O/P

ABC,DFG,EEE              "ABC","DFG",'EEE'

HJK,KK,IPREL,             "HJK","KK","IPREL"

GH,IIII,OKPRLAER        "GH","IIII","OKPRLAER"

-Jay

[sasiparupudi1]

Use Subfield

Subfield  (column,',',1)

[robert_mika]

Is your output the same as input just with double quotes after each word?

LOAD

'"'& Replace(Column,',','","')&'"' AS oUTPUT

FROM

(ooxml, embedded labels, table is Sheet1);

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[#4]

Hi,

Please find the attached QVW.

Hope it serves the purpose.

[sunny_talwar]

May be this:

Table:

LOAD *,

  Chr(34) & Replace(COLUMN, ',', Chr(34) & ',' & Chr(34)) & Chr(34) as NEWCOLUMN;

LOAD * Inline [

COLUMN

ABC,DFG,EEE

HJK,KK,IPREL

GH,IIII,OKPRLAER

] (delimiter is |);

Output:

[Anonymous]

yeah, it should be with " "

-Jay

[MayilVahanan]

Hi

Try like this

Table:

LOAD *,

  '"' & Replace(COLUMN, ',', '"' & ',' & '"') & '"' as NEWCOLUMN;

LOAD * Inline [

COLUMN

ABC,DFG,EEE

HJK,KK,IPREL

GH,IIII,OKPRLAER

](delimiter is |);

[#8]

Try this one Table: LOAD *, ""& Replace(Column,',','","')&'"' AS Ouput; LOAD * Inline [ Column ABC,DFG,EEE HJK,KK,IPREL GH,IIII,OKPRLAER ] ;

[qlikviewwizard]

Did you get the solution?