Jeff Vian wrote: > On Sun, 2006-10-15 at 10:06 -0500, Charley Tiggs wrote: >> Howdy, >> >> Is it possible to escape the "&" char within the command-line interface? >> >> Below is a sample of what I have to import for a vendor. There are >> about 40 vendors within my file of some 480 to import (I'm moving client >> from an old solution to SL). Is it possible to escap the "&" so that it >> doesn't throw off everything else? If so, how do I do so? >> > That looks nasty and AFAIK cannot be directly imported. > You need to do some manipulation of the data format to create records > from that so an sql command can do the import. > > Text fields require delimiters to define the field, periods are a > problem since they are an sql operator, and data has to be in fields of > a record structure in order to do any of that. > > name, address1, address2, city, state, zipcode, country, \ > contact, phone, fax, email, shiptoname, shiptoaddress1, ... > > "J&B Imports,Inc.", "PO Box XXXXX", "", "Miami", "FL", 55555, "USA",\ > "John", "", "", "", "J&B Imports,Inc.", "PO Box XXXXX", ...
Thanks for the reply, Jeff. Your reply clued me in to a possible way to handle it that worked. Convert the "&" to the url-encoded equivalent: "%26". Now all of my vendors import just jim dandy. Thanks again for the help! Charley ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sql-ledger-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
