How can i replace a character with blank space?


 
Thread Tools Search this Thread
Operating Systems AIX How can i replace a character with blank space?
# 1  
Old 04-14-2008
How can i replace a character with blank space?

i want a command for my script!!!

say file consists of character 123 125 127.

i need a query to replace the number 2 with 0

so the output should be 103 105 107.

i use unix-aix
# 2  
Old 04-14-2008
Code:
tr -s '2'  '0' < oldfile > newfile

# 3  
Old 04-14-2008
Quote:
Originally Posted by rollthecoin
say file consists of character 123 125 127.
I am not sure about what you mean: ist this the text as it is in your file or are these decimal (octal?) values for three characters in your file?

If this is text you can use the following:

Code:
sed 's/12\([0-9]\)/10\1/g' /path/to/file > /path/to/other/file

I hope this helps.

bakunin
# 4  
Old 04-16-2008
No.

I will tell you clearly.

i want to delete a invalid character(which i told you as example '2'.)

The query should check for characters which is not present in the following
A to Z,
a to z ,
0 to 9
and all the symbols present in the keyboard.

If you have any doubts reply me.

Last edited by rollthecoin; 04-16-2008 at 06:34 AM..
# 5  
Old 04-17-2008
Quote:
Originally Posted by rollthecoin
The query should check for characters which is not present in the following
A to Z,
a to z ,
0 to 9
You have already solved the problem almost - all on your own. Just construct a simple regular expression from your goal:

Code:
[^A-Za-z0-9.,#&@]

will find any characters which are not small characters, capitalized characters, digits or some punctuation characters. Add in the brackets more punctuation characters to exclude them too from the found characters as per your request. Now put this mechanism to work with "sed" or whatever:

Code:
sed '/[^A-Za-z0-9.,#&@]//g' /path/to/sourcefile > /path/to/newfile

will delete all the characters not covered in the regexp and write the result to a file. Check this file and modify the regexp as necessary depending on the result.

I hope this helps.

bakunin
# 6  
Old 04-18-2008
Myscript

#!/usr/bin/ksh
sed '/[^A-Za-z0-9.,#&@]//g' /home/1.txt > /home/2.txt


it throws error like this
"sed: 0602-403 /[^A-Za-z0-9.,#&@]//g is not a recognized function."


why is it so.
did i do any mistake?

Last edited by rollthecoin; 04-18-2008 at 04:40 AM..
# 7  
Old 04-18-2008
My bad, i had a typo in the script:

Code:
sed '/[^A-Za-z0-9.,#&@]//g' /path/to/sourcefile > /path/to/newfile

should be

Code:
sed 's/[^A-Za-z0-9.,#&@]//g' /path/to/sourcefile > /path/to/newfile

bakunin
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Post Here to Contact Site Administrators and Moderators

Search for a pattern and replace a space at specific position with a Character in File

In file, we have millions of records each of 1000 in length. And at specific position say 800 there is a space, we need to replace it with Character X if the ID in that row starts with 123. So far i have used the below which is replacing space at that position to X but its not checking for... (3 Replies)
Discussion started by: Jagmeet Singh
3 Replies

2. Shell Programming and Scripting

Remove blank space and insert special character

Hi Folks, I have a huge data of the below format abc #apple 1200 06/23 ghj #orange 1500 06/27 uyt #banana 2300 05/13 efg #vegetable 0700 04/16 After first 3 letters, i have 9 spaces and after fruit there are no specific fixed space, but it varies... (4 Replies)
Discussion started by: jayadanabalan
4 Replies

3. UNIX for Dummies Questions & Answers

Replace character by blank

Hi all, I have 89 columns,1200 rows in a flat file, some of the values are just '.' (the character dot). I want to replace them by nothing (blank), but when I do so, it affects the decimal numbers too. so 12.34 becomes 1234. How can I just replace values which are only '.' with 1 white... (13 Replies)
Discussion started by: newbie83
13 Replies

4. Shell Programming and Scripting

Romove columns and replace a space with a character

Hi, I have a file containing this: testvol1 unix enabled testvol2 unix enabled testvol3 unix enabled testvol3 qtree1 unix enabled testvol3 qtree2 unix enabled testvol4 unix enabled testvol4 qtree1 unix enabled And I want an output of this: testvol1... (4 Replies)
Discussion started by: niap21
4 Replies

5. Shell Programming and Scripting

Replace newline character between a double quotes to a space

Hi Guys, I have a file with content as below aj.txt "Iam allfine" abcdef abcd "all is not well" What I'm trying to say is my data has some new line characters in between quoted text. I must get ride of the newline character that comes in between the quoted text. output must be:... (8 Replies)
Discussion started by: ajahuja
8 Replies

6. UNIX for Dummies Questions & Answers

Replace colon with blank space

Dear Gurus, I have a unix file with multiple colons on each row, and I would like to replace each colon with a blank space using the awk command. For example, I have the following data: Data: --------- A~000000000000518000~SLP:~99991231~20090701~00102.00~USD:~CS:~... (2 Replies)
Discussion started by: chumsky
2 Replies

7. Shell Programming and Scripting

Replace comma with a blank space using SED

Hello everyone, I want to replace all "," (commas) with a blank space My command thus far is: cat test.text | sed -e s/\`//g | awk '{print$1" "$2" "$3}' I'm sure you guys know this, but the SED command that I am using is to get rid of the "`" (tics). which gives me: name ... (5 Replies)
Discussion started by: jayT
5 Replies

8. Shell Programming and Scripting

how to replace a character with blank in a file

hi, I have a doubt in replacing characters with blank. My requirement is that, i have one file and looks like below 4:ALTER SYSTEM DISCONNECT SESSION '193,191' IMMEDIATE; 6:ALTER SYSTEM DISCONNECT SESSION '205,7274' IMMEDIATE; 5:ALTER SYSTEM DISCONNECT SESSION '206,34158' IMMEDIATE;... (4 Replies)
Discussion started by: sridhusha
4 Replies

9. Shell Programming and Scripting

Replace a blank space with string "\\ "

Hi, I have a requirement to replace a every blank space with char "\\ ". Like string "God Love" to "God\\ Love" and "God Love" as "God\\ \\ Love". and only in the sed. We have already a script but it is replaceing all continuous blank space with one "\\ ". which is as DIR=`sudo echo... (7 Replies)
Discussion started by: Akshay4u
7 Replies

10. Shell Programming and Scripting

How to replace all entries of comma in text file by space or other character

Hi , How to replace all entries of comma in text file by space or other character. cat temp.txt A,B,C,D I want this file to be like A B C D Please help!!! (4 Replies)
Discussion started by: prashant43
4 Replies
Login or Register to Ask a Question