Split fields from fields in a text line

[Anonymous]

Hi,

I have the following Problem.

Normally, the field names an data in a file look like that:

ID:          1

Date:      20.04.2018

Item1:     Content1

Item2:     Content2

ID:          2

Date:      21.04.2018

Item1:     Content1

Item2:     Content2

...

But in many cases it looks like that:

ID:          1

Date:      20.04.2018

Item1:     Content1     Item2:     Content2

ID:          2

Date:      21.04.2018

Item1:     Content3     Item2:     Content4

The result should be:

ID	Date	Item1	Item2
1	20.04.2018	Content1	Content2
2	21.04.2018	Content3	Content4

Does anyone has an idea, how to solve the problem?

Best regards

Michael

[sunny_talwar]

See all these are work arounds as there is no easy way to pull the data... now if I give you a solution which works for this, it may break something else. To help it make it easy, would you be able to share a sample which is very close to your real scenario... otherwise we will just be doing this over and over and over again....

[Anonymous]

Hi Sunny, !

sorry, you're completly right. I've attached a file created from the original data. I've only "neutralized" the content.

Michael

[sasiparupudi1]

Your test file contains headers and tables.. which section you want us to help you transform.?

Please provide a clean sample.

[Anonymous]

The file contains only 1 table. And what do you mean by headers. The data in the file have the structure already discussed with Sunny Talwar.

[sasiparupudi1]

The file contains balnk line and  tables

			[°]	[°C]
1	2893	12:19:55	28,192	1,999
2	2894	12:20:26	---	---
Mittelwert	2892	12:20:27	-	-
GxP Information (für 589 nm):
Letzte Quartz Justierung:          23.08.2017 11:26:56 von Service
Letzter Check (Quarzcheck): 23.08.2017 10:23:20 von Service - Bestanden
Elektronische Unterschrift der Probe:
Autor:           Nicht unterzeichnet Prüfer:          Nicht unterzeichnet Freigeber:    Nicht unterzeichnet
Mittwoch, 6. Dezember 2017 | 18:18:35
(Unterschrift)
Benutzer:                                 Remote
Nominale Messzellenlänge: 100,00 mm
Messergebnis:
Teilmessungsnummer	Eindeutige Proben-ID	Zeit	Opt. Drehung (längen-korrigiert)		Messzellentemperatur		Reale Messzellenlänge (TC)
			[°]		[°C]		[mm]
1	2896	10:21:00	66,364		2,009		1,000,082
2	2897	10:21:29	66,365		2,002		1,000,081
3	2898	10:21:57	66,366		1,997		1,000,081
Mittelwert	2895	10:21:58	66,365		2,003		1,000,081
Std.-Abw.			82		492		47
GxP Information (für 589 nm):
Letzte Quartz Justierung:          23.08.2017 11:24:47 von Service
Letzter Check (Quarzcheck): 31.08.2017 10:04:12 von phvle0 - Bestanden
Elektronische Unterschrift der Probe:
Autor:           Nicht unterzeichnet Prüfer:          Nicht unterzeichnet Freigeber:    Nicht unterzeichnet
Mittwoch, 6. Dezember 2017 | 18:18:35
(Unterschrift)

[Anonymous]

Please remove the table Information from your post. That seems to be the wrong Information.

[sunny_talwar]

Don't see anything attached