Re: Outputting a tab character to file redirection

[Rich Davis]

As a workaround, I have found that piping the output to sed and then redirecting that output to the output file will give the desired result:

[user@devbox:~]$ mysql -u user -p'password' --skip-column-names -e "SELECT CONCAT('surame', '\t', 'givenname') AS name" > /tmp/output && cat /tmp/output
surame\tgivenname

[user@devbox:~]$ mysql -u user -p'password' --skip-column-names -e "SELECT CONCAT('surame', '\t', 'givenname') AS name" | sed -e "s/\\\t/\t/g" > /tmp/output && cat /tmp/output
surame	givenname

I would like a more elegant solution that does not involve sed if one exists. In the meantime, I will see what else I am able to come up with.

Regards,
Rich