Append a particular string after occurrence of particular string. Post: 303039538

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Append a particular string after occurrence of particular string. Post 303039538 by ram0106 on Wednesday 9th of October 2019 05:17:48 AM

10-09-2019

Registered User

Append a particular string after occurrence of particular string.

Hi Friends,

Good morning.

Appended a particular string after occurrence of particular string in a file.

my file abc.sql as below

Code:

create or replace  function f1(p_cust_no IN VARCHAR)
RETURN number IS
DECLARE
v_country country.customer_tbl%TYPE;	
    begin
    	begin
	    select country
	    into v_country
	    from customer_tbl;

exception
when others
then
bbk.createmsg(MST.notexisted(),'notexisted',p_cust_no);
pfg := false;
				
v_msgtext := bbk.createmsg(MST.isterminated(),
                                      'isterminated',
    	    	    	    	       v_gst,
    	    	    	    	       v_country,
                                      p_cust_no);
							  
pfg := false;				
			
 	    v_msgtext := bbk.createmsg(MST.isterminated(),
                                      'isterminated',
    	    	    	    	      v_cgst,
    	    	    	    	       v_country,
                                      p_cust_no);
								  
pfg := false;			

end;

In the given input file Where ever is bbk.createmsg existed in that after second occurrence of ",". Every thing should be appended with tstcre.noconvert().

The expected output would be

Code:

bbk.createmsg(MST.notexisted(),'notexisted',tstcre.noconvert(p_cust_no));

v_msgtext := bbk.createmsg(MST.isterminated(),
                                      'isterminated',
    	    	    	    	       tstcre.noconvert(v_gst),
    	    	    	    	       tstcre.noconvert(v_country),
                                      tstcre.noconvert(p_cust_no));
							  
v_msgtext := bbk.createmsg(MST.isterminated(),
                                      'isterminated',
    	    	    	    	      tstcre.noconvert(v_cgst),
    	    	    	    	       tstcre.noconvert(v_country),
                                      tstcre.noconvert(p_cust_no));

Please help me .
Thanks in advance.

ram0106

View Public Profile for ram0106

Find all posts by ram0106

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search a string and append text after the string

Hi, I have a file like this... <o t="Batch" id="8410" p="/" g="32"> <a n="name"> <v s="DBBA1MM"/> </a> <a n="owner"> <v r="/Administrator"/> </a> <a n="rights"> <v s="95"/> </a> <a n="debugLevel"> <v s="3"/> </a> <a n="avsStoreLoc"> <v...

2. Shell Programming and Scripting

Displaying only First Occurrence of a String

Hi, My requirement is that I should search for a particular string and display the string only once if there is more occurrence of the same string in a file. e.g In the given below log file,the string AMQ5037 comes twice.I want to search for this string and display it only once.grep will...

3. Shell Programming and Scripting

remove characters from string based on occurrence of a string

Hello Folks.. I need your help .. here the example of my problem..i know its easy..i don't all the commands in unix to do this especiallly sed...here my string.. dwc2_dfg_ajja_dfhhj_vw_dec2_dfgh_dwq desired output is.. dwc2_dfg_ajja_dfhhj it's a simple task with tail...

4. UNIX for Dummies Questions & Answers

Append a string on the next line after a pattern string is found

Right now, my code is: s/Secondary Ins./Secondary Ins.\ 1/g It's adding a 1 as soon as it finds Secondary Ins. Primary Ins.: MEDICARE B DMERC Secondary Ins. 1: CONTINENTAL LIFE INS What I really want to achieve is having a 1 added on the next line that contain "Secondary Ins." It...

5. Shell Programming and Scripting

Append a searched string with another string using sed

Hi, I need to replace and append a string in a text if grep is true. For eg: grep ABC test.txt | grep -v '\.$' | awk {'print $4'} | sed "s/ ? How do I replace all instances of "print $4" using sed with another sring? Eg of the string returned will be, lx123 web222 xyz Want to...

6. Shell Programming and Scripting

How to append a string by comparing another string?

Hi , I have one file like BUD,BDL BUDCAR BUD,BDL BUDLAMP ABC,CDF,KLT ABISKAR ABC,CDF,KLT CORNEL ABC,CDF,KLT KANNAD JKL,HNM,KTY,KJY JAGAN JKL,HNM,KTY,KJY HOUSE JKL,HNM,KTY,KJY KATAK JKL,HNM,KTY,KJY KOLKA The o/p should be like BUD,BDL BUDCAR,BUDLAMP ABC,CDF,KLT...

7. Shell Programming and Scripting

How to append string checking other same string?

8. Shell Programming and Scripting

Find a string occurrence if twice in a line

Hello All, I want to check if a delimiter is existing twice in a line of a text file. Suppose flat file is like this 234 | 123 123 | 345 456 | 563 | 234 | 548 So the the 3rd line has two delimiters, How can we find the lines in such a file having more then one delimiters I tried...

9. Shell Programming and Scripting

Find string in file and append new string after

Hi All, I'm trying to insert a string into a file at a specific location. I'd like to add a string after the parent::__construct(); in my file. <?php if (! defined('BASEPATH')) exit('No direct script access allowed'); class MY_Controller extends CI_Controller { function...

10. Shell Programming and Scripting

[Solved] Last occurrence of a string

I apologize if it was asked before but I couldn't find something related. I want to replace 2 strings in a file e.g pwddb=Lar1wod (need to replace string after =) pwdapp=Wde2xe (need to replace string after =) AND in same file want to find last occurrence of a string (SR2-134561),...

LEARN ABOUT PHP

geoip_country_name_by_name

GEOIP_COUNTRY_NAME_BY_NAME(3)						 1					     GEOIP_COUNTRY_NAME_BY_NAME(3)

geoip_country_name_by_name - Get the full country name

SYNOPSIS

       string geoip_country_name_by_name (string  $hostname)

DESCRIPTION

	The geoip_country_name_by_name(3) function will return the full country name corresponding to a hostname or an IP address.

PARAMETERS

	      o $hostname
		- The hostname or IP address whose location is to be looked-up.

RETURN VALUES

	Returns the country name on success, or FALSE if the address cannot be found in the database.

EXAMPLES

       Example #1

	      A geoip_country_name_by_name(3) example

	       This will print where the host example.com is located.

	      <?php
	      $country = geoip_country_name_by_name('www.example.com');
	      if ($country) {
		  echo 'This host is located in: ' . $country;
	      }
	      ?>

	      The above example will output:

	      This host is located in: United States

SEE ALSO

       geoip_country_code_by_name(3), geoip_country_code3_by_name(3).

PHP Documentation Group 											     GEOIP_COUNTRY_NAME_BY_NAME(3)