Find and Replace Pattern in file Post: 302966961

Sponsored Content

Top Forums Shell Programming and Scripting Find and Replace Pattern in file Post 302966961 by djzah on Thursday 18th of February 2016 09:19:16 AM

02-18-2016

Registered User

Find and Replace Pattern in file

Ok, so how many times have you received this request? I have been looking through the forum for examples and I see the use of tr, awk and sed to perform similar functions but not sure how to use the tools in this scenario and could use a push in the right direction.

GOAL:
Search for line breaks and replace with a unique delimiter to import into excel
IDEALLY, create headers with the first part of each line (auth user, description, role) but I can manually remove by doing a search and replace like I will do with the last character { in auth user.

DATA: useraudit.txt

Code:

auth user SVC_Qualys {
    description "SVC_Qualys"
    role guest
auth user admin {
    description "Admin User"
    role admin
auth user svc_redseal {
    description "svc_redseal"
    role resource-admin

In my newbie ways I am trying to approach it step by step so first try and get everything on one line so I created users.awk

Code:

BEGIN {
        RS="\n\n";
        FS="\n";

}
{ print $1 ", " $2 ", " $3; }

Ran awk -f users.awk useraudit.txt and I get
auth user SVC_Qualys {, description "SVC_Qualys", role guest

Not sure yet how to edit the results for the desired goal... I'll keep plugging away
Thank you for the community help. This forum has been a big help and I love the different ways people take to approach for a solution.

Last edited by vbe; 02-18-2016 at 11:44 AM.. Reason: more code tags

djzah

View Public Profile for djzah

Find all posts by djzah

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

find and replace a pattern in a file

Hi I am having 2 files file1.c and file2.c Now i want to find all the occurances of pattern "abc" in file1.c, file2.c and replace with pattern "def" using shell script without using sed and with using sed. Thanks in advance... raju

2. Shell Programming and Scripting

Find a pattern and replace using sed.

Hi I need to help on finding the below pattern using sed <b><a href="/home/document.do?assetkey=x-y-abcde-1&searchclause=photo"> and replace as below in the same line on the index file. <b><a href="/abcde.html"> thx in advance. Mari

3. Shell Programming and Scripting

Error: Find the pattern in the file and replace

Hi all, I have requirement where i need to find a pattern and replace it by new word. I used the below perl command echo `perl -p -i -e "s/AbCdEf/PqRsTu/g;" FileName.txt` But I am getting an error as below Can't do inplace edit Not a Owner and the file FileName.txt gets ...

4. Shell Programming and Scripting

Find and replace pattern in VI editor

All, I have a text file which has the following data X_SQL_13,X_SQL_14,X_SQL_15,X_SQL_16,X_SQL_17,X_SQL_18,X_SQL_19,X_SQL_20,X_SQL_21,X_SQL_22,X_SQL_23,X_SQL_24,X_SQL_25,X_SQL_26,X_SQL_27,...

5. Shell Programming and Scripting

find a pattern and replace

i have a file which contains lines like this. intsrcrpttrn1099mctrl:export GRAPHPARM_AR="-input_code M302023" intsrcrpttrn1099mload:export GRAPHPARM_AR="-input_code M192023" intsrcrpttrn1099mload:export GRAPHPARM_AR="-input_code P192023" the value after -input_code starts with some alphabet...

6. Shell Programming and Scripting

Find and Replace pattern in lowercase

I have an xml file. I need to convert a particular pattern to lower case and add 1 to it. For example my sample values in file are: ergeAAwrgersc_DWSTAGE_AC_DBO_TBL_GROUPZONES_INITIAL.badAAergerg sc_DWSTAGE_AC_DBO_TBL_SECTIONDEPENDENCY_INITIAL.badeAAwrgewrg...

7. Shell Programming and Scripting

how to find the pattern inside the file and replace it

hello everybody, I have a group of file eg- sample1 sample2 sample3 sample4 each file contain this :- cat sample1 SEQ_NUM,1,UPESI1 My requirement is to change the value-UPESI1 to UPE10 in file which contain this pattern -UPESI1. any help is appreciated.

8. Shell Programming and Scripting

find pattern and replace the text before it

i am editing a big log file with the following pattern: Date: xxxx Updated: name Some log file text here Date: eee Updated: ny Some log file text here Basically i want to remove all the text in a line before the "Updated" pattern. I sill want to print the other...

9. Shell Programming and Scripting

sed find/replace a pattern, but not this one..

I've got a file like so: ...lots of lines, etc. push "route 10.8.0.0 255.255.255.0" push "route 192.168.1.123 255.255.255.0" ...lots of lines, etc. I want to sed find/replace the IP address in the second line, whatever it is, with a new IP address, but I don't want to touch the first line....

10. Shell Programming and Scripting

Search pattern then find and replace

If condition satisfy, want to find pattern and modify two Fields in Modify.txt Input.txt SOURCE1 SOURCE2 SOURCE3 SOURCE4 SOURCE5 SOURCE6 Modify.txt SOURCE1|SLA|2016/12/11 11:12:11 PM|HMM|11-11-16| SOURCE2|SLA|2016/13/11 11:12:11 PM|HMM|10-11-16| SOURCE3|SLA|2016/14/11 11:12:11...

LEARN ABOUT SUNOS

create-auth-realm

asadmin-create-auth-realm(1AS)					   User Commands				    asadmin-create-auth-realm(1AS)

NAME

       asadmin-create-auth-realm, create-auth-realm - adds the new authorized realm

SYNOPSIS

       create-auth-realm  --user  admin_user  [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
       [--terse=false] [--echo=false] [--interactive=true] --classname realm_class [--property (name=value)[:name=value]*] auth_realm_name

       Adds the named authorized realm. This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script. Default is false.

       --echo		       setting to true will echo the command line statement on the standard output. Default is false.

       --interactive	       if set to true (default), only the required password options are prompted.

       --classname	       Java class which implements this realm.

       --property	       optional attributes name/value paris of provider implementation specific attributes.

OPERANDS

       auth_realm_name	       name of this realm.

       Example 1: Using create-auth-realm

       asadmin> create-auth-realm --user admin1 --password adminadmin1
       --host pigeon --port 5001 --classname com.iplanet.ias.security.auth.realm.DB.Database
       --property defaultuser=admin:Password=admin db
       Command create-auth-realm executed successfully

       Where db is the auth realm created.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-delete-auth-realm(1AS), asadmin-list-auth-realms(1AS)

J2EE 1.4 SDK							    March 2004					    asadmin-create-auth-realm(1AS)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

find and replace a pattern in a file

Discussion started by: krishnamaraju

2. Shell Programming and Scripting

Find a pattern and replace using sed.

Discussion started by: maridhasan

3. Shell Programming and Scripting

Error: Find the pattern in the file and replace

Discussion started by: shreekrishnagd

4. Shell Programming and Scripting

Find and replace pattern in VI editor

Discussion started by: thana