Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

rohit214
Contributor III

how to separate field

hi all

i have data in notepad shown below

Sample1:

eid|name|salary

123|ravi|100

234|arun|200

345|rathish|300

456|rohit|400

sample2:

barcode|value

000001|10000

0 1012|20000

00 111|30000

002222|30000

000088|40000

now what i want ...table should seen like this


eid

123

234
345
456

same  for others....plz help me

thanks rohit

1 Solution

Accepted Solutions
SunilChauhan
Esteemed Contributor

how to separate field

edit script-> Table Files-> select the text file-> delimeter-.Custom-> then seach for '|'  and select '|' 

-> next-> next -...finish

reload the application

now you have 3 fields

Eid, Name and salary

hope this heelps

7 Replies
SunilChauhan
Esteemed Contributor

how to separate field

while loading you can write

load

subfield(fieldname,'|',1) as EID,

subfield(fieldname,'|',2) as Name,

subfield(fieldname,'|',3) as salary

from abc.text

rohit214
Contributor III

how to separate field

hi sunil

its give only the EID

remaining shows no values

thanks

rohit

perumal_41
Valued Contributor II

how to separate field

Hi,

Please upload ur application

Not applicable

Re: how to separate field

Hi,

     In your script select the data file using the 'Table Files' option. Set File Type=Delimited, Delimiter = Custom = '|'. And follow further steps and load data.

Hope this helps.

Thanks.

SunilChauhan
Esteemed Contributor

how to separate field

edit script-> Table Files-> select the text file-> delimeter-.Custom-> then seach for '|'  and select '|' 

-> next-> next -...finish

reload the application

now you have 3 fields

Eid, Name and salary

hope this heelps

Not applicable

Re: how to separate field

Hear '123455' this is string formate time .hear how to use delimete ,i.e.time is 12-34-55 whate is function  used for written delimeter  replay fast friends

SunilChauhan
Esteemed Contributor

Re: how to separate field

Try below

Left('123455',2)&'-'&mid('123455',3,2)&'-'&right('123455',2) as time