How to remove space and delimit a csv file?

Shell Programming and Scripting
1

Hi All ,

I am facing a small challenge i need unix command to remove space as well as replace "|" to "," in a csv file .

original file :

A | B | c | D
E | F | G | H
I | J  | K | L 
P | M | N | O

Expected o/p:

A,B,c,D
E,F,G,H
I,J,K,L 
P,M,N,O
2 
sed 's/ | /,/g' infile
3

Try:

awk '{$1=$1; gsub(/\|/,",")}1' OFS= file

$ cat file
A | B | c |D        
E |F | G | H
I | J  | K | L 
P | M |   N | O   
$
$ awk '{$1=$1; gsub(/\|/,",")}1' OFS= file
A,B,c,D
E,F,G,H
I,J,K,L
P,M,N,O
4

You may Try

$ cat <<eof | sed "s/[[:space:]]//g;s/|/,/g"
A | B | c | D
E | F | G | H
I | J  | K | L 
P | M | N | O
eof

A,B,c,D
E,F,G,H
I,J,K,L
P,M,N,O
5

Thank you sooooooooooooooo much all of you for the immediate response :):):):slight_smile: