Steve,
Unfortunately I can’t help you today. I have written some code to process CSV,
but it’s always been specific to the output from a remote system, and not
generalized.
I will, however take this opportunity to give a peek at an update planned for
the @TOKENIZE tag:
<@TOKENIZE
[STR=]string
[CHARS=]characters
[NULLTOKENS=boolean]
[RDELIM=rowChars]
[CDELIM=columnChars]
[ESCAPE=escapeChars]
[QUOTE=quoteChars]
[{array-to-text attributes}]
>
The goal is to be able to convert CSV files into Witango arrays easily using
the syntax:
<@TOKENIZE STR=@@myCSVdata RDELIM=<@CRLF>
CDELIM="," QUOTE=<@DQ> NULLTOKENS="yes">
Robert
From: Fogelson, Steve [mailto:[email protected]]
Sent: Friday, December 31, 2010 12:35 AM
To: [email protected]
Subject: Witango-Talk: xls conversion
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.
