How to convert vertical data to rows

[Phil3]

I have data from Remedy Service Desk that looks similar to this:

Serial Number+ : 2004012345O
# of CPUs :
# of Disk Drives :
# of Slots Used :
AC Input Current(536871005) :
AC Input Voltage(536871004) :
Access Method :
Access MethodFR(536871135) :
Acquired Method(260000000) :
Action on Submit(250000015) :
ArchiveReady(536871128) :
Asset History(200003000) :
Assigned-to(4) :
Assignment Group :
Assignment Individual :
Associated Program :
AssociatedProgramFR(537038842) :
Associationdel'utilisateur(936870998) :
AT User? : No
Attribute Notes :

This repeats (there are more fields mind you) for every workstation. How do I convert this to rows?

[TRF · Accepted solution]

You need to replace tFileInputFullRow and change the file content as explained in the previous post. Changing the file content maybe an other case. I suggest you to mark this case as solved and open a new one with this specific subject (something like "How to retrieve logical records when values may be on more than one physical record and not enclosed by "")

[TRF]

Thank's!
Also think about creating your post in "Design and Development" forum.