[SOLVED] Combine 2 files

freeroute · 06-24-2018, 11:40 AM

I have two files:

1.txt contains

Quote:

email@domain.com:3456312121fdfs34rwrw

2.txt

Quote:

3456312121fdfs34rwrw:true

Desired output.txt

Quote:

email@domain.com:true

How can I create this output using command line (bash)?
Thanks for your support.

Honest Abe · 06-24-2018, 01:54 PM

dirty code --

file1 -

Code:

# cat file1
email@domain.com:3456312121fdfs34rwrw
email2@domain2.com:whatever

file2 -

Code:

# cat file2
3456312121fdfs34rwrw:true 
whatever:false

Then this abomination will print out what you want in the output -

Code:

for i in $(awk -F: '{print $2}' file1); do echo $(grep $i file1 | awk -F: '{print $1}'):$(grep $i file2| awk -F: '{print $2}') >> file4; done

file4 -

Code:

# cat file4
email@domain.com:true
email2@domain2.com:false

I know it works only when
a> field 2 of file1 matches exactly with field 1 of file2 (no order reqd.)
b> exact number of lines are present in both files.

Edit - Would love to see smarter text/string manipulation logics

freeroute · 06-24-2018, 02:45 PM

Thanks for your help. It works!

TB0ne · 06-24-2018, 04:14 PM

Quote:

Originally Posted by freeroute

I have two files:
How can I create this output using command line (bash)?

You're still showing zero effort of your own, and have been asking questions like this for some time:
https://www.linuxquestions.org/quest...5/#post5782281

Again, you need to read the LQ Rules about posting homework questions, and the "Question Guidelines" about just asking people to write your scripts for you.

ondoho · 06-24-2018, 05:45 PM

and those not putting in any effort don't usually get the best solutions.
fwiw, i'd use bash string manipulation for this.
assuming the separator is always a colon ':', and it's always the first and the last word, something along these lines:

Code:

${string1%%:*}:${string2##*:}

http://mywiki.wooledge.org/BashFAQ/100

keefaz · 06-24-2018, 06:12 PM

if lines in 1.txt and 2.txt match...

Code:

join -t: -1 2 -2 1 -o 1.1,2.2 1.txt 2.txt

AwesomeMachine · 06-24-2018, 06:43 PM

The OP reeks of homework!

freeroute · 06-24-2018, 09:23 PM

Quote:

Originally Posted by keefaz

if lines in 1.txt and 2.txt match...

Code:

join -t: -1 2 -2 1 -o 1.1,2.2 1.txt 2.txt

Thanks for your support.

rtmistler · 06-25-2018, 07:33 AM

Quote:

Originally Posted by freeroute

I have two files:
...
How can I create this output using command line (bash)?
Thanks for your support.

@freeroute,

Please be cognizant of the LQ Site FAQ and how to ask effective questions.

Your thread here, awk - cut usernames from mail addresses with gsub or regex is a very good example of a good question. You described the problem, illustrated what you had done, and then asked for some alternate means to accomplish your goal.

Meanwhile, in this thread, as well as some others, you seem to solely ask, "How do I do ...?" without describing any attempts you have made.

Please recognize that, like yourself, all other LQ members are volunteers and that the site is designed to aid your efforts, while you work alongside your fellow advice givers, to accomplish your goals.

TB0ne · 06-25-2018, 07:35 AM

Quote:

Originally Posted by freeroute

Thanks for your support.

Please read the LQ Rules and the "Question Guidelines" before posting such questions again. We don't mind helping, but you just keep asking for us to write your scripts/hand you things.