CSV rows splitting and aligning in UNIX SCRIPT

Question

Is that possible to split and align rows of CSV like below?

ID Value
========
1  10
--------
2  20
--------
3  14
--------

Please consider the above as a csv, no need to care about 2nd column (Value). I want to split the 1st Column (ID) and save the result/store it another file.

The output should like: 1,2,3

Welcome to Stack Overflow. Please improve your question by posting some properly formatted code you've applied to the problem. In addition, please take the time to share the steps you've taken so far to research or resolve things on your own. — Todd A. Jacobs
– Todd A. Jacobs, Commented Jan 10, 2013 at 16:58

Vijay · Accepted Answer · 2013-01-10 17:07:11Z

1

awk '!/^[-=]/ && NR!=1{str=str","$1}END{print substr(str,2)}'

tested here

answered Jan 10, 2013 at 17:07

Vijay

67.7k94 gold badges238 silver badges327 bronze badges

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

Comments

William Pursell · Accepted Answer · 2013-01-10 17:07:51Z

1

Your problem is not well specified, but for your particular example you could do:

{ awk 'NR>2 && ! /^--/ { print $1 }' | tr \\n ,; echo; } < input > output

Or perhaps:

< input-file awk 'NR > 1 && NR%2 { print $1 }' | paste -d, -s > output

answered Jan 10, 2013 at 17:07

William Pursell

214k49 gold badges279 silver badges317 bronze badges

Collectives™ on Stack Overflow

CSV rows splitting and aligning in UNIX SCRIPT

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related