Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need to log the sed command used to replace
Top Forums Shell Programming and Scripting Need to log the sed command used to replace Post 302972434 by tomj5141 on Thursday 5th of May 2016 10:12:15 AM
Old 05-05-2016
I have attached a sample document. I believe it is ASCII. I've attached it as txt but it is a dat file written in pervasive psql. Best way to view the file is with Ultra Edit.
I need to replace the "**********" with "0000000000" but only when it occurs in position(1050:1059) & position(1249:1258). The other asterisks can stay in the file. After replacing the asterisks this file gets loaded in to Oracle. I need to write to a log the position(01:20) from the line it was replaced in. So in this sample line 13 position 1249:1258 will get replaced. After replacing the asterisks, it needs to write "2y102330" to a log file. The shell script the replace command will be contained in is already creating a log file so maybe just an echo command to show which customers were updated. Echo "position(01:20)" output = "2y102330". I am not sure though.
SAMPLE.txt (2.43 MB) 
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed search and replace command

Hi, I would like to seek help on how i can arrive on this result. sample.txt: product_code IN (param001) and product_type IN (param004) product_code IN (param002) and product_type IN (param005) product_code IN (param003) and product_type IN (param006) I would like to change the param001... (1 Reply)
Discussion started by: janzper
1 Replies

2. UNIX for Dummies Questions & Answers

SED command to search for numeric and replace

Hi I am very new to linux and scripting. I need to replace numbers abc with number xyz inputting from a reference file. I used the following command - sed "s/$grd/$lab/" , where $grd and $lab comes from reference file. The problem is the above line doesnt take care of space..... (1 Reply)
Discussion started by: ajayh
1 Replies

3. Shell Programming and Scripting

Loop with sed command to replace line with sed command in it

Okay, title is kind of confusion, but basically, I have a lot of scripts on a server that I need to replace a ps command, however, the new ps command I'm trying to replace the current one with pipes to sed at one point. So now I am attempting to create another script that replaces that line. ... (1 Reply)
Discussion started by: cbo0485
1 Replies

4. Shell Programming and Scripting

Replace with a variable in sed command

Hello, I have this command and it works fine. My question is that how can we replace the N by a variable, to print for instance a big number of lines. It means if I want 100 lines after an expression, to not put "N" 100 times in the sed. Code: $ sed -n '/aaa/{n;N;N;s///g;s/;/; /g;p;}'... (2 Replies)
Discussion started by: rany1
2 Replies

5. Shell Programming and Scripting

sed command to replace a character at last

Hi All, I have a file having one line only. It is like trapsess:inform|10.232.167.18|1|1|50|25|0|0|0|5|1|1|78|0037| I want to replace the numbers in last two columns by As. It should look like trapsess:inform|10.232.167.18|1|1|50|25|0|0|0|5|1|1|AA|AAAA| Please, suggest me any shell... (12 Replies)
Discussion started by: mukeshbaranwal
12 Replies

6. Shell Programming and Scripting

search and replace with sed command

hi, suggest me in the below script.. if In above I wanna replace "" with "]". (2 Replies)
Discussion started by: divya bandipotu
2 Replies

7. Shell Programming and Scripting

sed command to find and replace

Hello All, I need a sed command to find and replace below text in multiple files in a directory. Original Text :- "$SCRIPT_PATH/files" Replace with :- "$RESOURCE_FILE" Thank you in advance !!! Regards, Anand Shah (1 Reply)
Discussion started by: anand.shah
1 Replies

8. Shell Programming and Scripting

Find and replace using sed command

The content of the file filea.txt is as follows. --------- case $HOSTNAME in aaa) DS_PARM_VALUE_SET=vsDev APT_Configuration_File=/appl/infoserver/Server/Configurations/2node.apt ;; bbb) DS_PARM_VALUE_SET=vsQA... (3 Replies)
Discussion started by: kmanivan82
3 Replies

9. Shell Programming and Scripting

sed replace command

Hi. I need to append/prefix an & character to every 'single' & character (not when there are 2 or more grouped together) I find in a file. I can do it using this cmd: cat ${file} | sed -e 's/&/&&/g' > ${new_file} How can I modify this to ensure I only replace single &'s and not operate... (11 Replies)
Discussion started by: user052009
11 Replies

10. Shell Programming and Scripting

sed Command to replace particular value.

Hi , My input file contain : list = 3 14 15 10 9 11 12 18 19 20 21 22 23 24 25 26 6 1 2 3 4 5 7 8 16 17 27 28 30 29 Expected output : list = 0 0 0 0 0 0 0 18 0 20 0 0 0 0 0 0 6 0 0 3 4 0 0 0 0 0 0 0 0 0 I want to keep the 8,10,16,17,22 value from the list and put 0 on rest of the... (9 Replies)
Discussion started by: Preeti Chandra
9 Replies

LEARN ABOUT LINUX

myisamlog

MYISAMLOG(1)						       MySQL Database System						      MYISAMLOG(1)

NAME

       myisamlog - display MyISAM log file contents

SYNOPSIS

       myisamlog [options] [log_file [tbl_name] ...]

DESCRIPTION

       myisamlog processes the contents of a MyISAM log file. To create such a file, start the server with a --log-isam=log_file option.

       Invoke myisamlog like this:

	   shell> myisamlog [options] [file_name [tbl_name] ...]

       The default operation is update (-u). If a recovery is done (-r), all writes and possibly updates and deletes are done and errors are only
       counted. The default log file name is myisam.log if no log_file argument is given. If tables are named on the command line, only those
       tables are updated.

       myisamlog supports the following options:

       o   -?, -I

	   Display a help message and exit.

       o   -c N

	   Execute only N commands.

       o   -f N

	   Specify the maximum number of open files.

       o   -i

	   Display extra information before exiting.

       o   -o offset

	   Specify the starting offset.

       o   -p N

	   Remove N components from path.

       o   -r

	   Perform a recovery operation.

       o   -R record_pos_file record_pos

	   Specify record position file and record position.

       o   -u

	   Perform an update operation.

       o   -v

	   Verbose mode. Print more output about what the program does. This option can be given multiple times to produce more and more output.

       o   -w write_file

	   Specify the write file.

       o   -V

	   Display version information.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

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

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014							      MYISAMLOG(1)
All times are GMT -4. The time now is 07:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy