Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Specialist
Specialist

Load in complex text file

I have a text files, some records are over multiple lines, some are not. The only pattern is each record begins with w3p.exe.      So wherever w3p.exe  appears that should be loaded in as one row until w3p.exe appears again, then that should be loaded in as row 2

 

There is no common delimiter except w3p.exe 

Please advise, a start would be loading the data as one field into the correct row 

 

From there I can work on breaking it down into more columns 

 

 

Labels (1)
1 Solution

Accepted Solutions
saran7de
Master
Master

Are you looking something like this?

https://community.qlik.com/t5/QlikView-Scripting/Indicate-sequence-between-specified-rows/m-p/169594...

 

If not, please share the sample and expected output.

View solution in original post

4 Replies
Taoufiq_Zarra
Master II
Master II

can u share a sample data and the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
saran7de
Master
Master

Are you looking something like this?

https://community.qlik.com/t5/QlikView-Scripting/Indicate-sequence-between-specified-rows/m-p/169594...

 

If not, please share the sample and expected output.

View solution in original post

vvvvvvizard
Specialist
Specialist
Author

Good day

 

I want to mark your answer as helpful , not as solution for now ? I don't see the option 

Im hoping my deliminator wp3.exe has a space before it , so i can mark that as a start line , and the next one as end  as shown in your link . 

Il implement this over the weekend and then mark your solution as correct  as correct . 

saran7de
Master
Master

If you find difficult in tailoring the code, please share the sample and expected output. I will try from my side.