3

This is my input file.

3400,2
3400,27
3400,DC
3400,TF
5600,KA
5600,KN
5600,TF
0313,EX
0313,EY
0313,EZ
0313,FD
0313,FE
0313,JB
0313,JC
0313,KG
0313,T8

I want my output to be

400,2\|3400,27\|3400,DC\|3400,TF\|5600,KA\|5600,KN\|5600,TF\|0313,EX\|0313,EY\|0313,EZ\|0313,FD\|0313,FE\|0313,JB\|0313,JC\|0313,KG\|0313,T8

I am running the code as follows:

cat f.txt | tr '\n' "\|"
3400,2|3400,27|3400,DC|3400,TF|5600,KA|5600,KN|5600,TF|0313,EX|0313,EY|0313,EZ|0313,FD|0313,FE|0313,JB|0313,JC|0313,KG|0313,T8

cat f.txt | tr '\n' "\\\|"
3400,2\3400,27\3400,DC\3400,TF\5600,KA\5600,KN\5600,TF\0313,EX\0313,EY\0313,EZ\0313,FD\0313,FE\0313,JB\0313,JC\0313,KG\0313,T8

How can I reach my expected output ?

Improve this question
1
  • You could do the following ways: perl -0777pe 's/\n(?!\z)/\\|/g' f.txt perl -pe 'eof || s/\n/\\|/' f.txt Commented May 6, 2017 at 4:49

1 Answer 1

Reset to default
1

You could do this in many ways, with many tools, e.g. with awk like this:

cat f.txt | awk 'BEGIN{ORS="\\|"}1'

@don_cristi remarked correctly, that "This will print a trailing \| and no trailing newline", so here is a version that fixes both, if that is needed for your use-case:

awk 'p{printf "%s\\|",p} {p=$0} END{print p}'
Improve this answer
1
  • @don_crissti Good catch, I will correct my answer. Commented May 5, 2017 at 19:57

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.