Making csv from text using awk

Question

I have a lot of txt files like this:

Title 1
Text 1

And I would like to make one csv file from all of them that it will look like this:

Title 1,Text 1
Title 2,Text 2
Title 3,Text 3
etc

How could I do it using awk?

Possible duplicate of Making csv from txt files. Please edit your original question to clarify it. — Dennis Williamson
– Dennis Williamson, Commented Dec 4, 2010 at 15:41

asoundmove · Accepted Answer · 2010-12-12 05:26:51Z

1

Without knowing any more detail, the following answers look like good options:

awk '{printf "%s,", $0; getline; print}'
# every second line gets merged with the previous line

or

awk \
'
  $0 ~ /^Title/ {printf "\n"}
  {printf "%s,", $0}
'
# every line that starts with Title starts
# a newline and the rest is merged into one
# long line separated by commas.

answered Dec 12, 2010 at 5:26

asoundmove

1,3324 gold badges14 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Making csv from text using awk

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related