Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

If I want to replace txt file with somestring,which way should I go?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting If I want to replace txt file with somestring,which way should I go?
# 1  
Old 01-15-2008
If I want to replace txt file with somestring,which way should I go?
If I have txt file named "test.txt" like this

1|2|3|4|
2|3|4|5|
3|4|5|6|
4|5|6|7|

I need to replace a "|"(pipe) at the end of the line with ";"(semicolon)
it will look like this after replace

1|2|3|4;
2|3|4|5;
3|4|5|6;
4|5|6|7;

Which scripts I have to use?

Many Thanks
# 2  
Old 01-15-2008
using sed:
Code:
sed -i 's/\|$/;/' test.txt

using Perl:
Code:
perl -pi -e 's/\|$/;/' test.txt

# 3  
Old 01-15-2008
Thank you very much
Smilie
# 4  
Old 01-15-2008
If I need this way, How can I do that?

From

1|2|3|4|
2|3|4|5|
3|4|5|6|
4|5|6|7|

Change to

1|2|3|4|;2|3|4|5|;3|4|5|6|;4|5|6|7|;

Which are
replace "|" at the end of the line to "|;" (pipe and semicolon) then pull up the next line on to the same line.

Thanks again
# 5  
Old 01-15-2008
Code:
awk 'sub(/\|$/,";")' ORS= data

Use nawk or /usr/xpg4/bin/awk on Solaris.
# 6  
Old 01-15-2008
Quote:
Originally Posted by radoulov
Code:
awk 'sub(/\|$/,";")' ORS= data

Use nawk or /usr/xpg4/bin/awk on Solaris.
your command didn't work with me.
I'm in solaris 10.
And after I used your scripts,it said syntax error.

??
# 7  
Old 01-15-2008
... and you used nawk or /usr/xpg4/bin/awk as I suggested?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Replace character string in txt file using input file(S)

Hi I have a large txt file on my AIX server and I need to replace some text using two other files. So filename1 has about 500 lines similar to: txtcode SYStem100 I have the string I want to change in string2 and the new stringname in string3. Does anyone know a way of doing this? I have... (1 Reply)
Discussion started by: Grueben
1 Replies

2. Shell Programming and Scripting

Desired output.txt for reading txt file using awk?

Dear all, I have a huge txt file (DATA.txt) with the following content . From this txt file, I want the following output using some shell script. Any help is greatly appreciated. Greetings, emily DATA.txt (snippet of the huge text file) 407202849... (2 Replies)
Discussion started by: emily
2 Replies

3. Windows & DOS: Issues & Discussions

2 Questions: replace text in txt file, add text to end of txt file

so... Lets assume I have a text file. The text file contains multiple "#" symbols. I want to replace all thos "#"s with a STRING using DOS/Batch I want to add a certain TEXT to the end of each line. How can I do this WITHOUT aid of sed, grep or anything linux related ? (1 Reply)
Discussion started by: pasc
1 Replies

4. Shell Programming and Scripting

Need to append the date | abcddate.txt to the first line of my txt file

I want to add/append the info in the following format to my.txt file. 20130702|abcd20130702.txt FN|SN|DOB I tried the below script but it throws me some exceptions. <#!/bin/sh dt = date '+%y%m%d'members; echo $dt+|+members+$dt; /usr/bin/awk -f BEGIN { FS="|"; OFS="|"; } { print... (6 Replies)
Discussion started by: harik1982
6 Replies

5. Shell Programming and Scripting

Replace the .txt file between two strings in XML file

Hi i am having XML file with many number of lines,I need to replace between two strings with .txt file using awk. For ex <PersonInfoShipTo ------------------------------ /> My requirement is to replace the content between <PersonInfoShipTo ------------------------------ /> help me. Thanks... (9 Replies)
Discussion started by: Padmanabhan
9 Replies

6. Shell Programming and Scripting

awk append fileA.txt to growing file B.txt

This is appending a column. My question is fairly simple. I have a program generating data in a form like so: 1 20 2 22 3 23 4 12 5 43 For ever iteration I'm generating this data. I have the basic idea with cut -f 2 fileA.txt | paste -d >> FileB.txt ???? I want FileB.txt to grow, and... (4 Replies)
Discussion started by: theawknewbie
4 Replies

7. UNIX for Advanced & Expert Users

Find and replace txt between two strings in flat file

Hi There... I need to serach and replace strngs in a text file. My file has; books.amazon='Let me read' news.bestseller='xyz' expected output is books.amazon=NONFOUND news.bestseller=NONFOUND Can I first find the text between string1= books.amazon=' and string2= ' (locate the text... (1 Reply)
Discussion started by: Hiano
1 Replies

8. Shell Programming and Scripting

replace a string with contents of a txt file containing multiple lines of strings

Hello everyone, ive been trying to replace a string "kw01" in an xml file with the contents of a txt file having multiple lines. im a unix newbie and all the sed combinations i tried resulted to being garbled. Below is the contents of the txt file: RAISEDATTIME --------------------... (13 Replies)
Discussion started by: 4dirk1
13 Replies

9. Shell Programming and Scripting

command to list .txt and .TXT file

Hi expersts, in my directory i have *.txt and *.TXT and *.TXT.log, *.txt.log I want list only .txt and .TXT files in one command... how to ?? //purple (1 Reply)
Discussion started by: thepurple
1 Replies

10. UNIX for Dummies Questions & Answers

Binary txt file received when i use uuencode to send txt file as attachment

Hi, I have already read a lot of posts on sending attachments in unix...but none of them were of help for my problem...so here goes.. i wanna attach a text file and send to a mail id..used the following code : uuencode "$File1" "$File1" ;|mail -s "$Mail_sub" abc@abc.com it works... (2 Replies)
Discussion started by: ash22
2 Replies
Login or Register to Ask a Question