Got CSV To Import?
I wanted to show you a simple way to read a CSV file and process it before sending it to QuickBase. Normally when a file input control is on a form you select a file from the local file system and th...
Forum Discussion
I am short time so I can't scan the entire thread. If you are importing CSV there aren't many special characters to worry about. All you have to do is surround the entire column value with double quotes and if there is a double quote within the column value just substitute two quotes. So an sentence field might originally look like this
He said "call me on Monday" so I did just that.
and you would "escape" it for CSV like this:
"He said ""call me on Monday"" so I did just that."
On other matters ask a new question. I am going for the pointage!
He said "call me on Monday" so I did just that.
and you would "escape" it for CSV like this:
"He said ""call me on Monday"" so I did just that."
On other matters ask a new question. I am going for the pointage!