Hi Mark and LiveCloud team,
ran into problems importing a CSV file into LiveCloud. This is a large file (122 Mb) with 127K + records
Issues:
1. only 103,000 of the 127,000 records were imported
2. the text was exported from an SQL query system that encloses text components in double quotes; there are leading or trailing double quotes (or both) in all fields. However it seems random if these are leading, trailing or both...
3. several fields also have a leading comma in their text (ie. the field starts with ,"field text"
Any advice? (i mean other than programmatically importing the data file to LiveCode and writing a handler to do this)
Many thanks
Stam
ran into problems importing a CSV file into LiveCloud. This is a large file (122 Mb) with 127K + records
Issues:
1. only 103,000 of the 127,000 records were imported
2. the text was exported from an SQL query system that encloses text components in double quotes; there are leading or trailing double quotes (or both) in all fields. However it seems random if these are leading, trailing or both...
3. several fields also have a leading comma in their text (ie. the field starts with ,"field text"
Any advice? (i mean other than programmatically importing the data file to LiveCode and writing a handler to do this)
Many thanks
Stam