I really like your code and the tool would become very handy if I were able to automatically change in bulk the the decimal separator for a complete file. Now I have csv files with a "." as separator but they should become a ","
Yes it is. In the v1.1 that should be released today, I added a search function. A future release could implement search-and-replace that could be done to do what you suggest. I'm taking note of this. Thanks for your comment.
Hi Jean, search is working as it should. For now this is not a solution for my type of files. I'm looking forward to testing your search & replace function. Maybe it is possible to integrate this in the "load" screen? Thanks anyway.
Just a note to let you know that the interactive search-and-replace approach (where you can confirm each replacement or click "Replace all") is implemented in v1.2 released today. The batch search-and-replace at load time is for the next version. It will require a little more work on the interface side. But stay tuned!
Hello,
I just tried out v1.1 of CSV Buddy and wanted to thank you for adding support for multi-line fields. Does CSV Buddy support multi-column sorting? I didn't see any sort arrows (ie. ^ or v type arrows) so I wasn't sure. With multi-column sorting sort arrows are really needed so the user can remember how the columns are sorted. Thanks for all of your hard work maintaining CSV Buddy.
Thank you for your good words. Multi-line fields was my primary motivation for writing CSV Buddy. I added various features around the primary load/save functions. But I will have to stop somewhere because my goal is not to replace Excel :-)
This being said, simple sorting and filtering has been implemented. I may improve it in future releases but I could not say what/when at this time. Right now, multi-field sorting can only be achieved by successive sorting. And no arrow will indicate which field was the last one used as sort key. I take note of this suggestion.
Hallo!
I have just begun to use your CSV Buddy software and have created the first simple csv file to export and want to find out how to input the created file into an AutoHotKey list view.
What help can you please offer me.?
I am located in Southern Germany and write in various languages translating into others.
I have built a concept for the process which I call in English "Framework Support" and in German "Unterstützungsrahmen". I would like to use CSV Buddy as a core element in the process.
Thank you Patrick Forkin
What is the chance that CSV Buddy will include an option to display grid lines in a future version? For those of us that use CSV files that don't always have data in each cell it would make it a LOT easier when scrolling through the columns to follow the same row of data. Thanks for considering this request.
Chances are excellent. This is a good idea. This will be included in v1.2. An option in the .ini file will allow to turn the grid on or off (what should be the default for this?). The grid's color could be changed but I'll add other options to change the list background and text colors to make the grid stand out.
Hello Raymond. Just a note to let you know that grid lines and background/text colors are implemented in v1.2 released today. They just require you to edit the .ini file. See the help page http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy-doc.html in the "Advanced Topics" section.
I just finished trying CSV Buddy v1.2.2 and liked it. At first I couldn't see the grid lines until I changed the default ListBackgroundColor=0D0D0D (grey) to ListBackgroundColor=FFFFFF (white) then they were visible.
Any chance of getting CSV Buddy to default to the previously loaded file or at least the previously loaded file's directory when first opening a file? Thanks for your help.
Background color "0D0D0D" looks OK on my side. It probably depends on screens specifics.
> Any chance of getting CSV Buddy to default to the previously loaded file or at least the previously loaded file’s directory when first opening a file?
I prefer to default to the last folder. Good idea. Noted for future release. Thanks again.
I donated. Nice software. I think your software is pretty cool. I like the stability and reliability. I stumbled across it while reviewing the many ways other people have parsed raw data. I was thinking about writing a routine utilizing TF.ahk and CSV.ahk but honestly your program is really good. It would be amaze balls if the program allowed you "Search Column" for "Keyword" and then allowed an option to insert a cell in matched "keyword" cell (i.e. insert a cell to push "keyword" from column b to
column c.
Regarding your suggestion, could you give a practical "real life" example of this? Just to help me understand the objective behind this featrure request.
I just uploaded an update to fix a bug in v1.2 that caused a column with sort indicator to be skipped while saving or exporting. Sorry about that. Please, for safe file saving, update to v1.2.3 here: http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy.zip
Very small and effective software! Thank you dev! Maybe a native linux version can be done? (Of course can be used this one with WINE, but would be nice a linux-oriented one).
No. It can't at this time. Actually, I work more on my other project Folders Popup (http://code.jeanlalonde.ca/folderspopup/) that is localized in various languages but not in Romanian if whenever you are interested :-)
I am already using Folders Popup software! Very very nice and practical! 'CVS budy' I need to translate it for a person which doesn't know english so well.
Sorry but I have no plan to implement multi-language in CSVBuddy at this time. If you are familiar with AHK, source is available and all language is in a separate file. You could compile your own version.
hi guys
i tried your product, 64 bit version
i have windows 7 64 bit, and a very big CSV files (about 4gb)
unfortunately after clic LOAD button, the csv file is NOT imported
it appears only columns name, but no rows
can you help me please?
i need to use your tool to sort my csv file
thanks
Unfortunately, I'm not sure I can help you. CSV Buddy read the whole file in memory before processing it. With the 64-bits version, there is no limitation to file size thanks to virtual RAM. However, there may be a limit in the virtual memory availability and, for sure, loading and saving time could increase to a point where it would not be workable. I did tests with files in the hundreds of megs, but not in the gigs. Maybe someone with knowledge in virtual memory management could help. Or you could look at other tools such as CSVed (but I don't know how they handle very large files).
Merci pour vos bon mots. En fait, ce sont plutôt les noms de colonnes qui sont utilisées comme entêtes de colonnes. Vous pourriez utiliser le champ "Rename fields" pour donner des numéros à vos noms de champs. Mais je ne suis pas certain que cela réponde à votre objectif.
Bonjour
Le renommage des colonnes par "Rename fields" est parfait car j'utilise CSV Buddy pour importer des fichiers CSV dans un logiciel appelé WINDEV.
Encore BRAVO et merci de votre réponse
Mr Roy Michel
I'm using a regular code editor (SciTE for AutoHotkey). Unfortunately, I'm not available to custom coding. But, if you wish, you can describe your needs and I will consider it in a future release.
Hello,
I have dl the app, and when i load a csv and then go to modify some numbers and then try to save what I have modified I can not see a save button. Is there a shortcut or something?
Use the tabs. You are in tab 1) Load CSV File. Go to tab 2) if you need to work woth fields (rename, move, delete, etc.0) then to tab 3) Save CSV File to save your changes to an export file. There are too many options for a simple save button. This is why CSV Buddy uses tabs.
I received your reply by email. I'll follow up here for other users who could be interested.
I see from the screenshot you sent me that the issue is related to the "Edit row" form (see regular example here) where you have a very large number of fields. Too large to stand on a single screen. I'm sorry but the CSV buddy edit form cannot support this large number of columns.
However, it can support it for column manipulation and CSV conversion (using tabs 2, 3 or 4). I would suggest that you edit your file in XL (or any other CSV file editor) and use CSV Buddy if you need to manipulate columns or output format.
yes, UTF-8-Files are read. But when I change some data using special characters like ÜÖÄ ß the Encoding changes to ANSI when I save the file. Also, when a UTF-8 File includes special characters, they are displayed as ANSI-Characters like ÄÜÖ. A conversion of Encoding, like you described above, would also be very helpfull. It would be perfect for me and my collegues to have Encoding Options ANSI, UTF8 and UTF8 without BOM.
Sorry for the delay. If you could send me at ahk@jeanlalonde.ca a sample of your data files, I will look at it. Please send them in a ZIP file to make sure the format is not altered by the email. .
An update on this request: file encoding is supported since v1.3. Supported encodings: ANSI, UTF-8, UTF-16, UTF-8-RAW,
UTF-16-RAW or CPnnn (where nnn is a codepage)
Your comment reminds me the email exchange I had with Christian following the previous comment. Sorry, this got deep on my to-do list. I should get on this soon.
Here is a summary of the changes to v1.2.9 (that will be released as v1.3 after beta tests):
2016-05-15 v1.2.9 BETA
- Select file encoding when loading, saving or exporting files
- Automatic detection of loaded file encoding (this is not possible for files without byte order mark (BOM))
- Encoding supported: ANSI (default), UTF-8 (Unicode 8-bit), UTF-16 (Unicode 16-bit), UTF-8-RAW (no BOM), UTF-16-RAW (no BOM) or custom codepage CPnnnn
- Set custom codepage values in CSVBuddy.ini file
- Other changes:
- deselect all rows after global search is cancelled
- add status bar right section to display hint about list menu
- add help message when right-clicking on column headers
- remove global search and replace (needing to be reworked)
Hello,
I just started testing v1.2.9. It looks good so far. Thanks for telling me about it.
While I have you here, is there any chance multi-line fields could use more than two lines to display their contents (a lot more than two lines if possible based on the window size) in the edit row window? Thanks for considering this request.
Here is a summary of the changes to v1.2.9.1 (that will be released as v1.3 after beta tests):
2016-05-18 v1.2.9.1 BETA
- when editing a record, zoom button to edit long strings in a larger window
- when there is not enough space on screen to edit all fields in a file, support editing the visible fields without loosing the content of the missing fields
v1.2.9.1 beta works great. Thanks for the zoom button. Now I can have up to a full screen if I want it. :-) This is something small, but would it be possible to keep the current sort when reloading the same file? Thanks for considering this request.
P.S.
I've tried to send you and email message (with an attachment) to both your @gmail.com and @jeanlalonde.ca addresses and it bounced back both times. Any ideas how I can send it to you? Thanks again for your help.
Blog RSS feed
I really like your code and the tool would become very handy if I were able to automatically change in bulk the the decimal separator for a complete file. Now I have csv files with a "." as separator but they should become a ","
Is this possible?
Thanks
Yes it is. In the v1.1 that should be released today, I added a search function. A future release could implement search-and-replace that could be done to do what you suggest. I'm taking note of this. Thanks for your comment.
Hi Jean, search is working as it should. For now this is not a solution for my type of files. I'm looking forward to testing your search & replace function. Maybe it is possible to integrate this in the "load" screen? Thanks anyway.
Yes. There would be 2 S&R aproaches: one interactive (where you can confirm each replacement) and one by batch (at load time). I add it to the wish-list https://github.com/JnLlnd/CSVBuddy/issues?state=open
Thanks for your input again.
Just a note to let you know that the interactive search-and-replace approach (where you can confirm each replacement or click "Replace all") is implemented in v1.2 released today. The batch search-and-replace at load time is for the next version. It will require a little more work on the interface side. But stay tuned!
Hello,
I just tried out v1.1 of CSV Buddy and wanted to thank you for adding support for multi-line fields. Does CSV Buddy support multi-column sorting? I didn't see any sort arrows (ie. ^ or v type arrows) so I wasn't sure. With multi-column sorting sort arrows are really needed so the user can remember how the columns are sorted. Thanks for all of your hard work maintaining CSV Buddy.
Hello Raymond,
Thank you for your good words. Multi-line fields was my primary motivation for writing CSV Buddy. I added various features around the primary load/save functions. But I will have to stop somewhere because my goal is not to replace Excel :-)
This being said, simple sorting and filtering has been implemented. I may improve it in future releases but I could not say what/when at this time. Right now, multi-field sorting can only be achieved by successive sorting. And no arrow will indicate which field was the last one used as sort key. I take note of this suggestion.
Thanks again.
Hallo!
I have just begun to use your CSV Buddy software and have created the first simple csv file to export and want to find out how to input the created file into an AutoHotKey list view.
What help can you please offer me.?
I am located in Southern Germany and write in various languages translating into others.
I have built a concept for the process which I call in English "Framework Support" and in German "Unterstützungsrahmen". I would like to use CSV Buddy as a core element in the process.
Thank you Patrick Forkin
Bonjour Patrick,
The core functions of CSV Buddy come from my ObjCSV library (http://code.jeanlalonde.ca/objcsv-library/). This is probably what you need to load a CSV to a listview, save it, etc. See tutorials liks in this discussion http://www.autohotkey.com/board/topic/96618-lib-objcsv-library-v01-library-to-load-and-save-csv-files-tofrom-objects-and-listview/ .
What is the chance that CSV Buddy will include an option to display grid lines in a future version? For those of us that use CSV files that don't always have data in each cell it would make it a LOT easier when scrolling through the columns to follow the same row of data. Thanks for considering this request.
Hello Raymond,
Chances are excellent. This is a good idea. This will be included in v1.2. An option in the .ini file will allow to turn the grid on or off (what should be the default for this?). The grid's color could be changed but I'll add other options to change the list background and text colors to make the grid stand out.
Hello Raymond. Just a note to let you know that grid lines and background/text colors are implemented in v1.2 released today. They just require you to edit the .ini file. See the help page http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy-doc.html in the "Advanced Topics" section.
I just finished trying CSV Buddy v1.2.2 and liked it. At first I couldn't see the grid lines until I changed the default ListBackgroundColor=0D0D0D (grey) to ListBackgroundColor=FFFFFF (white) then they were visible.
Any chance of getting CSV Buddy to default to the previously loaded file or at least the previously loaded file's directory when first opening a file? Thanks for your help.
Hello Raymond,
Background color "0D0D0D" looks OK on my side. It probably depends on screens specifics.
> Any chance of getting CSV Buddy to default to the previously loaded file or at least the previously loaded file’s directory when first opening a file?
I prefer to default to the last folder. Good idea. Noted for future release. Thanks again.
This as been implemented in v1.3.9.1
I donated. Nice software. I think your software is pretty cool. I like the stability and reliability. I stumbled across it while reviewing the many ways other people have parsed raw data. I was thinking about writing a routine utilizing TF.ahk and CSV.ahk but honestly your program is really good. It would be amaze balls if the program allowed you "Search Column" for "Keyword" and then allowed an option to insert a cell in matched "keyword" cell (i.e. insert a cell to push "keyword" from column b to
column c.
Thanks for your donation Kyle. Much appreciated.
Regarding your suggestion, could you give a practical "real life" example of this? Just to help me understand the objective behind this featrure request.
I just uploaded an update to fix a bug in v1.2 that caused a column with sort indicator to be skipped while saving or exporting. Sorry about that. Please, for safe file saving, update to v1.2.3 here: http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy.zip
Very small and effective software! Thank you dev! Maybe a native linux version can be done? (Of course can be used this one with WINE, but would be nice a linux-oriented one).
Thank you for your comment Gabriel. There is no plan for a linux version for my part. But this is open source if a linux dev wants to undertake it.
Oky, understood! Can your software be localized? I would like to translate it to my native language if possible.
No. It can't at this time. Actually, I work more on my other project Folders Popup (http://code.jeanlalonde.ca/folderspopup/) that is localized in various languages but not in Romanian if whenever you are interested :-)
I am already using Folders Popup software! Very very nice and practical! 'CVS budy' I need to translate it for a person which doesn't know english so well.
Sorry but I have no plan to implement multi-language in CSVBuddy at this time. If you are familiar with AHK, source is available and all language is in a separate file. You could compile your own version.
I am not familiar with AHK, but I can learn...Just give me some indications and I'll try...:)
There is a tutorial and a beginners section on the AHK language home page. But be prepared for a quite long learning curve.
And where I can find source and language files to be able to compile?
Link is in the Source section above.
And thanks for you good word about my apps :-)
hi guys
i tried your product, 64 bit version
i have windows 7 64 bit, and a very big CSV files (about 4gb)
unfortunately after clic LOAD button, the csv file is NOT imported
it appears only columns name, but no rows
can you help me please?
i need to use your tool to sort my csv file
thanks
i'll be happy to donate some money, thanks
Unfortunately, I'm not sure I can help you. CSV Buddy read the whole file in memory before processing it. With the 64-bits version, there is no limitation to file size thanks to virtual RAM. However, there may be a limit in the virtual memory availability and, for sure, loading and saving time could increase to a point where it would not be workable. I did tests with files in the hundreds of megs, but not in the gigs. Maybe someone with knowledge in virtual memory management could help. Or you could look at other tools such as CSVed (but I don't know how they handle very large files).
See this http://listoffreeware.com/list-of-best-free-csv-editor-software-for-windows/ and this http://alternativeto.net/software/csv-buddy/ . Good luck!
Bonjour
Sur votre logiciel CSV Buddy qui est SUPER, ne serait-il pas possible de numéroté les colonnes ?
Bien cordialement
Mr Roy Michel
Merci pour vos bon mots. En fait, ce sont plutôt les noms de colonnes qui sont utilisées comme entêtes de colonnes. Vous pourriez utiliser le champ "Rename fields" pour donner des numéros à vos noms de champs. Mais je ne suis pas certain que cela réponde à votre objectif.
Bonjour
Le renommage des colonnes par "Rename fields" est parfait car j'utilise CSV Buddy pour importer des fichiers CSV dans un logiciel appelé WINDEV.
Encore BRAVO et merci de votre réponse
Mr Roy Michel
Hi,
Is it possible to create a CSV file with CSV Buddy?
Thank you for you program.
Hi Alain,
No. CSV Buddy's goal is to edit existing files. Would you find it useful to create files in it?
Jean
Hi Jean,
Of course if possible....
But it's good like this for me.
Thank you and Happy new year Jean.
It is possible. I don't know when I'll re-work on this app but I added it to the wish-list, along with the capability to add rows and columns.
Thank you and Happy New Year to you too.
What editor did you use to put together the GUI for CSVBuddy?
Are you available to modify CSVBuddy for a specific use?
Thanks
Hi Jason,
I'm using a regular code editor (SciTE for AutoHotkey). Unfortunately, I'm not available to custom coding. But, if you wish, you can describe your needs and I will consider it in a future release.
Hello,
I have dl the app, and when i load a csv and then go to modify some numbers and then try to save what I have modified I can not see a save button. Is there a shortcut or something?
Thx in advance for you response
Hi Mihai,
Use the tabs. You are in tab 1) Load CSV File. Go to tab 2) if you need to work woth fields (rename, move, delete, etc.0) then to tab 3) Save CSV File to save your changes to an export file. There are too many options for a simple save button. This is why CSV Buddy uses tabs.
Hope this helps.
Jean
I received your reply by email. I'll follow up here for other users who could be interested.
I see from the screenshot you sent me that the issue is related to the "Edit row" form (see regular example here) where you have a very large number of fields. Too large to stand on a single screen. I'm sorry but the CSV buddy edit form cannot support this large number of columns.
However, it can support it for column manipulation and CSV conversion (using tabs 2, 3 or 4). I would suggest that you edit your file in XL (or any other CSV file editor) and use CSV Buddy if you need to manipulate columns or output format.
Jean
Thx a lot Jean
Will fallow your suggestion
Hello,
I like your editor very much. Would it be possible, having an Option handle UTF-8 encoded Files?
Thank you
Christian
Hi Christian,
CSV Buddy can read and save files in UTF-8. Do you mean an option to read an ANSI file and save it as UTF-8, for example?
Jean
Hi Jean,
yes, UTF-8-Files are read. But when I change some data using special characters like ÜÖÄ ß the Encoding changes to ANSI when I save the file. Also, when a UTF-8 File includes special characters, they are displayed as ANSI-Characters like ÄÜÖ. A conversion of Encoding, like you described above, would also be very helpfull. It would be perfect for me and my collegues to have Encoding Options ANSI, UTF8 and UTF8 without BOM.
Thanks
Chritsian
Hi Christian,
Sorry for the delay. If you could send me at ahk@jeanlalonde.ca a sample of your data files, I will look at it. Please send them in a ZIP file to make sure the format is not altered by the email. .
Thanks,
Jean
An update on this request: file encoding is supported since v1.3. Supported encodings: ANSI, UTF-8, UTF-16, UTF-8-RAW,
UTF-16-RAW or CPnnn (where nnn is a codepage)
hello,
is there a solution? i have the same problem with special characters like ÜÖAß they ar displayed as ÄÜÖ. A.
thanks, francois
Hi François,
Your comment reminds me the email exchange I had with Christian following the previous comment. Sorry, this got deep on my to-do list. I should get on this soon.
Jean
I started to work on the file encoding request. I'm looking for beta testers for v1.2.9., Please drop me an email at ahk@jeanlalonde.ca.
Features:
- set or detect the file encoding when loading files
- set the file encoding when saving or exporting files
Here is a summary of the changes to v1.2.9 (that will be released as v1.3 after beta tests):
2016-05-15 v1.2.9 BETA
- Select file encoding when loading, saving or exporting files
- Automatic detection of loaded file encoding (this is not possible for files without byte order mark (BOM))
- Encoding supported: ANSI (default), UTF-8 (Unicode 8-bit), UTF-16 (Unicode 16-bit), UTF-8-RAW (no BOM), UTF-16-RAW (no BOM) or custom codepage CPnnnn
- Set custom codepage values in CSVBuddy.ini file
- Other changes:
- deselect all rows after global search is cancelled
- add status bar right section to display hint about list menu
- add help message when right-clicking on column headers
- remove global search and replace (needing to be reworked)
Hello,
I just started testing v1.2.9. It looks good so far. Thanks for telling me about it.
While I have you here, is there any chance multi-line fields could use more than two lines to display their contents (a lot more than two lines if possible based on the window size) in the edit row window? Thanks for considering this request.
Hi Raymond. Thanks for testing. Suggestion noted. I'll see if I can do include it in v1.3.
Jean
Here is a summary of the changes to v1.2.9.1 (that will be released as v1.3 after beta tests):
2016-05-18 v1.2.9.1 BETA
- when editing a record, zoom button to edit long strings in a larger window
- when there is not enough space on screen to edit all fields in a file, support editing the visible fields without loosing the content of the missing fields
If you would like to give some help testing this beta release, here is the download link:
http://code.jeanlalonde.ca/ahk/csvbuddy/csvbuddy-1_2_9_1-beta.zip
Please, let me know if everything runs OK or if something needs to be fixed. You can do it by email (ahk@jeanlalonde.ca) or on this page.
v1.2.9.1 beta works great. Thanks for the zoom button. Now I can have up to a full screen if I want it. :-) This is something small, but would it be possible to keep the current sort when reloading the same file? Thanks for considering this request.
P.S.
I've tried to send you and email message (with an attachment) to both your @gmail.com and @jeanlalonde.ca addresses and it bounced back both times. Any ideas how I can send it to you? Thanks again for your help.
Hi Raymond. I will release v1.3 today with current v1.2.9.1 features. I'm taking note of your suggestion about sorting.
Thanks for your input and help testing.
PS: I will contact you by email about the email issue.