Convert columns w leading zeros to TEXT. Don't use csv. Use tab-delimited [unless you think the columns have chr(9)] instead.
-- sent from my iPhone4 -- Beverly Voth -- On Dec 31, 2010, at 12:35 AM, "Fogelson, Steve" <[email protected]> wrote: > Some of you may be familiar with auction sites that allow you to import excel > xls files of auction items into the auction. I am trying to do something > similar to this with Witango. > > > > Some of the columns may contain quotation marks to indicate a quote or maybe > signify inches. One column contains a number with leading zeroes. Some > columns contain html tags. > > > > I have tried opening the file with excel and saving as a csv file with a “|” > as the delimiter and then reading into Witango. Two problems seem to occur > with this method. Columns with number with leading zeroes lose the leading > zeros and “general” columns are enclosed with quotes. Not necessarily a > problem unless there are quotes in the field. > > > > I also need to be aware of potential SQL injection when importing these files. > > > > Anyone have any experience with this and a possible solution? > > > > I tried to search the “list” but I can’t find it on the Witango website > anymore. > > > > Thanks > > > > Steve Fogelson > > Internet Commerce Solutions > > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
