Appending 2 text files - Problem in windows


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Appending 2 text files - Problem in windows
# 1  
Old 11-30-2013
Appending 2 text files - Problem in windows

Hello,

I have text files to append and am able to do with cat.

Code:
cat file1 file2 >file3

and file3 works fine in UNIX (checked with vi and it looks fine) but when i open the same file in windows I see 2nd file appended as a single-line. In other words, all the lines of 2nd file appended to first file as single-line.

As I need to process that file in windows, could any please suggest how to fix this problem? perhaps I should add LR+LF every line??

I also tried line-by-line append of 2nd file to 1st file but no luck.

TIA
# 2  
Old 11-30-2013
Yes, Windows uses CR-LF (Carriage Return - Linefeed) to terminate a line and Unix uses LF. So in order to process a windows file on Unix in most cases the CR should be removed before processing. If the result needs to be used on a Windows platform the CR needs to be added again before every LF.

To remove the CR:
Code:
tr -d '\r' < file

To add the CR:
Code:
awk 1 ORS='\r\n'

For an all in one command, resulting in a CR-LF version, try:
Code:
awk '{print $1}' FS='\r' ORS='\r\n' file1 file2 > file3

or better:
Code:
awk '{sub(/\r$/,x)}1' ORS='\r\n' file1 file2 > file3

or without converting first:
Code:
awk '{sub(/\r?$/,"\r")}1' file1 file2 > file3


Last edited by Scrutinizer; 11-30-2013 at 11:27 AM..
# 3  
Old 11-30-2013
In addition, you might also be interested in the unix2dos and dos2unix utilities.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem in appending text to a file located in remote server

ssh -q "server_name sudo echo 'dbagroup::1234' >> sudo /etc/group"if i execute the above code its not getting appended. my requirement is to login to remote server and append dbagroup::1234 in /etc/group i am able to achieve this with tee -a command want to know why its not working with >>... (5 Replies)
Discussion started by: chidori
5 Replies

2. Shell Programming and Scripting

Problem copying files from windows to unix

Hello, I want some directions for a command inside a shell script which would copy files from some path on my windows os (say my documents) to the path where my shell script is saved and I want it to exit the sftp session and continue executing the remaining lines in my shell script after... (2 Replies)
Discussion started by: Vishwa308
2 Replies

3. Shell Programming and Scripting

appending text to a file

I am trying to count number of record in a file and then append a trailer to that file. Trailer should e in the format as below T| <count of records> count of records ---> this count should be one less than the actual count obtained, as the file will have a header. I have drafted a... (3 Replies)
Discussion started by: siteregsam
3 Replies

4. UNIX for Dummies Questions & Answers

sed - appending text

Hey all I am trying to append a file called datebook.txt. I want to append the end of each line containing the name Fred with three ***. I believe I need to make the * loose its meta character meaning in addition to using the append command. I have tried several variations of this command and I... (3 Replies)
Discussion started by: citizencro
3 Replies

5. UNIX for Dummies Questions & Answers

Appending two text files

Hi, i am using unix server and bash shell.. i have two csv files... i have file 1 as below... arun bvb ssx ccc and file 2 as below manas friu dfgg cat (3 Replies)
Discussion started by: arunmanas
3 Replies

6. UNIX for Dummies Questions & Answers

appending in a single text file

actually, i have to grep the value of cpu usage from six differrent servers and it has to generated in a single report( in a single text or excel file). i have used the below command for grepping the value. top -n 1 > arun.txt cat arun.txt | grep 'init' | cut -c 49-53 > output1.csv like... (2 Replies)
Discussion started by: arunmanas
2 Replies

7. Shell Programming and Scripting

Appending text to a file

Hi, Want to append the text to a new file, echo "set `sqlplus -S abc/xyz123@localdb<<EOS" >> chk_test_append.sh echo "EOS`" >> chk_test_append.shbut getting the below error : what wrong is written ? With Regards (4 Replies)
Discussion started by: milink
4 Replies

8. Shell Programming and Scripting

FTP some text files from Windows box to unix

hi all, can anybody help me with script or command to ftp some text file from windows machine to AIX machine. this is shud be done by executing a shell script. (1 Reply)
Discussion started by: suprithhr
1 Replies

9. Shell Programming and Scripting

Appending text of one file into other

hello, I am trying to append\insert the text that exists in file A into file B. for instance: File A contains: abcdef File B contains: ghijklm can i insert into file A the content in file B without damaging\deleting the input into file A? is there a command in shell that enables such... (1 Reply)
Discussion started by: danland
1 Replies
Login or Register to Ask a Question