Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit214
Creator III
Creator 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
Champion
Champion

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

Sunil Chauhan

View solution in original post

7 Replies
SunilChauhan
Champion
Champion

while loading you can write

load

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

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

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

from abc.text

Sunil Chauhan
rohit214
Creator III
Creator III
Author

hi sunil

its give only the EID

remaining shows no values

thanks

rohit

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

Please upload ur application

Not applicable

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
Champion
Champion

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

Sunil Chauhan
Not applicable

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
Champion
Champion

Try below

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

Sunil Chauhan