How to remove the ^@ character in a file.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to remove the ^@ character in a file.
# 1  
Old 01-03-2012
How to remove the ^@ character in a file.

I receive a file which is Dos format. When I view the file using vi, I was able to find ^M, ^@ characters in beteen records. I wanted to remove these control/special characters. I used the
Code:
dos2unix

command. This removed the ^M characters. But I am unable to remove the ^@ character. I tried even the
Code:
sed 's/^@//g'

but no use. Please help me on removing the ^@ character.

Code:
Sample File
=========
1|insured^@to bcb^@sm.

Code:
Expected Output
=========
1|insuredtobcbsm.

ThanksSmilie
# 2  
Old 01-03-2012
Can delete nulls with "tr".

Code:
cat oldfile | tr -d "\000" > newfile

# 3  
Old 01-03-2012
Hi
Try this
Code:
sed 's/\^@/ /g' < filename |tr -d " "

Smilie

Last edited by sdebasis; 01-03-2012 at 10:47 AM..
# 4  
Old 01-03-2012
I've assumed that you were viewing the file with "cat -v" and seeing each null character as ^@ . sdebasis is assuming two ascii characters ^ and @ .
Please clarify what is in the file:
Code:
od -oc filename

Nulls should show as \0 by this method.
This User Gave Thanks to methyl For This Post:
# 5  
Old 01-03-2012
@Methyl

I was using VI editor to view this file.

Your code
Code:
 cat oldfile | tr -d "\000" > newfile

works!! the ^@ characters were removed.

Smilie
# 6  
Old 01-03-2012
Must have been nulls.
# 7  
Old 01-04-2012
Try this
Code:
sed 's/[[:cntrl:]]//g' filename


Last edited by Franklin52; 01-04-2012 at 03:39 AM.. Reason: Please use code tags for code and data samples, thank you
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to remove newline character if it is the only character in the entire file.?

I have a file which comes every day and the file data look's as below. Vi abc.txt a|b|c|d\n a|g|h|j\n Some times we receive the file with only a new line character in the file like vi abc.txt \n (8 Replies)
Discussion started by: rak Kundra
8 Replies

2. Shell Programming and Scripting

Remove scpecial character from a file

I would like to delete a particular character (') in file. I tried this command, but didn't work: sed 's/'//g' file My file contains these rows: 'eaa3b0e3f86b97a13f123302e1bc788f9':'FfdrTN\'' 'ff368e9fb0982cf91237ef5456297bbb3':'jdcgr$x' '5b829da203d0e53e49e632572bd9091a':']nzuerG' ... (4 Replies)
Discussion started by: freeroute
4 Replies

3. UNIX for Dummies Questions & Answers

How to remove $ or new line character in a file?

Hi All, Could any one suggest how to remove $ symbol in a text file when i am opening in vi editor. Scenario; For example iam having a file name aaa.txt the data inside the file is like sample name when i am opening in vi editor The same file resembles like below when i am... (1 Reply)
Discussion started by: Chandru_Raj
1 Replies

4. Shell Programming and Scripting

How to remove ^M character in file in UNIX?

I have file with controlM (^M) character. i just wanted to run the script after removing the same through script. Thanks in Advance Ganesh. (1 Reply)
Discussion started by: Ganesh L
1 Replies

5. Shell Programming and Scripting

Remove the last character (,) for every line in a file

Good afternoon: im working wih 2 files to find differences and use the cmp command cmp file1 file2 file1 file2 are are diifferent char 302 line1 i found what the difference is with the sed command and that is the file1 at the end of every line has a (,) (comma) character. i.e sed -n... (4 Replies)
Discussion started by: alexcol
4 Replies

6. Shell Programming and Scripting

How to remove ^I character from a UNIX file ?

Hi When i used :set list in vi , i have seen a lot ^I characters in my file. Could anyone please help me how to remove this characters ? Issue : When i used awk to combine two file (one of the file has ^I characters) then my output is different than what am expecting, one of column being... (2 Replies)
Discussion started by: rakeshkumar
2 Replies

7. Shell Programming and Scripting

Remove ^L character from a file

Hello, I need to remove ^L character from a file as below: HELLO "I " HELLO "I " ^L HELLO "I" HELLO "I " HELLO "I " Please suggest. Thanks !! Please use next time code tags for your code and data (9 Replies)
Discussion started by: skhichi
9 Replies

8. UNIX for Dummies Questions & Answers

Remove tab character from file

I am trying to remove the tab character from a file, which occurs on two places in every line. So far I have tried the following and most are from threads in this forum: sed -i '' -e 's/ / /' file.dat sed -i '' -e 's/*/ /' file.dat sed -i '' -e 's/\t*/ /g' file.dat sed -i '' -e 's/*//g'... (4 Replies)
Discussion started by: figaro
4 Replies

9. Shell Programming and Scripting

How to remove first 2 character from file name

Hi All Please help me to remove the first 2 character from the file name. files are like this $ ls 12aman file 13atul si 56rana se I want to remove the first 2 char which are numbers. I want the o/p like thus aman file atul si rana se (8 Replies)
Discussion started by: atul9806
8 Replies

10. HP-UX

How to remove new line character and append new line character in a file?

Hi Experts, I have data coming in 4 columns and there are new line characters \n in between the data. I need to remove the new line characters in the middle of the row and keep the \n character at the end of the line. File is comma (,) seperated. Eg: ID,Client ,SNo,Rank 37,Airtel \n... (8 Replies)
Discussion started by: sasikari
8 Replies
Login or Register to Ask a Question