Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - 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
Saravanan_Desingh

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

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") 😉
Saravanan_Desingh

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.

vvvvvvizard
Partner - Specialist
Partner - 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 . 

Saravanan_Desingh

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