Hello Overclockers,
I have a reasonably large .txt file which contains information I am trying to sort out in a way that will let me import the data into excel. I am opening in Notepad++ and the page currently looks like this.
Date: 2017-09 blah blah blah
Name: Insert random words here
InfoA: insert a string of hexadecimal here
InfoB: here is another string of hexadecimal
------------------------------------
Date: 2017-09 different date
Name: Different name here
InfoA: string of hexadecimal
InfoB: more hexadecimal etc
------------------------------------
ETC ETC ETC
Every entry is 4 lines followed by ---------. The labels are all named the same but some are missing the :
I would like to get this data into Excel so Colum A is Date, Colum B is Name, Colum C is Info A and Colum D is Info B.
I dont actually need the date or name information at all but it might be easier to leave it in for now, or not? I can just delete the date/name colums in excel if it works.
Can anyone on here help me out? Would be much appreciated.
I have a reasonably large .txt file which contains information I am trying to sort out in a way that will let me import the data into excel. I am opening in Notepad++ and the page currently looks like this.
Date: 2017-09 blah blah blah
Name: Insert random words here
InfoA: insert a string of hexadecimal here
InfoB: here is another string of hexadecimal
------------------------------------
Date: 2017-09 different date
Name: Different name here
InfoA: string of hexadecimal
InfoB: more hexadecimal etc
------------------------------------
ETC ETC ETC
Every entry is 4 lines followed by ---------. The labels are all named the same but some are missing the :
I would like to get this data into Excel so Colum A is Date, Colum B is Name, Colum C is Info A and Colum D is Info B.
I dont actually need the date or name information at all but it might be easier to leave it in for now, or not? I can just delete the date/name colums in excel if it works.
Can anyone on here help me out? Would be much appreciated.