Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Copy content of file in different file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Copy content of file in different file
# 1  
Old 11-08-2016
Copy content of file in different file
Dear all,

I get a file which is probably in hexadecimal character which i have to load in oracle. oracle is unable to process the original file but when i copy the content into notepad it works fine.

How can i achieve in unix to copy content of file into .txt file instead of cp command as cp command will just copy the file itself.

Hope my doubt is clear.

I want to open the file and do select all -> copy -> past in new file without cp command.
# 2  
Old 11-08-2016
If you mind explaining by what magic you used to open your file ( you must have no?) to copy the content in notepad ? As for us all this isnt clear... And what makes you thing you have Hexa char?
# 3  
Old 11-08-2016
Remembering your other recent thread, I guess it might be a question of encoding, e.g. UTF16, not a file "containing hexadecimal" chars. I faintly remember windows creating UTF16 encoded files; where do your files come from?

Please ALWAYS post sample data so people can see and analyse what your problem might be!
# 4  
Old 11-08-2016
Hello Rudic

I am not sure what is the problem with the file and i just guessed that it might have hexa decimal char. when processing the file it shows no data in oracle but when i copy the full content of file in another file then it works well. seeing the data from naked eye will not catch any issue arising from the content of the file.

below is the sample data from original file.
Code:
<EVENT_LOCATION>^M
00;"0";"---"^M
01;"1";"A-car"^M
02;"2";"B-car"^M
03;"3";"C-car"^M
04;"4";"D-car"^M
05;"5";"D1-car"^M
06;"6";"C1-car"^M
07;"7";"B1-car"^M
08;"8";"A1-car"^M
<CODE_0>^M
0000;"";""^M
<PRIORITY>^M
05;"";""^M
01;"";""^M
03;"";""^M
02;"";""^M
04;"";""^M
<EVENT>^M
31;198;"MDLF_DELTA_SIGMA_TEST_2_HCD";"COP Delta Sigma Test Error AI2";A;B;;ON;OFF;"ENV_FAULT"^M
31;185;"MDLF_ANALOG_INPUT_TEST_1_HCD";"COP Analog Input Test Error AI1";A;B;;ON;OFF;"ENV_FAULT"^M
31;171;"MDLF_No_Error_DSP2_HCD";"COP DSP2 self test passed";A;B;;ON;OFF;"ENV_FAULT"^M
31;156;"MDLF_SUP_IREF_RANGE_HCD";"COP internal error (IREF range)";A;B;;ON;OFF;"ENV_FAULT"^M
31;153;"MDLF_POWER_SUPPLY_SUP_TEST_HCD";"COP internal error (power supply test)";A;B;;ON;OFF;"ENV_FAULT"^M
31;14D;"MDLF_STACK_OVERFLOW_HCD";"COP internal error (stack overflow)";A;B;;ON;OFF;"ENV_FAULT"^M
31;14C;"MDLF_CYCTIMESUP_HCD";"COP internal error (DSP overrun)";A;B;;ON;OFF;"ENV_FAULT"^M
31;0C6;"SCU_ST_IEEPROM_ERR_HCD";"COP internal error (internal EEPROM)";A;B;;ON;OFF;"ENV_WARN"^M
31;0C1;"SCU_ST_WD_ERR_HCD";"SCU selftest: watchdog error";A;B;;ON;OFF;"ENV_WARN"^M
31;09D;"MD_BLUELIMIT_RB_AI1_2_STOP_HCD";"STOP: bluelimit counter reed band AI1/2";A;B;;ON;OFF;"ENV_TRIP"^M
31;08E;"MD_TRT_INTERVAL_EXC_HCD";"STOP: Selftest interval 2 is crossed";A;B;;ON;OFF;"ENV_TRIP"^M
31;07B;"MD_IH_RMS_MAX_4_HCD";"RMS Max 4 threshold of heat current exc";A;B;;ON;OFF;"ENV_TRIP"^M
31;072;"MD_II_RMS_MAX_3_HCD";"RMS Max 3 threshold of roof current exc";A;B;;ON;OFF;"ENV_TRIP"^M
31;05E;"MD_DI5_WHILE_MCB_HCD";"DI5 is on while MCB is on (feedback)";A;B;;ON;OFF;"ENV_TRIP"^M
2E;188;"MDLF_ANALOG_INPUT_TEST_4_HCA";"COP Analog Input Test Error AI4";A;B;;ON;OFF;"ENV_FAULT"^M

There is a system which generate this file and it comes form our network cloud.
# 5  
Old 11-08-2016
So how did you edit your file in order to copy paste here ?

did you open the file with notepad?, If not, what do you see in notepad? ( what makes the difference ???)
# 6  
Old 11-08-2016
It has comes to us with *.OTN extension, i opened the file in notepad and copied to another text file
# 7  
Old 11-08-2016
Why is "oracle ... unable to process the original file"? What's the error messages and the result? What's the difference between this file and the one that "works fine"?


And, did you apply the solution to your recent problem before working with the file? The <CR> (^M, 0x0D) char might give a problem, then...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Copy the content from txt file and create a html file

I have a txt file with a list of error messages in a xml tag format, and each error message is separated with a identifier(endresult).Need to split that and copy and create a new html file.Error message has some special character. how to escape the special character and insert my data into the... (7 Replies)
Discussion started by: DevAakash
7 Replies

2. Shell Programming and Scripting

How to remove exisiting file content from a file and have to append new file content?

hi all, i had the below script x=`cat input.txt |wc -1` awk 'NR>1 && NR<'$x' ' input.txt > output.txt by using above script i am able to remove the head and tail part from the input file and able to append the output to the output.txt but if i run it for second time the output is... (2 Replies)
Discussion started by: hemanthsaikumar
2 Replies

3. Shell Programming and Scripting

Change the file name and copy old file content to new file names.

Hi, I have a files in a directory as below :- ls -1 mqdepth-S1STC02 proc-mq-S1STC01 proc-mq-S1STC02 proc-mq-S1STC03 Whereever i have S1STC i need to copy them into new file with file name S2STC. expected output :- ls -1 mqdepth-S2STC02 proc-mq-S2STC01 proc-mq-S2STC02... (3 Replies)
Discussion started by: satishmallidi
3 Replies

4. UNIX Desktop Questions & Answers

copy content of file to another

I have a file called part1.pdb...contents are: ATOM 1 N SER 1 -10.295 -8.909 10.913 1.00 0.00 ATOM 2 H1 SER 1 -10.230 -8.214 10.183 1.00 0.00 ATOM 3 H2 SER 1 -9.558 -8.745 11.584 1.00 0.00 ATOM 4 H3 SER 1 -11.255 ... (1 Reply)
Discussion started by: kanikasharma
1 Replies

5. Shell Programming and Scripting

How to copy mail content in a file in Unix

Hi Guys I want to write a script which search mail with subject line and after that I want the mail content in a file please help guys. Thanks Atul Singh (3 Replies)
Discussion started by: atul9806
3 Replies

6. Shell Programming and Scripting

copy content of file to another files from certain position

Hello Guys I have a directory of xml files (almost 500 ) Now in each xml file 3 new attributes will be added which are in a different single file Is there any way I can copy the whole content of single file at 6th line of all the files in the directory . Thanks a lot!!! (7 Replies)
Discussion started by: Pratik4891
7 Replies

7. UNIX for Dummies Questions & Answers

How to copy entire file content into another file being in last line mode of vi ?

How to copy entire file content into another file being in last line mode of vi ? ---------- Post updated at 10:07 AM ---------- Previous update was at 09:56 AM ---------- Got it : :1,30w file.txt (1 Reply)
Discussion started by: presul
1 Replies

8. UNIX for Dummies Questions & Answers

copy content of file to other file

Hi , i Have 11 Gb file which contain 70 database but I want only one database now i want content of file copy to other file as from starting from word of file1 create database xyz to end word create database xyz1 this copies to other file2 By this I cant get required database... (2 Replies)
Discussion started by: kaushik02018
2 Replies

9. Shell Programming and Scripting

How to copy Content of a file to another file on a specific column

Hi i have a file (file1)with this content: 1.2.3.10.in-addr.arpa and a second file (file2) with a content wich have 8 Columns if a do a awk '{print $8}' file2 i become this output: ,'10.3.2.1.', So i want to replace only the 10.3.2.1. in file2 (column 8) with the information... (8 Replies)
Discussion started by: tuxus
8 Replies

10. Shell Programming and Scripting

How do I search first&second string & copy all content between them to other file?

Hi All, How do I search first string & second string and copy all content between them from one file to another file? Please help me.. Thanks In Advance. Regards, Pankaj (12 Replies)
Discussion started by: pankajp
12 Replies
Login or Register to Ask a Question