Help in code logic for merging 3 files

01-04-2012

Registered User

12, 1

Join Date: Oct 2011

Last Activity: 18 July 2013, 3:35 AM EDT

Posts: 12

Thanks Given: 3

Thanked 1 Time in 1 Post

Help in code logic for merging 3 files

Hi all,
I have a requirement to merge 3 files which has different record count.
Ex:
File1-SOUTHLANG

Code:

01;HINDI
02;TELUGU
03;ITALIAN
04;KOREAN
05;ENGLISH

File2-LANGDET

Code:

INDIA;80 
SOUTHINDIA;60
ITALY;100

File3-LANGYEAR

Code:

400;VERYOLD
1200;OLD
200;VERYOLD

I have merged these files using paste command as

Code:

paste -d ";\0" SOUTHLANG LANGDET LANGYEAR > LANG.txt

and got output as

Code:

01;HINDI;INDIA;80;400;VERYOLD
02;TELUGU;SOUTHINDIA;60;1200;OLD
03;ITALIAN;ITALY;100;200;VERYOLD
04;KOREAN;
05;ENGLISH;

But I require output like

Code:

01;HINDI;INDIA;80;400;VERYOLD
02;TELUGU;SOUTHINDIA;60;1200;OLD
03;ITALIAN;ITALY;100;200;VERYOLD
04;KOREAN;;;;
05;ENGLISH;;;;

I mean blank value with delimiter shall print when there are no values in the specific file.
Please help me in coding this.

Thanks,
SRK.

Last edited by Franklin52; 01-04-2012 at 08:37 AM.. Reason: Please use code tags for code and data samples, thank you

srk409

View Public Profile for srk409

Find all posts by srk409

01-04-2012

Registered User

78, 11

Join Date: Jun 2011

Last Activity: 22 August 2012, 6:11 AM EDT

Location: Chennai

Posts: 78

Thanks Given: 0

Thanked 11 Times in 10 Posts

Try this,

Code:

paste -d ";\0" SOUTHLANG LANGDET LANGYEAR | awk -F';' '{ if (NF<5) { print $0";;;" } else { print $0 } }'

Rksiva

View Public Profile for Rksiva

Find all posts by Rksiva

01-04-2012

Registered User

12, 1

Join Date: Oct 2011

Last Activity: 18 July 2013, 3:35 AM EDT

Posts: 12

Thanks Given: 3

Thanked 1 Time in 1 Post

Sorry...Its not working.

It just adding ';;;' at the end of each record.

The logic here is to merge 3 files and during concatenation when there is no data in a file for a record it should be filled with blank value '' and demilted.
Such that output file will be having some data in all fields.

srk409

View Public Profile for srk409

Find all posts by srk409

01-04-2012

Moderator

8,825, 1,112

Join Date: Feb 2005

Last Activity: 23 August 2021, 11:26 AM EDT

Location: Foxborough, MA

Posts: 8,825

Thanks Given: 579

Thanked 1,112 Times in 1,003 Posts

Code:

paste -d ';' SOUTHLANG LANGDET LANGYEAR | nawk -F';' '{NF=6;$1=$1;print}' OFS=';'

vgersh99

View Public Profile for vgersh99

Find all posts by vgersh99

Shell Programming and Scripting

Help in code logic for merging 3 files

2 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell program code logic

Discussion started by: karthikd214

2. Shell Programming and Scripting

Apply transformation logic in 2 different files

Discussion started by: HAA