Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you looking something like this?
If not, please share the sample and expected output.
can u share a sample data and the expected output ?
Are you looking something like this?
If not, please share the sample and expected output.
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 .
If you find difficult in tailoring the code, please share the sample and expected output. I will try from my side.