Hi Guys,

Sorry to bother everyone again here, but I ran into a small problem that has been after me for some time now.

I have a file called file1.txt and has following content -

There is another file called file2.txt and has following content.

Now I am trying to merge these two into one separate file where it should look like -

So basically, I am just trying to append content of the 2nd file into file 1 at the end of each line.

I can certainly use sed 's/$/ ;FS folder1/' file 2 > output.txt however, it doesn't do the work for me since it can't add recursive content on each line of fil1.

I tried using paste -d ';' file file 2 > output.txt but it's not appending and its actually simply adding file 2 content at the end of file 1 in the final list.

Can someone please suggest me where i can append file 2 data into file1??

I am using a do -while loop as well by trying to read content of each line and then adding it to each line of file1.

Any suggestions or recommendation are of course welcome.

Thanks,
Morgan.

Hi,

Try this: Do the red part only if file3.txt is to your liking!

Hope this helps.

You can use the 'paste' command for this as well:
The '-d' flag is the delimiter, with an escape character before the semi-colon.

@ShanxT, That's exactly the same command the op said he has already tried.

I can't say why it's not pasting correctly for him (dos line-endings, perhaps?), because for me all the lines from file1 and file2 combine as expected. However, it doesn't give exactly the desired output anyway, as each column is separated by only a semicolon, without any space padding.

To get the above formatting, it seems to me that the best solution is to use awk's getline function to read from the second file.
http://www.gnu.org/software/gawk/man...e/Getline.html

You could also use a two-step process; one command to add a semicolon to the end of each line first, and then a second to combine the lines in the two files.

Fortunately, you can combine both steps into one line using process substitution. This gives me the above output:
I used -d " " because paste outputs tabs by default. You can change it if desired, of course.

http://mywiki.wooledge.org/ProcessSubstitution


By the way, please use regular [code][/code] tags, and not php code tags. 1) That isn't php, obviously, and 2) for some reason php boxes don't honor the column width limit, meaning long lines will force side-scrolling.

1 members found this post helpful.

Ah! My sincere apologies for not reading the original post completely. Also, thanks for the info on 'Process Substitution'!