need to align the csv file in proper format

Question

I have one script which is running and giving an csv file as output in the below format

25-02-2013          
RJ          
D204349194          
Pagamento Caixa                                                     0   
           256.31    -256.31

But i need to align in the below format :

25-02-2013  RJ  D244728244  Pagamento Banco Brasil  0   403.25  -403.25

Means like in excel it should be divided into columns

please suggest me

What is the magic transformation that converts 256.31 to 403.25? — William Pursell
– William Pursell, Commented Feb 27, 2013 at 13:36

Kent · Accepted Answer · 2013-02-27 10:10:44Z

1

if you have column installed, try this line:

 awk '{printf $0}' file|column -t

for your example:

kent$  cat file
25-02-2013          
RJ          
D204349194          
Pagamento Caixa                                                     0   
           256.31    -256.31

kent$  awk '{printf $0}' file|column -t
25-02-2013  RJ  D204349194  Pagamento  Caixa  0  256.31  -256.31

answered Feb 27, 2013 at 10:10

Kent

197k36 gold badges248 silver badges317 bronze badges

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

2 Comments

William Pursell Over a year ago

You must have trailing whitespace in your input file. Or you are using a different awk. Also, column does not work well if the input does not end in a newline (on OS X).

Kent Over a year ago

@WilliamPursell nice point! my awk is gnu awk 4. I checked input in question, there are trailing spaces. that's why I came up with printf $0. with " " is certainly safer.

dogbane · Accepted Answer · 2013-02-27 12:08:52Z

0

First use tr to pull everything onto a single line and then use sed to split the single line based on a field. Try the following:

tr '\n' '\t' < file | sed -r 's/([0-9]{2}-[0-9]{2}-[0-9]{4})/\n\1/g'

This assumes that:

your file is tab delimited
the first field of each record is a date of the form dd-MM-yyyy
there are no other dates in a record except for the first field

answered Feb 27, 2013 at 12:08

dogbane

276k77 gold badges407 silver badges415 bronze badges

Comments

William Pursell · Accepted Answer · 2013-02-27 13:44:32Z

0

awk '{$1=$1; printf $0 "  "}' input; echo

The $1=$1 squeezes whitespace on each line, and the echo emits a terminating newline.

answered Feb 27, 2013 at 13:44

William Pursell

214k49 gold badges279 silver badges317 bronze badges

Collectives™ on Stack Overflow

need to align the csv file in proper format

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related