Removing last occurance of string in text

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Removing last occurance of string in text
# 8  
Old 08-29-2011
You have a space at the end of the lines, remove the '$' sign after UNION ALL:
awk -v q="'" '/UNION ALL/{
  gsub("@@",q); if(s)print s; s=$0; f=1; next}
  sub(" UNION ALL",x,s) ;print s;f=0; s=""
1' file

# 9  
Old 08-29-2011
The "awk" solution will delete the last line for the input:
select xxxx, yyyyyy from temp with ur ;
( select ----------- where OPERATION = '5' and OBJECTTYPE = 'P' and start_time desc ) UNION ALL
( select ----------- where OPERATION = '6' and OBJECTTYPE = 'P' and start_time desc ) UNION ALL
( select ----------- where OPERATION = '7' and OBJECTTYPE = 'P' and start_time desc ) UNION ALL )

The following code will remove the last occurrence of "UNION ALL":
while read mLine; do
  mCnt=$(echo ${mLine} | egrep -c "${mUA}")
  if [[ "${mCnt}" = "0" ]]; then
  if [[ "${mFound}" = "N" ]]; then
    if [[ "${mLastFound}" = "Y" ]]; then
      mLast=$(echo ${mLast} | sed "s/${mUA}//")
  if [[ "${mLast}" != "FIRST" ]]; then
    echo ${mLast}
done < Input_File
if [[ "${mLast}" != "FIRST" ]]; then
  if [[ "${mLastFound}" = "Y" ]]; then
    mLast=$(echo ${mLast} | sed "s/${mUA}//")
  echo ${mLast}

# 10  
Old 08-29-2011
 $(cat file);echo $data | rev | sed "s/LLA NOINU//;s/@@/\'/g" | rev

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Insert text after the first occurance of searched string entry in a file

My server xml file has huge data part of which i'm sharing below. I wish to add the below text held by variable "addthisline" after the closing braces i.e --> once the first </Connector> tag is found. addthisline="I need to be inserted after the comments" Thus my searchstring is... (3 Replies)
Discussion started by: mohtashims
3 Replies

2. Shell Programming and Scripting

[Need help] perl script to find the occurance of string from a text file

I have two files 1. input.txt 2. keyword.txt input.txt has contents like .src_ref 0 "call.s" 24 first 0x000000 0x5a80 0x0060 BRA.l 0x60 .src_ref 0 "call.s" 30 first 0x000002 0x1bc5 RETI .src_ref 0 "call.s" 31 first 0x000003 0x6840 ... (2 Replies)
Discussion started by: acdc
2 Replies

3. Windows & DOS: Issues & Discussions

Removing anything from text file except specific string

So, I have a text file that looks like this: 0,0: (168,168,176) #A8A8B0 srgb(168,168,176) 1,0: (168,168,176) #A8A8B0 srgb(168,168,176) 2,0: (166,166,174) #A6A6AE srgb(166,166,174) 3,0: (166,166,174) #A6A6AE srgb(166,166,174) 4,0: (168,168,176) #A8A8B0 srgb(168,168,176) 5,0:... (0 Replies)
Discussion started by: pasc
0 Replies

4. Shell Programming and Scripting

replace every second occurance of a string

I want to replace every 2nd occurance of a string/character from a line. ababacbsbddbsbbcbdbssb i want to replace every s2nd b with @ like below should be like aba@acbs@ddbs@bc@dbss@ (3 Replies)
Discussion started by: ratheeshjulk
3 Replies

5. Shell Programming and Scripting

extract till occurance of a string

hi , i have an xml that comes in a single, the entire xml file is read as a single line when i open in edit plus or unix. i need to amend the contents of this xml file. below is the extract from the file <rpc-reply xmlns="urn:ietf:params:xml:ns:netconf:base:1.0"... (5 Replies)
Discussion started by: sais
5 Replies

6. UNIX for Dummies Questions & Answers

Removing a string of text from a file - help please

Hey Folks, I have a file that contains data that I am working with, sometimes this file has a very long string of text that messes with an awk command in a script i am trying to build. I would like to cut this string of text out of a file and then redirect everything except that string to a new... (5 Replies)
Discussion started by: deepslp
5 Replies

7. Shell Programming and Scripting

How can I match lines with just one occurance of a string in awk?

Hi, I'm trying to match records using awk which contain only one occurance of my string, I know how to match one or more (+) but matching only one is eluding me without developing some convoluted bit of code. I was hoping there would be some simple pattern matching thing similar to '+' but... (9 Replies)
Discussion started by: jonathanm
9 Replies

8. UNIX for Dummies Questions & Answers

String search - Command to find second occurance

Hi, I am new to Unix world. Is there any command which can directly return the second occurance of a particular string in a file? Basically, I want to read the contents of the file from the second occurance of a particualr string. Can be implemented using a loop, but am just wondering if there... (5 Replies)
Discussion started by: saurabhsinha23
5 Replies

9. UNIX for Dummies Questions & Answers

count string occurance in a file hourly

Hi, I file that has all the status for one day (24hours). Now what I want to do is to count the occurence of a string in its output hourly like for example count occurance of successful or asynchronous clear destinon for every hour and redirect it to file. Please see sample file below. Please... (2 Replies)
Discussion started by: ayhanne
2 Replies

10. Shell Programming and Scripting

Removing the last occurance of string

I have a small query. I have a file containing the following lines abcd<12></12>fdfgdf<12>sdfgfg<12> sdfsdf<12></12>ytunfg<12> hggfhf<12>rtysb<12>zdfgdfg<12> Now I wish to delete ONLY the last occurance of string <12> from every lines of code. That mease my final output will be like this:... (7 Replies)
Discussion started by: dkhanna01
7 Replies
Login or Register to Ask a Question