Hello,
I would like to split my data into column using regex (parse). I have a text file with data you look like this ( Dummy data Example)
2020-11-04-13.44.01.396216A61072 I9005374417
2020-11-04-16.03.26.776288A09000GSI5004320239
I would like this data to be like this
Column1 (Size 26) Column2 (Size 2 ) Column3 (Size 1) Column4(Size10)
2020-11-04-13.44.01.396216 A61072 I 9005374417
2020-11-04-16.03.26.776288 A09000GS I 5004320239
For the first line and the Column2 : A61072 is size 8 because we want to consider the two white space as a character but it is not fill (See the picture Example1 from Notepad++ to see the character "orange point")
How can I create a regex who is going to consider all the particular case.
I know for the Column I need someting like this : (\d+-\d+-\d+-\d+.\d+.\d+.\d{6})
but I have trouble about the Colunm2 when there is space or not. I would like if it is possible a regex expression that create the four column even if there is particular case ( see column 2)
Thanks in advance for your help,
Best regards.