|
Using the 7.5 Gateway has been a challenge for me. Below are three lines created by 7.5 Gateway EXPORT which I’ve separated for ease of reading. Plus the problem area from the middle line of data quoted in part immediately below: “,“Needed to do a 1” fix. 40DDD- CLB 07/14/05”,”
============= "SmithLast","Desiree","-0- ","123 N 8 Th Ave SW","-0- ","Olympia","WA","98512","-0- ","360-754-6477","360-970-7741","-0- ",15899,"B","0","-0- ","-0- ","None","None","-0- ","[EMAIL PROTECTED]","-0- ","-0- ",07/01/1989,-0- ,"-0- ",10/10/2005
"JonesLast","Jessica","-0- ","4546 41St Ave NE","-0- ","Olympia","WA","98516","-0- ","360-556-5623"," - -","-0- ",15901,"B","0","-0- ","-0- ","None","None","Needed to do a 1" fix. 40DDD- CLB 07/14/05","-0- ","-0- ","-0- ",-0- ,-0- ,"Client/Friend/Relative",07/14/2005
"BonneyLast","Garvin","-0- ","-0- ","-0- ","Tacoma","WA","-0- ","-0- "," - -"," - -","-0- ",15902,"B","0","-0- ","-0- ","None","None","-0- ","-0- ","-0- ","-0- ",-0- ,-0- ,"Client/Friend/Relative",07/14/2005 =============
7.5 Gateway choked on it and came up with the following all in one column: Need to do a 1" fix on back of bra tighter. 40DDD- CLB 07/14/05","-0- ","-0- ","-0- ",-0- ,-0- ,"Client/Friend/Relative",07/14/2005 "Christy","Garvi AND THEN STOPPED THE IMPORT
Excel place it in a column like this Needed to do a 1” fix. 40DDD- CLB 07/14/05” Which is not 100% right, BUT continued on with 9,800 records
Will changing the delimiter fix this? What delimiter would you recommend?
Ned Ritchie |
