login about faq

This may seem like a strange question but I am wanting to create a small application to use to import csv data, create sql insert statements. Some of the input files have non ascii characters, so I have to clean up the data also. In one case the file uses ~ (3 characters) for the field delimiter. I will just need a lot of options and as long as Chilkat can handle it, I'm in good shape.

My question is of the languages that I know or feel comfortable in, which could accomplish this the fastest? I currently am using vbscript, but it's much slower than what I want.

vbscript php activex php extension purebasic delphi dll delphi activex xojo plugin

I do already own xojo and purebasic if that helps, but if another option like delphi is going to be much faster, I'm fine with going that direction.

Thanks Alan

asked Apr 04 '17 at 20:18

asawyer13's gravatar image

asawyer13
11

edited Apr 04 '17 at 21:04


Those are a lot of options. I know vbscript and can say it won't read the files fast enough for your request. You need something that will read the files at a low level, and line by line. I am more comfortable with Visual FoxPro and C#. Both of these have the ability to read files line by line directly. I believe delphi will have the ability. Purebasic and xojo might.

I have done hundreds of custom data conversions pulling in different styles of CSV and otherwise delimited text files. Reading the file line by line, and processing each line as it is read has proven to be the fastest.

HTH, Tracy

link

answered Apr 05 '17 at 09:10

TracyP's gravatar image

TracyP
1213

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×11
×10

Asked: Apr 04 '17 at 20:18

Seen: 667 times

Last updated: Apr 05 '17 at 09:10

powered by OSQA