Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search & Replace content of files using gsub in awk
Top Forums Shell Programming and Scripting Search & Replace content of files using gsub in awk Post 302780127 by siramitsharma on Thursday 14th of March 2013 01:10:13 AM
Old 03-14-2013
Code:
Master.txt2372,MTS,AP919848001104,Airtel,DL0819,MTS,MUM919849788001,Airtel,AP1430,Aircel MP,20Reference.txt2372,919848701430,46467919848002372,2372,471952372,919849788001,590270819,028803,10819,029801,10819,2372,1Output which is coming is as follows:MTS AP,91984870Aircel MP,4646791984800MTS AP,MTS AP,47195MTS AP,Airtel,AP59027MTS MUM,028803,1MTS MUM,029803,1MTS MUM,MTS AP,1Requirement:Only the exact match of each separator field should be replaced in reference text,i.e, output should look like as followsMTS AP,919848701430,46467919848002372,MTS AP,47195MTS AP,Airtel,AP59027MTS MUM,028803,1MTS MUM,029803,1MTS MUM,MTS AP,1

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How do I search first&second string & copy all content between them to other file?

Hi All, How do I search first string & second string and copy all content between them from one file to another file? Please help me.. Thanks In Advance. Regards, Pankaj (12 Replies)
Discussion started by: pankajp
12 Replies

2. Shell Programming and Scripting

Search & Replace in Multiple Files by reading a input file

Hi, I have a folder which contains multiple config.xml files and one input file, Please see the below format. Config Files format looks like :- Code: <application name="SAMPLE-ARCHIVE"> <NVPairs name="Global Variables"> <NameValuePair> ... (0 Replies)
Discussion started by: haiksuresh
0 Replies

3. Shell Programming and Scripting

awk and gsub - how to replace only the first X occurrences

I have a text (text.txt) and I would like to replace only the first 2 occurrences of a word (but I might need to replace more): For example, if text is this: CAR sweet head hat red yellow CAR book brown tiger CAR cow CAR CAR milk I would like to replace the word "CAR" with word... (12 Replies)
Discussion started by: bingel
12 Replies

4. Shell Programming and Scripting

awk/sed to search & replace data in first column

Hi All, I need help in manipulating the data in first column in a file. The sample data looks like below, Mon Jul 18 00:32:52 EDT 2011,NULL,UAT Jul 19 2011,NULL,UAT 1] All field in the file are separated by "," 2] File is having weekly data extracted from database 3] For eg.... (8 Replies)
Discussion started by: gr8_usk
8 Replies

5. Shell Programming and Scripting

awk + gsub to search multiple input values & replace with located string + extra text

Hi all. I have the following command that is successfully searching for any one of the strings on all lines of a file and replacing it with the instructed value. cat inputFile | awk '{gsub(/aaa|bbb|ccc|ddd/,"1234")}1' > outputFile This does in fact replace any occurrence of aaa, bbb,... (2 Replies)
Discussion started by: dazhoop
2 Replies

6. Shell Programming and Scripting

awk search/replace specific field, using variables for regexp & subsitution then overwrite file

Hello, I'm trying the solve the following problem. I have a file which I intend to use as a csv called master.csv The columns are separated by commas. I want to change the text on a specific row in either column 3,4,5 or 6 from xxx to yyy depending upon if column 1 matches a specified pattern.... (3 Replies)
Discussion started by: cyphex
3 Replies

7. Shell Programming and Scripting

Search & replace content using awk/gsub

Hi, I have two files master.txt & reference.txt. Sample below Master.txt 2372,MTS,AP 919848001104,Airtel,DL 0819,MTS,MUM 919849788001,Airtel,AP 1430,Aircel MP,20 Reference.txt 2372,919848701430,46467 919848002372,2372,47195 2372,919849788001,59027 0819,028803,1 0819,029801,1... (2 Replies)
Discussion started by: siramitsharma
2 Replies

8. Shell Programming and Scripting

Search & Replace in Multiple Files by reading a input file

I have a environment property file which contains: Input file: value1 = url1 value2 = url2 value3 = url3 and so on. I need to search all *.xml files under directory for value1 and replace it with url1. Same thing I have to do for all values mentioned in input file. I need script in unix bash... (7 Replies)
Discussion started by: Shamkamde
7 Replies

9. Shell Programming and Scripting

Replace characters in string with awk gsub

Hi I have a source file that looks like a,b,c,d,e,f,g,h,t,DISTI(USD),MSRP(USD),DIST(EUR),MSRP(EUR),EMEA-DISTI(USD),EMEA-MSRP(USD),GLOBAl-DISTI(USD),GLOBAL-MSRP(USD),DISTI(GBP), MSRP(GBP) I want to basically change MSRP(USD) to MSRP,USD and DIST(EUR) to DIST,EUR and likewise for all i'm using... (3 Replies)
Discussion started by: r_t_1601
3 Replies

10. Shell Programming and Scripting

awk gsub command to replace multiple spaces

Hi Forum. I'm trying to cleanup the following data elements (To remove any occurences of commas and any extra spaces) while preserving the <TAB> delimiter using awk gsub but I have not been successful. Original Data: 4365 monte des source rue,, ,<TAB>trevost<TAB>QC Desired Data:... (1 Reply)
Discussion started by: pchang
1 Replies

LEARN ABOUT REDHAT

xmstringsegmentcreate

XmStringSegmentCreate(library call)									       XmStringSegmentCreate(library call)

NAME

       XmStringSegmentCreate -- A compound string function that creates a compound string

SYNOPSIS

       #include <Xm/Xm.h>
       XmString XmStringSegmentCreate(
       char * text,
       XmStringTag tag,
       XmStringDirection direction,
       Boolean separator);

DESCRIPTION

       This  function is obsolete and exists for compatibility with previous releases. It can be replaced by using a combination of XmStringCompo-
       nentCreate and XmStringConcat.  XmStringSegmentCreate is a high-level function that assembles a compound string consisting of a	font  list
       element tag, a direction component, a text component, and an optional separator component.

       The  function  allocates  space	for  the  returned compound string.  The application is responsible for managing the allocated space.  The
       application can recover the allocated space by calling XmStringFree.

       text	 Specifies a NULL-terminated string to be used as the text component of the compound string.

       tag	 Specifies the tag component to be associated with the text.  The value XmFONTLIST_DEFAULT_TAG is for compatibility with  previous
		 releases.

       direction Specifies the direction of the text.

       separator A  value  of False means the compound string does not have a separator at the end. A value of True, means a separator immediately
		 follows the text component.

RETURN

       Returns a new compound string.

RELATED

       XmStringCreate(3).

													       XmStringSegmentCreate(library call)
All times are GMT -4. The time now is 11:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy