Sponsored Content
Top Forums Shell Programming and Scripting Removing last occurance of string in text Post 302551158 by Vaddadi on Monday 29th of August 2011 02:50:43 PM
Old 08-29-2011
Removing last occurance of string in text

I have text file as follows and would like to remove the last occurance of "UNION ALL" string and replace @@ with single quote (').

Input text in file is
Code:
with temp as ( 
( select -----------  where OPERATION = @@B@@ and OBJECTTYPE = @@P@@ and  start_time desc ) UNION ALL 
( select -----------  where OPERATION = @@B@@ and OBJECTTYPE = @@P@@ and  start_time desc ) UNION ALL 
( select -----------  where OPERATION = @@B@@ and OBJECTTYPE = @@P@@ and  start_time desc ) UNION ALL 
( select -----------  where OPERATION = @@B@@ and OBJECTTYPE = @@P@@ and  start_time desc ) UNION ALL 
) 
select xxxx, yyyyyy from temp with ur  ;

Output expected is
Code:
with temp as ( 
( select -----------  where OPERATION = 'B' and OBJECTTYPE = 'P' and  start_time desc ) UNION ALL 
( select -----------  where OPERATION = 'B' and OBJECTTYPE = 'P' and  start_time desc ) UNION ALL 
( select -----------  where OPERATION = 'B' and OBJECTTYPE = 'P' and  start_time desc ) UNION ALL 
( select -----------  where OPERATION = 'B' and OBJECTTYPE = 'P' and  start_time desc ) 
) 
select xxxx, yyyyyy from temp with ur  ;

Appreciate your help .

Last edited by Vaddadi; 08-29-2011 at 04:56 PM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
atReadExpand(3) 					       AtFS Toolkit Library						   atReadExpand(3)

NAME
atOpenExpand, atReadExpand, atCloseExpand - read version objects with attribute citations expanded atGetWriteName - get bound version name of a version object opened with atOpenExpand SYNOPSIS
#include <atfs.h> #include <atfstk.h> int atOpenExpand(char *version, int expand_busy) ; int atReadExpand(int desc, char *bufp, int nbytes) ; void atCloseExpand(int desc) ; char *atGetWriteName(int desc) ; extern int atBindError ; extern char atBindErrorMsg[] ; DESCRIPTION
atOpenExpand, atReadExpand, and atCloseExpand are designed as a nearly plug-compatible replacement for the system calls open(2), read(2), and close(2) for reading of AtFS version objects with attribute citations expanded. atOpenExpand opens the file or AtFS version object version for reading with atReadExpand. Version points to the pathname of a file or AtFS version object. If the flag expand_busy is non-zero, attribute citations are expanded in busy versions also. atOpenExpand returns a descriptor that is valid as argument to successive calls to atReadExpand and atCloseExpand. atReadExpand attempts to read nbytes of data from the object referenced by the descriptor desc into the buffer pointed to by bufp. If desc is zero, atReadExpand reads from the standard input. atReadExpand returns the number of bytes actually read. atCloseExpand frees the resources associated with the descriptor desc. atGetWriteName returns a pointer to the bound version name of the version object for which atOpenExpand returned the descriptor desc. DIAGNOSTICS
On error atOpenExpand and atReadExpand return -1 and set errno appropriately. If one of these returns an error and errno is set to ENOMEM, the application may retry the operation, possibly after freeing some memory. If atOpenExpand returns an error and atBindError has a non-zero value, the string version did not select a version object or not a unique version object. In this case atBindErrorMsg contains an appropriate error message. Possible Values of errno after a call to atOpenExpand: ENOMEM Not enough memory could be allocated. EMFILE All available descriptors are in use. All errno values returned by open(2) or read(2). Possible Values of errno after a call to atReadExpand: ENOMEM Not enough memory could be allocated. EBADF Invalid descriptor. BUGS
Since atOpenExpand reads the complete contents of version into memory, it fails on very large version objects. SEE ALSO
intro(2), open(2), read(2), close(2), errno(3), atattribute(3), atbind(3). AtFStk-1.12 Tue Feb 16 20:33:25 1993 atReadExpand(3)
All times are GMT -4. The time now is 12:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy