Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Edit and replace the multiple values in a file in one iteration
Top Forums Shell Programming and Scripting Edit and replace the multiple values in a file in one iteration Post 303014923 by sdosanjh on Friday 23rd of March 2018 01:13:13 PM
Old 03-23-2018
Edit and replace the multiple values in a file in one iteration
Hi All,

I am preserving OLD and NEW values and want to replace the values in one go instead of using multiple sed and mv commands. Please help.

Code:
echo "\nEnter the new qStart time '${CODE}' - (Hit Enter for No Change): \c"
read NEW
echo "\nEnter the new qStop time '${CODE}' - (Hit Enter for No Change): \c"
read NEW1
echo "\nEnter the new tStart time '${CODE}' - (Hit Enter for No Change): \c"
read NEW2
echo "\nEnter the new tStop time  '${CODE}' - (Hit Enter for No Change): \c"
read NEW3

After reading the values, doing additional checks and replacing starts at below code. Please suggest how I can do it one go instead of opening the file muultiple times and moving it across.

Code:
sed s/'\(.*.exch."${CODE}".qStart.*\)"${CURRENT}"\(.*read\)/\1"${NEW}"\2'/g $LOCK_FILE > $LOCK_FILE.new
mv $LOCK_FILE.new $LOCK_FILE

sed s/'\(.*.exch."${CODE}".qStop.*\)"${CURRENT1}"\(.*read\)/\1"${NEW1}"\2'/g $LOCK_FILE > $LOCK_FILE.new
mv $LOCK_FILE.new $LOCK_FILE

sed s/'\(.*Delay."${CODE}".tStart.*\)"${CURRENT2}"\(.*read\)/\1"${NEW2}"\2'/g $LOCK_FILE > $LOCK_FILE.new
mv $LOCK_FILE.new $LOCK_FILE

sed s/'\(.*Delay."${CODE}".tStop.*\)"${CURRENT3}"\(.*read\)/\1"${NEW3}"\2'/g $LOCK_FILE > $LOCK_FILE.new
mv $LOCK_FILE.new $LOCK_FILE

 

10 More Discussions You Might Find Interesting

1. AIX

Locking a file when using VI to prevent multiple-edit sessions by diff users

At the office, we often have to edit one file with VI. We are 4-6 workers doing it and sometimes can be done at the same time. We have found a problem and want to prevent it with a file lock. Is it possible and how ? problem : Worker-a starts edit VI session on File-A at 1PM Worker-b... (14 Replies)
Discussion started by: Browser_ice
14 Replies

2. Shell Programming and Scripting

How to edit file sections that cross multiple lines?

Hello, I'm wondering where I could go to learn how to edit file sections that cross multiple lines. I'm wanting to write scripts that will add Gnome menu entries for all users on a system for scripts I write, etc. I can search an replace simple examples with sed, but this seems more complex. ... (8 Replies)
Discussion started by: Narnie
8 Replies

3. Shell Programming and Scripting

Search for multiple string and replace with respective values

Hi, Can anyone help me to search for multiple strings within specified position and replace with respective string value. For example I need to search the string from the position 11 to 20 and if it contain ABC and then replace it by BCDEFGHIJ ... find AABZSDJIK and replace with QWE. and... (4 Replies)
Discussion started by: zooby
4 Replies

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

5. Shell Programming and Scripting

Retrieve multiple values for each iteration

Hi All, I tried to retrieve multiple values using for/foreach loop in each iteration. But couldn't get it. Please help me. Below are my try outs: #!/bin/ksh foreach {i,j,k} {5150 5540 5149 5640 5151 5920 5362 5965 5147 5895 5061} echo $i,$j,$k end Error: ./mulcns.ksh: foreach: not... (4 Replies)
Discussion started by: cns1710
4 Replies

6. Shell Programming and Scripting

Grep and replace multiple strings in a file with multiple filenames in a file

Hi, I have a file containing list of strings like i: Pink Yellow Green and I have file having list of file names in a directory j : a b c d Where j contains of a ,b,c,d are as follows a: Pink (3 Replies)
Discussion started by: madabhg
3 Replies

7. Shell Programming and Scripting

Read record from the text file contain multiple separated values & assign those values to variables

I have a file containing multiple values, some of them are pipe separated which are to be read as separate values and some of them are single value all are these need to store in variables. I need to read this file which is an input to my script Config.txt file name, first path, second... (7 Replies)
Discussion started by: ketanraut
7 Replies

8. Shell Programming and Scripting

Need Help to Edit multiple column of a file

Hello Team, I want to know if there is any one liner command , using which I can edit multiple column of a file. input file input.txt (comma separated), taran, 12.45, uttam, 23.40, babay karan, 12.45, raju, 11.40, rahulg I want to update, 2nd and 4th column, but want all those column... (8 Replies)
Discussion started by: Uttam Maji
8 Replies

9. Shell Programming and Scripting

Multiple columns replace with null values.

I am trying to replace the partcular columns(Col3,col5,col20,col44,col55,co56,col59,col60,col61,col62,col74,col75,col88,col90,col91,col93,col94,col95) with empty Input file Col1,col2,col3,col4,col5------,col100 1,2,3,4,5,---------,100 3,4,5,6,7,---------,300 Output : ... (3 Replies)
Discussion started by: onesuri
3 Replies

10. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies

LEARN ABOUT OPENSOLARIS

replace

replace(1)							  MySQL database							replace(1)

NAME

       replace	-  A utility program that is used by msql2mysql, but that has more general applicability as well. replace changes strings in place
       in files or on the standard input. Uses a finite state machine to match longer strings first. Can be used to swap strings.

USAGE

       replace [-?svIV] from to from to ... -- [files]

       or

       replace [-?svIV] from to from to ... < fromfile > tofile

SYNOPSIS

       replace [-?|-I] [-s] [-v]

DESCRIPTION

       replace

       -?|-I  info

       -s     silent

       -v     verbose

EXTRA INFO

       Special characters in from string:

       ^     Match start of line.

       $     Match end of line.

            Match space-character, start of line or end of line. For a end  the next replace starts locking at the end space-character.  A	
	      alone in a string matches only a space-character.

EXAMPLE

       this command swaps a and b in the given files:

       shell> replace a b b a -- file1 file2 ...

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1),

       For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available  online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver  1.0,  distribution	4.0.24	Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This software comes with no
       warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mercur-
       media.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000							replace(1)
All times are GMT -4. The time now is 04:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy