Replace a character with other


 
Thread Tools Search this Thread
# 1  
Replace a character with other

Hi All,
I am having the below sample lin in the file.
Code:
'''||V_D_BOOKING_TYPE||''' || '''' || '''||V_D_SHARE_DELIV_FL||''' || '''' || '''|| SUBSTR(V_D_FINANCIALDATATYPE,1,1) ||''' || '''' ||

I need to replace '''' with char(172). how do i do it.
PLease help.


Code:
sed 's/\''\''/chr(172)/g' test.txt  # not correct.


Last edited by Scott; 12-08-2012 at 11:42 AM.. Reason: Code tags
# 2  
Try:
Code:
sed "s/''/chr(172)/g" test.txt

# 3  
I'm a bit surprised: ASCII chr(172) (decimal 172) IS. What your purpose of replacing it? Or do you mean the literal string "chr(172)"?
# 4  
Quote:
Originally Posted by RudiC
I'm a bit surprised: ASCII chr(172) (decimal 172) IS. What your purpose of replacing it? Or do you mean the literal string "chr(172)"?
The sed command I suggested assumes that abhi_123 wanted the literal string "chr(172)". The byte with decimal value 172 is not as ASCII character at all. (ASCII only defines bytes with values 0 through 127 and a character with the glyph is not one of them.) The EBCDIC character representing the glyph has decimal value 95. The ISO/IEC 8859-1 glyph for the character with decimal value 172 is . The 8859-2 glyph for the character with decimal value 172 is Ť. The 8859-3 glyph for the character with decimal value 172 is Ĵ...

Probably more important, however, is that in UTF-8 (which is becoming more common as a code set AND appears to be the encoding used in the input abhi_123 supplied) the two byte character representing the glyph has bytes with decimal values 194 and 172 (in that order) and the single byte with decimal value 172 is an encoding error.

If abhi_123 is trying to convert an input file encoded in UTF-8 into a file encoded in 8859-1, the iconv utility should be used instead of trying to map an individual character's value into an invalid character in the output data stream being written by sed.
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace the character

Hi All, I have a file with below format, columns are separated by , 1575957.86,2186027.51,3092745.98,4320856.55,2536012.28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,,,,,,,, I want to... (9 Replies)
Discussion started by: manas_ranjan
9 Replies

2. UNIX for Advanced & Expert Users

Replace certain character at specific place with related character

hello i have file with 100k records and each one has certain value that starts at 28th column and certain value that starts at 88th column e.g. 1st file <25>1234567 ..... <88> 8573785485 i have aditional file with values which are related to value that starts at 88th column of the... (1 Reply)
Discussion started by: dell1520
1 Replies

3. Shell Programming and Scripting

Find character and Replace character for given position

Hi, i want find the character '-' in a file from position 284-298, if it occurs i need to replace it with 'O ' for the position in the file. How to do that using SED command. thanks in advance, Sara (9 Replies)
Discussion started by: Sara183
9 Replies

4. Shell Programming and Scripting

Replace multiple occurances of same character with a single character.

Hi all, Greetings, I have the following scenario, The contents of main file are like : Unix|||||forum|||||||||||||||is||||||the||best so||||||be|||||on||||||||||||||||||||||||||||||||||||||||||||it And i need the output in the following form: Unix=forum=is=the=best so=be=on=it ... (3 Replies)
Discussion started by: dipanchandra
3 Replies

5. Shell Programming and Scripting

replace character with '

ive tried doing sed -i 's/h/\'/g' file.txt to replace h with ' but it doesnt work:confused:. Any ideas would be greatly appreciated. (3 Replies)
Discussion started by: lyman1216
3 Replies

6. Shell Programming and Scripting

In Sed how can I replace starting from the 7th character to the 15th character.

Hi All, Was wondering how I can do the following.... I have a String as follows "ACCTRL000005022RRWDKKEEDKDD...." This string can be in a file called tail.out or in a Variable called $VAR2 Now I have another variable called $VAR1="000004785" (9 bytes long), I need the content of... (5 Replies)
Discussion started by: mohullah
5 Replies

7. Shell Programming and Scripting

Replace 2 Character With One Using tr

Hi, I have an XML file which is all on one line. <?xml version="1.0" encoding="utf-8"?><FUNCTION><PRODUCTS><PRODUCT CODE="PROD1" ACTION="amend" VALIDATE="no"><SUPPLIER PRODUCT="SUPPPROD1" ACTION="amend" CODE="SUPPLIER"><STOCK_QUANTITY DATA="291"></STOCK_QUANTITY> <STOCK_DATE... (3 Replies)
Discussion started by: Ste_Moore01
3 Replies

8. Shell Programming and Scripting

replace a character with another character

hi i have a string var=abc.ghi.jkl.mno.pqr now i need to replace .(dot) with _(underscore) the result should be like "arresult=abc_def_ghi_jkl_mno_pqr" Please help (8 Replies)
Discussion started by: satish@123
8 Replies

9. Shell Programming and Scripting

read in a file character by character - replace any unknown ASCII characters with spa

Can someone help me to write a script / command to read in a file, character by character, replace any unknown ASCII characters with space. then write out the file to a new filename/ Thanks! (1 Reply)
Discussion started by: raghav525
1 Replies

10. UNIX for Dummies Questions & Answers

replace character with tr

Hi, i would like substitute the words containing the character "-" by any other. i've already tried the tr command: tr '\-' 'X', for example. But, this command doesn't work. It gave this: Original text: -i abcd-fe Result text: Xi abcdXfe Result desired: -i abcdXfe Thanks! ;) (3 Replies)
Discussion started by: tmxps
3 Replies

Featured Tech Videos