devxlogo

Parsing a comma-delimited text file

Parsing a comma-delimited text file

Question:
Is there an easy way to load a datastore with a comma-delimited text file?

Answer:
Yes, just load the file into memory and do a global search and replace on the string. Replace all commas with the tab character. Then you can just use the ImportString function to bulk import the whole file.

devx-admin

Share the Post: