Convert Rows to Columns Shell Script

Question

I have data in the below format

APP_OWNER                     : hari
APP_AREA                      : Work:Business Area:AUS
APP_ID                        : 124080

I want the data to be converted to below format.

APP_OWNER,APP_AREA,APP_ID
hari,Work:Business Area:AUS,124080

I can convert one line but how to do it with 3 lines at the same time?

My Attempt with one line

sed '0,/: /s//\n/' test.txt

Regards

stackoverflow.com/q/29081539/4767343

Jose Ricardo Bustos M.
– Jose Ricardo Bustos M.

2020-12-29 19:58:05 +00:00
Commented Dec 29, 2020 at 19:58 — Jose Ricardo Bustos M.
– Jose Ricardo Bustos M., Commented Dec 29, 2020 at 19:58

anubhava · Accepted Answer · 2020-12-29 19:54:36Z

3

You may try this awk solution:

awk -F '[[:blank:]]+:[[:blank:]]+' '{
   v1 = (v1 == "" ? "" : v1 ",") $1
   v2 = (v2 == "" ? "" : v2 ",") $2
}
END {
   print v1 ORS v2
}' file

APP_OWNER,APP_AREA,APP_ID
hari,Work:Business Area:AUS,124080

answered Dec 29, 2020 at 19:54

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

4 Comments

user2854333 Over a year ago

I have one more doubt .. suppose if there is more than one set of data then this will not work right ?

user2854333 Over a year ago

Just updated the data in original question

anubhava Over a year ago

That changes your original problem completely. May I suggest you create a new question with new sample data and new requirement. I will try to get a solution for you.

user2854333 Over a year ago

stackoverflow.com/questions/65517884/… -- Created a new Question

Collectives™ on Stack Overflow

Convert Rows to Columns Shell Script

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related