csvfix

联系所有者和管理员

第 1 - 30 个，共 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

未选择

pjfarley3的个人资料照片

2019/9/29

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

未读，

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

2019/9/29

marcde...@gmail.com的个人资料照片

marcde...@gmail.com

2017/5/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 -

未读，

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 -

2017/5/17

da...@mainsip.com的个人资料照片

da...@mainsip.com

2017/1/27

Map command, values includes a comma

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

未读，

Map command, values includes a comma

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

2017/1/27

RAJAPPA, Neil Butterworth6

2016/11/5

Date conversion

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

未读，

Date conversion

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

2016/11/5

RAJAPPA, Neil Butterworth2

2016/11/3

Copy value from previous row

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

未读，

Copy value from previous row

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

2016/11/3

marcde...@gmail.com的个人资料照片

marcde...@gmail.com, Neil Butterworth2

2016/11/2

Issue with Tab separator and Backslash

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

未读，

Issue with Tab separator and Backslash

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

2016/11/2

marcde...@gmail.com的个人资料照片

marcde...@gmail.com

2016/11/2

-rsep and invalid CSV output?

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

未读，

-rsep and invalid CSV output?

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

2016/11/2

marcde...@gmail.com的个人资料照片

marcde...@gmail.com

2016/11/2

Getting unquoted fields with -sqf

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

未读，

Getting unquoted fields with -sqf

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

2016/11/2

Giacecco的个人资料照片

Giacecco, … marcde...@gmail.com3

2016/11/2

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

未读，

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

2016/11/2

pjfarley3的个人资料照片

pjfarley3, Neil Butterworth3

2016/10/31

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

未读，

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

2016/10/31

William Finke的个人资料照片

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

2016/10/30

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

未读，

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

2016/10/30

marcde...@gmail.com的个人资料照片

marcde...@gmail.com, Neil Butterworth3

2016/10/29

Cut substring from a field?

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

未读，

Cut substring from a field?

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

2016/10/29

marcde...@gmail.com的个人资料照片

marcde...@gmail.com, Neil Butterworth3

2016/10/29

Native Tab support

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

未读，

Native Tab support

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

2016/10/29

mth...@yahoo.com的个人资料照片

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

2016/7/7

Scientific (Exponential) Notation

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

未读，

Scientific (Exponential) Notation

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

2016/7/7

Aaron Lowndes的个人资料照片

Aaron Lowndes, Neil Butterworth3

2016/6/11

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

未读，

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

2016/6/11

Aaron Lowndes的个人资料照片

Aaron Lowndes, Neil Butterworth3

2016/6/11

csvfix eval -if woes

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

未读，

csvfix eval -if woes

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

2016/6/11

omondi...@gmail.com的个人资料照片

omondi...@gmail.com, Neil Butterworth2

2016/5/24

Getting started manipulating CSV with csvfix

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

未读，

Getting started manipulating CSV with csvfix

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

2016/5/24

Pete, … Neil Butterworth4

2016/5/19

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

未读，

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

2016/5/19

mgg...@gmail.com的个人资料照片

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

2016/4/26

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

未读，

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

2016/4/26

2016/3/28

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

未读，

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

2016/3/28

Tom Wilkinson的个人资料照片

Tom Wilkinson, Neil Butterworth2

2016/3/13

Printing some data using the template command

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

未读，

Printing some data using the template command

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

2016/3/13

sbrau...@laterpay.ag的个人资料照片

sbrau...@laterpay.ag2

2016/2/18

retain headers with find?

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

未读，

retain headers with find?

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

2016/2/18

xpa...@gmail.com的个人资料照片

xpa...@gmail.com, Neil Butterworth2

2016/2/18

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

未读，

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

2016/2/18

jposb...@gmail.com的个人资料照片

jposb...@gmail.com, Neil Butterworth4

2016/2/4

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(

未读，

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(

2016/2/4

Jonathan的个人资料照片

Jonathan, Neil Butterworth2

2016/2/4

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

未读，

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

2016/2/4

Alan Jones的个人资料照片

Alan Jones, Neil Butterworth2

2016/2/4

CSVfix version 1.7 or 2.0?

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

未读，

CSVfix version 1.7 or 2.0?

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

2016/2/4

Íñigo Redín的个人资料照片

Íñigo Redín, Neil Butterworth2

2015/10/28

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.

未读，

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.

2015/10/28

dan.cao...@gmail.com的个人资料照片

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

2015/10/20

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

未读，

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

2015/10/20

a200...@gmail.com的个人资料照片

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

2015/10/20

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:

未读，

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:

2015/10/20

meka biz的个人资料照片

2015/10/2

CSV Text Record Manipulation

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

未读，

CSV Text Record Manipulation

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

2015/10/2

搜索

清除搜索内容

关闭搜索框

Google 应用

主菜单