Importing Messy TXT Data
VITOPIEPOLI
Forums
Good morning,
I have searched for topic like this but I did not find it.
I have a quite messy txt I am trying to import. I attach a small excerpt.
The best try was delimiting by Tab and modify the type of data field but it still not workable.
File too large to be imported in excel, but it looks like it is able to split it and import the data even though it doeas not convert dates properly.
Do you know how overcome the issues?
Many thanks
Vito
Try to import the fields with
Except from some errors your import looks good. Try to import the fields with errors as text (not date or number) and later use IDEA functions to clean and convert the records. I don't see any problems with date fields when comparing the both screenshots but the field names don't fit the records.