Remove ^L character from a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove ^L character from a file
# 1  
Old 06-22-2012
Remove ^L character from a file

Hello,

I need to remove ^L character from a file as below:
Code:
 HELLO "I "
 HELLO "I "
^L HELLO "I"
 HELLO "I "
 HELLO "I "

Please suggest.

Thanks !!

Moderator's Comments:
Mod Comment Please use next time code tags for your code and data
# 2  
Old 06-22-2012
Code:
sed 's/^[ \^L]*//' file

# 3  
Old 06-22-2012
Sorry, didnt work .... actually this character is only visible in vi editor. If we do cat it simply shows a space as below:

HELLO "I "
HELLO "I "
HELLO "I"
HELLO "I "
HELLO "I "

Smilie
# 4  
Old 06-22-2012
Try

Code:
awk '/^\014/{sub("\014","")}1' inputfile

# 5  
Old 06-22-2012
$ awk '/^\014/{sub("\014","")}1' x
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1


Smilie
# 6  
Old 06-22-2012
Solaris???
Use /usr/xpg4/bin/awk instead of awk...
# 7  
Old 06-22-2012
Thanks bro it worked Smilie yeah its solaris .... Have to put it across 50 servers .. hope all of them have /usr/xpg4/bin/awk Smilie
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. 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

8. Shell Programming and Scripting

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 dos2unix command. This removed the ^M characters. But I am unable to remove the ^@ character. I tried even the... (6 Replies)
Discussion started by: machomaddy
6 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