Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

sed question

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers sed question
# 1  
Old 03-27-2017
sed question
Hi Guys -

If I have the string:

Code:
alter application LOADAPP add variable TESTVAR "Test","Test1";

I need to be able to add single quotes around that entire quoted strings.

So it should look like:

Code:
alter application LOADAPP add variable TESTVAR '"Test","Test1"';

Been trying with SED and can't get it.

If I can incorporate it into my main piece of code it would be better:

Code:
awk '{for (I=1;I<=NF;I++) if ($I == "MS_IND") {print "alter application LOADAPP add variable "$(I+1)" "$(I+2)";"};}' test.txt >> new_file.txt

I'm trying to put single quotes around $(I+2) but can't seem to get it.

Thanks!
# 2  
Old 03-27-2017
Hello SIMMS7400,

Could you please try following and let me know if this helps you.
Code:
awk -vs1="'" '{match($0,/".*"/);sub(substr($0,RSTART,RLENGTH),s1 substr($0,RSTART,RLENGTH) s1);print}'   Input_file

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
SIMMS7400
# 3  
Old 03-27-2017
Thank you very much! It works for that specified line. However, it's inserting (2) ' quotes infront of the other lines. Please see below:

Code:
''alter application MS_INDR add variable ScenarioCurrent Fcst;
''alter application MS_INDR add variable FcstYear1 FY17;
''alter application MS_INDR add variable FcstYear2 FY18;
''alter application MS_INDR add variable FcstYear3 FY19;
''alter application MS_INDR add variable FcstYear4 FY20;
''alter application MS_INDR add variable FcstYear5 FY21;
''alter application MS_INDR add variable FcstMonth Jan;
''alter application MS_INDR add variable ScenarioPrior Fcst_Q1;
''alter application MS_INDR add variable ActualMonth Jan;
''alter application MS_INDR add variable ActualYear FY17;
alter application MS_INDR add variable TESTVAR '"Test","Test1"';

How can we correct that?
# 4  
Old 03-27-2017
Hello SIMMS7400,

Could you please try following and let me know if this helps you.
Code:
awk -vs1="'" '{match($0,/".*"/);if(substr($0,RSTART,RLENGTH)){sub(substr($0,RSTART,RLENGTH),s1 substr($0,RSTART,RLENGTH) s1)};print}'  Input_file

Thanks,
R. Singh
# 5  
Old 03-27-2017
Code:
awk '{ for (I=1;I<NF;I++) if ($I == "TESTVAR") { sub(/".*"/, "'\''&'\''", $(I+1)) } print }' test.txt

The '\'' trick is the key to get a literal ' within a 'string in ticks'. An example shows how it works
Code:
echo 'a literal '\'' within ticks'

A variable looks nicer
Code:
awk -v tick="'" '{ for (I=1;I<NF;I++) if ($I == "TESTVAR") { sub(/".*"/, tick "&" tick, $(I+1)) } print }' test.txt

Or, as a compromise, do the trick once in the BEGIN section
Code:
awk 'BEGIN { tick="'\''" } { for (I=1;I<NF;I++) if ($I == "TESTVAR") { sub(/".*"/, tick "&" tick, $(I+1)) } print }' test.txt

# 6  
Old 03-27-2017
Try:
Code:
awk -v q=\' '{sub(/".*"/, q "&" q)}1' test.txt



--
Sed version:
Code:
sed "s|\".*\"|'&'|" test.txt


--
Incorporated in original script:
Code:
awk -v q=\' '{for (I=1;I<=NF;I++) if ($I == "MS_IND") print "alter application LOADAPP add variable " q $(I+1) " " $(I+2) q ";"}' test.txt >> new_file.txt

Last edited by Scrutinizer; 03-27-2017 at 03:38 PM..
# 7  
Old 03-27-2017
This can be done with

Code:
sed "s/\".*\"/'&'/" file

But I'm guessing the input data you've shown isn't really representative of your actual requirements Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SED question

I am trying to write a script that will take an input text file in the format person: place: phonenumber; person: place: phonenumber; person: place: phonenumber; ... and output it using sed too: Name ######## Location ######### Phone Number... (1 Reply)
Discussion started by: jmack56
1 Replies

2. Shell Programming and Scripting

Sed question

I need to replace the numbers with a new string. How can I give a wildcard for the different # of numbers sed '/abcdef/s/abcdef=*/abcdef=999999/'<foo>foo1 From: To: abcdef=1234 abcdef=999999 abcdef=12345 abcdef=999999 abcdef=123456... (10 Replies)
Discussion started by: beppler
10 Replies

3. Shell Programming and Scripting

sed question

hi i have a file with this line: variable=/export/home/oracle I want to change the file so that the path is replaced with the value of another variable var2=/tmp/anything. how to do this in sed? thx (4 Replies)
Discussion started by: melanie_pfefer
4 Replies

4. Shell Programming and Scripting

Sed Question 1. (Don't quite know how to use sed! Thanks)

Write a sed script to extract the year, rank, and stock for the most recent 10 years available in the file top10_mktval.csv, and output in the following format: ------------------------------ YEAR |RANK| STOCK ------------------------------ 2007 | 1 | Exxon... (1 Reply)
Discussion started by: beibeiatNY
1 Replies

5. UNIX for Dummies Questions & Answers

sed question

How would I use sed to print everything on the line after the regular expresion? I have a configuration file setting several variables. cfg.dat DDB = cpptest SUDBNAME = sucpptestdb host = cpptest Example I want to search for the regular expresion 'SUDBNAME =' and print everything on... (3 Replies)
Discussion started by: orahi001
3 Replies

6. Shell Programming and Scripting

sed question

I have a file that conatins following info Policy1=U|guestRoom=test1idCode=5(1):!:Amenity2=U|RoomId=testrma=4(1):!:| GuestRoomAmenity1=U|guestRoomId=testguest1id^rmaCode=5(1):!:| I need it to look like this Policy1=U|guestRoom=test1idCode Amenity2=U|RoomId=testrmaCode... (2 Replies)
Discussion started by: arushunter
2 Replies

7. Shell Programming and Scripting

sed question

Hi, :) can any body explain the following statement sed 's/\(\)- ]//g' cheers RRK (3 Replies)
Discussion started by: ravi raj kumar
3 Replies

8. Shell Programming and Scripting

sed question

Hi, When deleting lines using sed, as i understand the lines are redirected to the standard output. What i'm unclear about is how to actually modify the file? If I write the command sed '1,2d' test it will display lines one and 2 onto the screen however the file is not modified? I think my... (5 Replies)
Discussion started by: c19h28O2
5 Replies

9. Shell Programming and Scripting

sed question (again)

hello there, I have a sed question. I have a file (temp.srv), in it it has v1_host1 v2_host2 And I have another file (temp2.srv), in it is has v1_host3_date v1_host1 v2_host2 v2_host4_date v3_host5_date I had used a script to remove the name from temp2.srv base on the name inside... (3 Replies)
Discussion started by: ahtat99
3 Replies

10. Shell Programming and Scripting

Sed Question

Hi, Is there any way to traverse the file once and look for the following conditions in one sweep instead of going over the file 3 times with different search criteria...... sed -n '/^ORA-07445/ p' /tmp/t$$ > ${OERRFILE} sed -n '/^ORA-00600/ p' /tmp/t$$ >> ${OERRFILE} ... (1 Reply)
Discussion started by: YS2002
1 Replies
Login or Register to Ask a Question