Skip to main content
edited tags
Link
Satō Katsura
  • 13.7k
  • 2
  • 34
  • 52
added 60 characters in body
Source Link
Hauke Laging
  • 94.8k
  • 21
  • 133
  • 185

i have csv as below

col1,col2,col3,col4,col5

1,val1,57,val1,TRUE ,val2,,val2,
,val3,,val3,
,val4,,val4,
,val5,,val5,
2,val1,878,val1,FALSE ,val2,,val2,
,val3,,val3,
,val4,,val4,
,val5,,val5,

col1,col2,col3,col4,col5 1,val1,57,val1,TRUE ,val2,,val2, ,val3,,val3, ,val4,,val4, ,val5,,val5, 2,val1,878,val1,FALSE ,val2,,val2, ,val3,,val3, ,val4,,val4, ,val5,,val5, 

i need to display the output using awk as below

col1,col2,col3,col4,col5

1,val1#val2#val3#val4#val5,57,val1#val2#val3#val4#val5,TRUE 2,val1#val2#val3#val4#val5,878,val1#val2#val3#val4#val5,FALSE

col1,col2,col3,col4,col5 1,val1#val2#val3#val4#val5,57,val1#val2#val3#val4#val5,TRUE 2,val1#val2#val3#val4#val5,878,val1#val2#val3#val4#val5,FALSE 

i have csv as below

col1,col2,col3,col4,col5

1,val1,57,val1,TRUE ,val2,,val2,
,val3,,val3,
,val4,,val4,
,val5,,val5,
2,val1,878,val1,FALSE ,val2,,val2,
,val3,,val3,
,val4,,val4,
,val5,,val5,

i need to display the output using awk as below

col1,col2,col3,col4,col5

1,val1#val2#val3#val4#val5,57,val1#val2#val3#val4#val5,TRUE 2,val1#val2#val3#val4#val5,878,val1#val2#val3#val4#val5,FALSE

i have csv as below

col1,col2,col3,col4,col5 1,val1,57,val1,TRUE ,val2,,val2, ,val3,,val3, ,val4,,val4, ,val5,,val5, 2,val1,878,val1,FALSE ,val2,,val2, ,val3,,val3, ,val4,,val4, ,val5,,val5, 

i need to display the output using awk as below

col1,col2,col3,col4,col5 1,val1#val2#val3#val4#val5,57,val1#val2#val3#val4#val5,TRUE 2,val1#val2#val3#val4#val5,878,val1#val2#val3#val4#val5,FALSE 
Source Link

how to concatenate columns with multiple rows using awk

i have csv as below

col1,col2,col3,col4,col5

1,val1,57,val1,TRUE ,val2,,val2,
,val3,,val3,
,val4,,val4,
,val5,,val5,
2,val1,878,val1,FALSE ,val2,,val2,
,val3,,val3,
,val4,,val4,
,val5,,val5,

i need to display the output using awk as below

col1,col2,col3,col4,col5

1,val1#val2#val3#val4#val5,57,val1#val2#val3#val4#val5,TRUE 2,val1#val2#val3#val4#val5,878,val1#val2#val3#val4#val5,FALSE