Miller is like sed, awk, cut, join, and sort for name-indexed data such as CSV

Re:Miller is like sed, awk, cut, join, and sort for name-ind... by acveilleux on Sunday August 16, 2015 @05:11PM (#10070280)

Not sufficient, but close. It substitutes the quoted character for another one.

[ Parent | on HN ]

Re:Miller is like sed, awk, cut, join, and sort for name-ind... by dbro on Sunday August 16, 2015 @05:41PM (#10070367)

Hi- I'm curious to know what your use case is. Can you explain why substitution is not sufficient?

[ Parent | on HN ]

Re:Miller is like sed, awk, cut, join, and sort for name-ind... by acveilleux on Monday August 17, 2015 @08:21AM (#10072501)

(1) I filter on column content using regex and dealing with a sub character adds complexity.

(2) Many of my columns are free-form text containing commas, carriage returns, new lines, tab, vertical tabs and file separator (0x1c). Occasionally, text is in UCS-2/UTF-16 or uses UTF-8 and foreign characters (a non-trivial quantity of the text I process is in French for example.)

(If you read between the lines here, some columns can contain MLLP-encoded HL7 messages, others contain free-form text and I'm in the medical field.)

[ Parent | on HN ]