mysql -r -s -N tabbed output: how can I handle line breaks and tabs in the data?

Asked Aug 17 '17 at 10:13

Active Aug 17 '17 at 10:13

Viewed 145 times

I am writing a batch script that needs to get some log in tab separated format. Problem is that some of the items in the log contains line breaks (\n) and this make lines that don't adhere to the number of columns I expect. is there any way I can replace or ignore or force mysql to write special chars as \x0a etc?

#!bash
mysql --defaults-extra-file=my.cnf --database db -e "SELECT * FROM db.Log ORDER BY ID DESC LIMIT 1,10;" -r -s -N 2>/dev/null

asked Aug 17 '17 at 10:13

www.jensolsson.se

3,023
2
35
65

I don't think you can do it with this output format. You should create a CSV file. – Barmar Aug 17 '17 at 10:15
maybe pipe the output into `sed` and with regex remove the excessive line break – Zamrony P. Juhara Aug 17 '17 at 10:24
@Barmer how can I do that? – www.jensolsson.se Aug 17 '17 at 10:41
@ZamronyP.Juhara I dont think it is doable with regexp with arbitrary data as every row could be a row or just raw data from the last column in the previous raw. – www.jensolsson.se Aug 17 '17 at 10:41
It helps if you put also original output and the expected output. – Zamrony P. Juhara Aug 17 '17 at 10:45
@ZamronyP.Juhara thing is I want it to work with arbitrary outputs from mysql – www.jensolsson.se Aug 18 '17 at 09:28

mysql -r -s -N tabbed output: how can I handle line breaks and tabs in the data?

0 Answers0