topic Re: Load in complex text file in QlikView

Load in complex text file

vvvvvvizard — Wed, 24 Jun 2020 17:59:57 GMT

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

Re: Load in complex text file

Taoufiq_Zarra — Wed, 24 Jun 2020 18:09:40 GMT

can u share a sample data and the expected output ?

Re: Load in complex text file

Saravanan_Desingh — Wed, 24 Jun 2020 20:13:17 GMT

Are you looking something like this?

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

If not, please share the sample and expected output.

Re: Load in complex text file

vvvvvvizard — Thu, 25 Jun 2020 07:45:41 GMT

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 .

Re: Load in complex text file

Saravanan_Desingh — Thu, 25 Jun 2020 15:03:56 GMT

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