Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Replacing characters in a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Replacing characters in a file
# 8  
Old 07-15-2014
Hi Rudy,

Yes, that's the thing what I want to achieve in the task.
# 9  
Old 07-15-2014
Yes that is a totally different thing. Eleborating on RudiC's suggestion, try:
Code:
awk '{for(i=1; i<=NF; i++) if(NR==FNR) {if($i==s) A[i]} else if(i in A) $i=s}NR>FNR' s="0 0" FS='\t' OFS='\t' file file

The input file is specified twice..

--edit--
This is perhaps easier to read / understand :
Code:
awk 'NR==FNR{for(i=1; i<=NF; i++) if($i==s) A[i]; next} {for(i=1; i<=NF; i++) if(i in A) $i=s}1' s="0 0" FS='\t' OFS='\t' file file

Last edited by Scrutinizer; 07-15-2014 at 06:17 PM..
This User Gave Thanks to Scrutinizer For This Post:
rossi
# 10  
Old 07-15-2014
Am I missing something here or are the TABS inside the inverted commas NOT the characters?

Copied and pasted into the shell:-
Code:
Last login: Tue Jul 15 21:01:35 on ttys000
AMIGA:barrywalker~> printf 'A A"\t"C C"\t"G G"\t"0 0"\t"T T
> A G"\t"C C"\t"G G"\t"A T"\t"0 0
> G A"\t"0 0"\t"G C"\t"A A"\t"T C
> '
A A"	"C C"	"G G"	"0 0"	"T T
A G"	"C C"	"G G"	"A T"	"0 0
G A"	"0 0"	"G C"	"A A"	"T C
AMIGA:barrywalker~> _

# 11  
Old 07-15-2014
I interpreted it to mean that "\t" represents a TAB character..
# 12  
Old 07-15-2014
You are right Scrutinizer.
I am bad in posting the file format as I always get confused how to do it properly here. Next time, I will do it more carefully.

But the last script from you works perfectly fine. It's wonderful.

Thank you so much to you and thanks everyone for the suggestions as well.
# 13  
Old 07-15-2014
Quote:
Originally Posted by rossi
You are right Scrutinizer.
I am bad in posting the file format as I always get confused how to do it properly here. Next time, I will do it more carefully.
As long as you use code tags ( see moderator comment in post #1), you should be fine...
Quote:
But the last script from you works perfectly fine. It's wonderful.

Thank you so much to you and thanks everyone for the suggestions as well.
You're welcome Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Any tip to replacing the special characters in a file

Hi, Please find attached a file that has special characters on it. It is a copy and paste from a Micro$oft file. I don't want to use strings as it remove all the 'indentations' / 'formatting' so I am replacing them with space instead. I am using the sed command below sed "s/$(printf... (1 Reply)
Discussion started by: newbie_01
1 Replies

2. HP-UX

Replacing Hex Characters In A File Using awk?

Hi guys, First off, i'm a complete noob to UNIX and LINUX so apologies if I don't understand the basics! I have a file which contains a hex value of '0D' at the end of each line when I look at it in a hex viewer. I need to change it so it contains a hex value of '0D0A0A' I thought... (10 Replies)
Discussion started by: AndyBSG
10 Replies

3. Shell Programming and Scripting

sed replacing specific characters and control characters by escaping

sed -e "s// /g" old.txt > new.txt While I do know some control characters need to be escaped, can normal characters also be escaped and still work the same way? Basically I do not know all control characters that have a special meaning, for example, ?, ., % have a meaning and have to be escaped... (11 Replies)
Discussion started by: ijustneeda
11 Replies

4. Shell Programming and Scripting

Translating/Replacing characters in a file

Hi, i have a given file named hugo.dat. In this file there are several lines that contain characters like } and ~ Now, i need a script that replaces the character } to ü and character ~ to ß Can anyone help for a working ksh script? Kind Regards FranzB (3 Replies)
Discussion started by: FranzB
3 Replies

5. UNIX for Dummies Questions & Answers

Replacing digit with characters in a file

Hi, I have a file with 40 columns out of which 15 are amount fields. There are approximately 6 mn records in this file. The file has data in following format: 123A,Ank,00.468,US,IL,780,53489 253A,Tng,-00.456,US,CA,452,46781 363A,nkk,-00.023,US,NJ,539,09625 I need to take all amount fields... (1 Reply)
Discussion started by: wahi80
1 Replies

6. UNIX for Dummies Questions & Answers

Replacing characters in csv file

Hello all, This is my first post here, so please excuse me if this question is too obvious or has been asked before. I am new to Unix and although I tried to search your forum for the answer to my question, I could not find an answer that would help me. I have a 500MB csv file with numeric values... (1 Reply)
Discussion started by: finwhiz
1 Replies

7. UNIX for Dummies Questions & Answers

replacing the characters in a file

hi i want to replace the characters between positions 2 to 30 in each line in a file how to do it suggestions welcome (2 Replies)
Discussion started by: trichyselva
2 Replies

8. Shell Programming and Scripting

Help Replacing Characters in Flat File

I was wondering if somebody could help me with something on UNIX. I have a file that looks like this - "nelson,bill","bill","123 Main St","Mpls","MN",55444,8877,william I want to replace all comma with pipes (|), except if the comma is within double quotes. (The first field is an example of... (8 Replies)
Discussion started by: nelson553011
8 Replies

9. Shell Programming and Scripting

Replacing characters in file with line break

Hi, Apologies if this has been asked before, but I searched and was not able to find an answer. It's probably a simple question to answer for those of you with some experience, though... I have a relatively long string where tokens are separated by the colon (':') character. Let's say the... (10 Replies)
Discussion started by: johnemb
10 Replies

10. UNIX for Dummies Questions & Answers

replacing few characters in a file

Hi All, I have huge xml file. The file contains some comment tags . I have requirement to replace comment tag with another comment tag. Say for example : file X has -- Part of the file <?xml version="1.0" encoding="ISO-2"?><translationResults jobDate="20070123 23:20:51"... (1 Reply)
Discussion started by: purnakarthik
1 Replies
Login or Register to Ask a Question