Example cim file:
"FirstName" "LastName"
"Address Line1" - "City" "State" "Country"
"Phone1" - "Fax1"
Now how would you want this to end up, and how would you know what value is for which field, considering there are different cim files formats for different programs.
Hi,
I want to know the easiest way to convert a CIM file into pipe delimited (or comma delimited) file.
I have a script with me that does this but it adds un-necessary pipes between the values that makes it difficult to validate the data.
The extra pipes are necessary if it's a CIM file, the extra |'s are tabs to place the data in the correct field's in the frame. Take your output from the script into your favorite text editor and replace "||" with "|" twice.