AutoHotkey Community

Credits: CSV rules pulled from Creativyst Software

Usage: Converts a string for use in a single field of a CSV file.
Will handle strings with: commas, double quotes, linefeeds*
Issues:Multi-line fields do not display properly in Excel (box character at each end of line).
*While creating a CSV with fields that contain linefeeds will work, there may not be an easy way (using AHK) to read a CSV file with this structure. I do not use mutli-line values but wanted to include this ability.


v Beta 1 - 20080414:
v Alpha 1 - 20080104:

_________________
[Join IRC!]

Bump for beta 1.

_________________
[Join IRC!]

Hey! I love CSV and found this while looking for AutoHotkey stuff related to CSV

Not to, uhhhh.... be that guy.... but this can be done a bit shorter. (I know this is 3½ years old so you probably already know/don't care.) Anyway, here's my function for doing this:

I think it's essentially the same as yours. Although there is one difference that I can see: see how I do (SubStr(Text, 1, 1) = """") instead of just InStr(Text, """") ? That's because, from my testing, I've found that only if the first character is a double quote is the value considered literal. For instance, cell 2 below contains a literal ":

And another note (one which I am disappointed in!): It seems that AutoHotkey does not support newlines as value separators! (By "doesn't support" I mean not supported by Loop, Parse, String, CSV) For instance, if you create a test.csv file like the one shown below:...and then run this code:...it will display "ab" then "cd`nef" then "gh`nij" then "kl". No good!

I'm working on a solution to this but it's not quite done

_________________
★★★ Email me at berban at aim full stop com ★★★

In CSV, non-literal newlines delimit rows, not cells, that's why Loop, Parse, CSV doesn't do anything special with newlines.

If you haven't already seen it, my table manipulation library has functions to convert CSV to/from TSV.

_________________
Ternary (a ? b : c) guide     TSV Table Manipulation Library
Post code inside [code][/code] tags!

Ah, thanks for the tip

Your lib looks great! An incredible variety of functions!

What exactly are you recommending I do: just use the tsv format instead; or read csv files and convert them to tsv and use your functions on them; or read a tsv and convert it to csv for better compatibility with Loop, Parse, CSV...?

Oh and by the way, personally, I like to put the url of the forum post in my code downloads, since that's where a lot of documentation is... which I don't see in your table lib. Just a thought

_________________
★★★ Email me at berban at aim full stop com ★★★

Glad to hear it! I guess I should underscore that the functions are standalone, which means you can cherry-pick the ones you need instead of including the whole 100K+ lib.

I don't know what task you wish to accomplish, only that it probably involves tabular data. So, I will only recommend that you review available resources for handling such data and determine which, if any, meet your requirements. I think it's very reasonable to store data tables in CSV files and have a script convert them to TSV for processing.

I admit I'm a slouch in the documentation department, but I have added the url to the forum topic to the library file

_________________
Ternary (a ? b : c) guide     TSV Table Manipulation Library
Post code inside [code][/code] tags!