July 9, 2019 at 11:23 pm
I have a text file where the data looks like below, i want to keep this in excel file
WEST|"DERF|"OIQWER.txt|"74773|"|"|"P|"XA|"|"
X100|"123344|"MN|"584|"|"|"|"|"|"|"|"585488|"9.00|"|"|"|"|"|"|"|"|"OL|"|"
COUNT|"3
July 9, 2019 at 11:35 pm
I have a text file where the data looks like below, i want to keep this in excel file WEST|"DERF|"OIQWER.txt|"74773|"|"|"P|"XA|"|" X100|"123344|"MN|"584|"|"|"|"|"|"|"|"585488|"9.00|"|"|"|"|"|"|"|"|"OL|"|" COUNT|"3
If there's a question here, I can't see it.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
July 10, 2019 at 7:55 am
If there's a question here, I can't see it.
The data isn't even well formed either. If we assume that the | not contained in a " is a delimiter, then you get some odd results. I'll change the |'s I think are meant to be delimiters here to a comma (as there are none in the data):
WEST,"DERF|"OIQWER.txt,"74773|","|"P,"XA|","
X100|"123344,"MN|"584,"|","|","|","|"585488,"9.00|","|","|","|","|"OL,"|"
COUNT|"3
As you can see, the first line break is within quotes, so is the 1st and 2nd row actually one "row"? If so, why does the first row have so many columns, and the second none? If you have blank columns in a CSV you still declare them. For example:
Colummn1,Column2,Column3
MyValue1,MyValue2,MyValue3
AnotherValue,,
Here, the final 2 columns in the bottom row are blank.
Unless you actually explain what you want here, and how you work it out, then there's nothing we can do here to help you.
You've been on SSC long enough to know how this works: Sample Data (in a consumable format, and pasting it into the post without formatted isn't really consumable), Expected results (again, consumable), and a description or example of your attempt(s) along with why they didn't work (perhaps you're not getting the data to look like you want?).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply