csvfix

Contact owners and managers

1–30 of 227

Welcome to the support group for CSVfix. If you post a question or answer here, please be aware that the group is moderated, so it may take a little while for me approve your message and for it to show up in the group.

Neil Butterworth

0 selected

9/29/19

alib build fails on debian linux on include of "windows.h"

Hi Neil, I have a debian linux system where I want to use csvfix. I DL'd the csvfix-master zip

unread,

alib build fails on debian linux on include of "windows.h"

Hi Neil, I have a debian linux system where I want to use csvfix. I DL'd the csvfix-master zip

9/29/19

marcde...@gmail.com

5/17/17

Multiline fields echo -smq issue

I want to change the CSV delimiter from comma to semicolon. It seems there is a bug with echo -smq -

unread,

Multiline fields echo -smq issue

I want to change the CSV delimiter from comma to semicolon. It seems there is a bug with echo -smq -

5/17/17

da...@mainsip.com

1/27/17

Map command, values includes a comma

Hi, I'm having a use case where I have to map values "0000000,000" to "0",

unread,

Map command, values includes a comma

Hi, I'm having a use case where I have to map values "0000000,000" to "0",

1/27/17

RAJAPPA, Neil Butterworth6

11/5/16

Date conversion

You need to read upon regular expressions - there is no tutorial material on these in the CSVfix

unread,

Date conversion

You need to read upon regular expressions - there is no tutorial material on these in the CSVfix

11/5/16

RAJAPPA, Neil Butterworth2

11/3/16

Copy value from previous row

There is currently no way of doing this, though it's an interesting idea. On Wednesday, 2

unread,

Copy value from previous row

There is currently no way of doing this, though it's an interesting idea. On Wednesday, 2

11/3/16

marcde...@gmail.com, Neil Butterworth2

11/2/16

Issue with Tab separator and Backslash

With this and other questions here, you seem to imagine that CSVfix is some general-purpose text-

unread,

Issue with Tab separator and Backslash

With this and other questions here, you seem to imagine that CSVfix is some general-purpose text-

11/2/16

marcde...@gmail.com

11/2/16

-rsep and invalid CSV output?

I am considering to use with csvfix.cfg defaults -rsep ';' but I have read in the help file

unread,

-rsep and invalid CSV output?

I am considering to use with csvfix.cfg defaults -rsep ';' but I have read in the help file

11/2/16

marcde...@gmail.com

11/2/16

Getting unquoted fields with -sqf

Hello Neil, I have read about -sqf fields: "Fields not in the list are not quoted, which means

unread,

Getting unquoted fields with -sqf

Hello Neil, I have read about -sqf fields: "Fields not in the list are not quoted, which means

11/2/16

Giacecco, … marcde...@gmail.com3

11/2/16

Bug: csvfix edit can't match empty strings

Hi Neil, do you plan to fix this bug or shall we use your solution command? Actually, I'm not

unread,

Bug: csvfix edit can't match empty strings

Hi Neil, do you plan to fix this bug or shall we use your solution command? Actually, I'm not

11/2/16

pjfarley3, Neil Butterworth3

10/31/16

Any way to have a file as the string of command flags?

Sorry to hear that. The problem I'm trying to solve needs the ability to specify the arguments to

unread,

Any way to have a file as the string of command flags?

Sorry to hear that. The problem I'm trying to solve needs the ability to specify the arguments to

10/31/16

William Finke, … marcde...@gmail.com11

10/30/16

Is CsvFix Check wrong or am I missing a fundamental here?

Hi Neil, great thank you! An official 1.7 release would be of course even better. Le dimanche 30

unread,

Is CsvFix Check wrong or am I missing a fundamental here?

Hi Neil, great thank you! An official 1.7 release would be of course even better. Le dimanche 30

10/30/16

marcde...@gmail.com, Neil Butterworth3

10/29/16

Cut substring from a field?

Hi Neil, great, thank you very much. I have done it successfully with csvfix eval -e "substr($2,

unread,

Cut substring from a field?

Hi Neil, great, thank you very much. I have done it successfully with csvfix eval -e "substr($2,

10/29/16

marcde...@gmail.com, Neil Butterworth3

10/29/16

Native Tab support

Thank you Neil, I appreciate you work. I know it is hard work, only updating the help file takes time

unread,

Native Tab support

Thank you Neil, I appreciate you work. I know it is hard work, only updating the help file takes time

10/29/16

mth...@yahoo.com, … Dermot Carey4

7/7/16

Scientific (Exponential) Notation

Hi Neil, I've run into this as well on Windows. The problem is the rounding that occurs when you

unread,

Scientific (Exponential) Notation

Hi Neil, I've run into this as well on Windows. The problem is the rounding that occurs when you

7/7/16

Aaron Lowndes, Neil Butterworth3

6/11/16

Thanks. Was a dumb question, should've looked further at the help file. Sorry! On Saturday, 11

unread,

Thanks. Was a dumb question, should've looked further at the help file. Sorry! On Saturday, 11

6/11/16

Aaron Lowndes, Neil Butterworth3

6/11/16

csvfix eval -if woes

Thanks. I am on OSX, and I eventually got it working by putting the quote marks earlier like this:

unread,

csvfix eval -if woes

Thanks. I am on OSX, and I eventually got it working by putting the quote marks earlier like this:

6/11/16

omondi...@gmail.com, Neil Butterworth2

5/24/16

Getting started manipulating CSV with csvfix

You need to add the directory containing the CSVfix executable to your PATH environment variable. I

unread,

Getting started manipulating CSV with csvfix

You need to add the directory containing the CSVfix executable to your PATH environment variable. I

5/24/16

Pete, … Neil Butterworth4

5/19/16

CSVfix should have no problems processing this file, and if it didn't produce an error message,

unread,

CSVfix should have no problems processing this file, and if it didn't produce an error message,

5/19/16

mgg...@gmail.com, jposb...@gmail.com2

4/26/16

from_xml does not create uniform CSV when tags and attributes are missing on some records

Hi, Did you manage to find a fix or a workaround for this? I'm having exactly the same problem

unread,

from_xml does not create uniform CSV when tags and attributes are missing on some records

Hi, Did you manage to find a fix or a workaround for this? I'm having exactly the same problem

4/26/16

3/28/16

Produce a list of problematic rows using csvfix check

Hello, how can I produce a list of iffy rows with csvfix check so that I can remove the lines with

unread,

Produce a list of problematic rows using csvfix check

Hello, how can I produce a list of iffy rows with csvfix check so that I can remove the lines with

3/28/16

Tom Wilkinson, Neil Butterworth2

3/13/16

Printing some data using the template command

> Don't know if it is even supported. It isn't.

unread,

Printing some data using the template command

> Don't know if it is even supported. It isn't.

3/13/16

sbrau...@laterpay.ag2

2/18/16

retain headers with find?

Answering myself, in case others have the same issue: csvfix find -if '$line == 1 || $1 == "

unread,

retain headers with find?

Answering myself, in case others have the same issue: csvfix find -if '$line == 1 || $1 == "

2/18/16

xpa...@gmail.com, Neil Butterworth2

2/18/16

default output float format (in eval command) and default smq option

1) The round() function may (or may not) do what you want. 2) See the section of the manual on config

unread,

default output float format (in eval command) and default smq option

1) The round() function may (or may not) do what you want. 2) See the section of the manual on config

2/18/16

jposb...@gmail.com, Neil Butterworth4

2/4/16

Copy from one column to another

If you are using the Windows cmd.exe shell, you need to change the quotes: csvfix eval -r "4,if(

unread,

Copy from one column to another

If you are using the Windows cmd.exe shell, you need to change the quotes: csvfix eval -r "4,if(

2/4/16

Jonathan, Neil Butterworth2

2/4/16

Can you insert a literal when using the "order" command

See the "put" command. On Thursday, 31 December 2015 21:41:35 UTC, Jonathan wrote: Hi, When

unread,

Can you insert a literal when using the "order" command

See the "put" command. On Thursday, 31 December 2015 21:41:35 UTC, Jonathan wrote: Hi, When

2/4/16

Alan Jones, Neil Butterworth2

2/4/16

CSVfix version 1.7 or 2.0?

For reasons of personal circumstance, not any time soon, I'm afraid. Neil Butterworth On Tuesday,

unread,

CSVfix version 1.7 or 2.0?

For reasons of personal circumstance, not any time soon, I'm afraid. Neil Butterworth On Tuesday,

2/4/16

Íñigo Redín, Neil Butterworth2

10/28/15

Split file into multiple files based on number of records (or size)

You can add the number of fields to each CSV record using: csvfix eval -e '$fields' yourfile.

unread,

Split file into multiple files based on number of records (or size)

You can add the number of fields to each CSV record using: csvfix eval -e '$fields' yourfile.

10/28/15

dan.cao...@gmail.com, … Eric Clay3

10/20/15

Retain headers (-rh) as a common option for all of csvfix?

I would recommend stripping the headers (if they even exist which is not the case for my files before

unread,

Retain headers (-rh) as a common option for all of csvfix?

I would recommend stripping the headers (if they even exist which is not the case for my files before

10/20/15

a200...@gmail.com, … Eric Clay3

10/20/15

Have a large ( wide ) csv file and just need to KEEP a few columns

You can do ranges like 1:12, 14:26, 28:42, 44:55, 57:75 Looking at this more you can also do this:

unread,

Have a large ( wide ) csv file and just need to KEEP a few columns

You can do ranges like 1:12, 14:26, 28:42, 44:55, 57:75 Looking at this more you can also do this:

10/20/15

10/2/15

CSV Text Record Manipulation

Hi I need to deal with customer lists in CSV files... doing tasks like: # Find matched keys in a

unread,

CSV Text Record Manipulation

Hi I need to deal with customer lists in CSV files... doing tasks like: # Find matched keys in a

10/2/15

Search

Clear search

Close search

Google apps

Main menu