Fault ticketing system import

[cabsandy]

Hi,

I've got some raw faults ticket data (ext is.rep normally) which I'd like some views on if I can use in FM.I've attached a small dummy sample. I just want to do the normal stuff-find, sort etc but the way the data is presented is rather strange-each "complete" record is seperated from the next by a space.Look at the text file and I'd appreciate some views as it's something I've never seen before and excel cant import the whole file because it has too many lines

Thanks in advance

Sandy

ITSD4_small.txt

[Robert Kidd]

Try the attached files.

Open the Data file and run script

This will only work for perfectly formatted data as your sample, you may well do better to make a check of the field name before setting each field and some error checking for end of file etc.

Import.zip

[cabsandy]

Robert,

Appreciate the quick reply-but I very quickly ran into an issue-some of the fields (detailed description is one example) have multiple lines-which shoves all the other lines down and corrupts the script.So backto the drawing board for me -)