adding column from another file

Question

I am pretty new in BASH scripting. I have a csv file with 2 columns separated by comma.

ASDP01,01989015064
KSDP03,01988683270
KSDP06,01945993069
CSDP11,01990721863
CSDP13,01955883155
ASDP12,01953889744
CSDP11,01956798684
ASDP11,01959969994
KSDP01,01924824056

I want to add 2 more columns from another text file. this is written in the text file:

662,2016-12-31

after adding from the tex file, the csv file will be like below

ASDP01,01989015064,662,2016-12-31
KSDP03,01988683270,662,2016-12-31
KSDP06,01945993069,662,2016-12-31
CSDP11,01990721863,662,2016-12-31
CSDP13,01955883155,662,2016-12-31
ASDP12,01953889744,662,2016-12-31
CSDP11,01956798684,662,2016-12-31
ASDP11,01959969994,662,2016-12-31
KSDP01,01924824056,662,2016-12-31

can anyone help me with this?

Whichever of the n solutions that you would be able to use, each would probably ask you to create a new file. — Peaceful
– Peaceful, Commented Dec 17, 2016 at 16:44
You haven't mentioned if there is an entry in file2 corresponding to each entry in file1 — sjsam
– sjsam, Commented Dec 17, 2016 at 16:58

Community · Accepted Answer · 2017-05-23 12:24:51Z

1

I assume file2.csv contains only one row with 662,2016-12-31.

string="$(cat file2.csv)"
sed 's/.*/&,'"$string"'/' file1.csv > new.csv

Output to new.csv:

ASDP01,01989015064,662,2016-12-31
KSDP03,01988683270,662,2016-12-31
KSDP06,01945993069,662,2016-12-31
CSDP11,01990721863,662,2016-12-31
CSDP13,01955883155,662,2016-12-31
ASDP12,01953889744,662,2016-12-31
CSDP11,01956798684,662,2016-12-31
ASDP11,01959969994,662,2016-12-31
KSDP01,01924824056,662,2016-12-31

See: The Stack Overflow Regular Expressions FAQ

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Dec 17, 2016 at 17:01

Cyrus

90.2k15 gold badges112 silver badges173 bronze badges

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

Comments

sjsam · Accepted Answer · 2016-12-17 17:27:22Z

0

You can accomplish the results using awk too.

#cat file1
KSDP01,01989015064
KSDP03,01988683270
KSDP06,01945993069
CSDP11,01990721863
CSDP13,01955883155
ASDP12,01953889744
CSDP11,01956798684
ASDP11,01959969994
KSDP01,01924824056

#cat file2
662,2016-12-31

#awk -v f2content="$(<file2)" '{$0=($0 "," f2content)}1' file1
KSDP01,01989015064,662,2016-12-31
KSDP03,01988683270,662,2016-12-31
KSDP06,01945993069,662,2016-12-31
CSDP11,01990721863,662,2016-12-31
CSDP13,01955883155,662,2016-12-31
ASDP12,01953889744,662,2016-12-31
CSDP11,01956798684,662,2016-12-31
ASDP11,01959969994,662,2016-12-31
KSDP01,01924824056,662,2016-12-31

See [ awk concatenation ].

edited Dec 17, 2016 at 17:27

answered Dec 17, 2016 at 17:20

sjsam

22k6 gold badges62 silver badges114 bronze badges

Comments

karakfa · Accepted Answer · 2016-12-17 17:35:02Z

0

another sed alternative

$ sed 's/$/,'"$(cat file2)"'/' file1

answered Dec 17, 2016 at 17:35

karakfa

67.8k8 gold badges45 silver badges59 bronze badges

Collectives™ on Stack Overflow

adding column from another file

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related