Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: using substring in shell script
Top Forums Shell Programming and Scripting using substring in shell script Post 302248113 by kmanivan82 on Friday 17th of October 2008 03:27:52 AM
Old 10-17-2008
There is a file called rcbl2_`date +%Y%m%d`.log

It consists of the following

Code:
ABC123 10 01/02/2008 2008-01-03-00.00.00.000000
DYUU   22 02/03/2008 2008-01-04-00.00.00.000000
RF33   88 03/05/2008 2008-01-05-00.00.00.000000

For sample I have given 3 records. But in production there will be n number of records.
So I am reading line by line in a loop.

The first field trackingnum will be in the position 1-6
The field trackingnumsuffix will be in the position 8-9
the tstmpupdated will be in the position 22-57

Code:
while read line
do

	trackingnum=`expr substr $line 1 6`
	trackingnumsuffix=`expr substr $line 8 9`
	tstmpupdated=`expr substr $line 22 57`
	db2 "SELECT * FROM ZB_RCBL_ERROR_MSG_MIG WHERE TRACKING_NUM = $TRACKING_NUM AND TRACKING_NUM_SUFFIX = $TRACKING_NUM_SUFFIX AND TIMESTAMP_UPDATED = $TIMESTAMP_UPDATED WITH UR" >> new.log

done < "rcbl2_`date +%Y%m%d`.log"

Please advice how to proceed furthur.

Krishnakanth
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Substring in C shell script?

i am a new user of C-shell script. I want to know can i create a substring in a string. That means when i got a variable $input = "it is number 2" I want to get the "2" to be another variable. Can i do that in C-shell and how to ? Thank you so much dinodash (0 Replies)
Discussion started by: dinodash
0 Replies

2. Shell Programming and Scripting

Substring function in UNIX shell script

Hi All, Following is the output of a find commnd to locate log directories for various projects of UNIX AIX box: /home/hbinz6pf/projectlibs/dpr_pfsdw_dev/&PH& /opt/tools/ds/Template/&PH& /data/ds/ms/hmsdw/projectlibs/dpr_ms_dev/&PH& /data/ds/riskmi/projectlibs/dpr_riskmi_dev/&PH&... (1 Reply)
Discussion started by: csrazdan
1 Replies

3. UNIX for Dummies Questions & Answers

Substring function in UNIX shell script

Hi All, Following is the output of a find commnd to locate log directories for various projects of UNIX AIX box: /home/hbinz6pf/projectlibs/dpr_pfsdw_dev/&PH& /opt/tools/ds/Template/&PH& /data/ds/ms/hmsdw/projectlibs/dpr_ms_dev/&PH& /data/ds/riskmi/projectlibs/dpr_riskmi_dev/&PH&... (5 Replies)
Discussion started by: csrazdan
5 Replies

4. UNIX for Dummies Questions & Answers

Substring in Shell Script

Hi I'm new to Shell scripting. Someone please help me in extracting a portion of string from a file. Eg: I got a file like, Readme.txt and has the following name value pairs input1 : /homes/input1/ input2 : /homes/input2/ ... ... When I give the parameter input1, the value... (3 Replies)
Discussion started by: smartbuddy
3 Replies

5. Shell Programming and Scripting

help for shell script of finding shortest substring from given string by user

please give me proper solution for finding a shortest substring from given string if string itself and first char and last char of that substr are also given by user if S="dpoaoqooroo" and FC="o" and LC="o",then shortest substr is "oo" and rest of the string is "dpoaoqroo" i have code but it is... (1 Reply)
Discussion started by: pankajd
1 Replies

6. Shell Programming and Scripting

Substring in shell script

I need a help in getting substring of each line in input file. I am writing a script that will read a file from a directory on daily basis, I mean everyday a new file will be stored in this directory, it will replace old file. I have to read contents of this file, the contents will be as... (5 Replies)
Discussion started by: jyotib
5 Replies

7. Shell Programming and Scripting

shell script for extracting out the shortest substring from the given starting and en

hi all, i need an urgent help for writing a shell script which will extract out and print a substring which is the shortest substring from the given string where first and last character of that substring will be given by the user. for e.g. if str="abcdpqracdpqaserd" now if the user gives 'a'... (18 Replies)
Discussion started by: pankajd
18 Replies

8. Shell Programming and Scripting

Need help with Korn Shell script for substring printing

Hi all, I am new to scripting. I have a file with colon separated values called mylist.txt cat mylist.txt 192.123.76.89:lmprod89 162.122.20.28:lmtstserver28 10.80.32.139:hewprod139 . . using our internal os utility (called mvsping) we need to check all these servers if they are... (6 Replies)
Discussion started by: kraljic
6 Replies

9. Shell Programming and Scripting

Substring check in IF condition in shell script

I want to check if the string has the substring in IF condition then process... i tried below but not working if ]; then ............. field can be "reserved1" ....reservedn / fillspaces1 ... fillspacesn (4 Replies)
Discussion started by: greenworld123
4 Replies

10. Shell Programming and Scripting

Script Shell Extract substring

Hi all, Please, i'd like to extract string just before '.fr'. Here is some lines of my file: g-82.text.text1.fr.worker1 g-xx.yyyyyy.zzzz.fr.worker2 i'd like to extract this text: g-82.text.text1 g-xx.yyyyyy.zzzz Please, which command i have to use in my script shell ? ... (16 Replies)
Discussion started by: chercheur111
16 Replies

LEARN ABOUT DEBIAN

trash-empty

TRASH-EMPTY(1)						      General Commands Manual						    TRASH-EMPTY(1)

NAME

       trash-empty - Empty for Command line trash utility.

SYNOPSIS

       trash-empty [arguments]

DESCRIPTION

       Remove for ever any trashed file and trashed directory.	This command is a part of trash-cli package that provides a command line interface
       trashcan utility compliant with the FreeDesktop.org Trash Specification.  It remembers the name, original path, deletion date, and  permis-
       sions of each trashed file.

ARGUMENTS

       To remove all trashed files, use 'emtpy-trash'.

       To remove files that have been in the trash more than a given number of
	      days, use 'trash-empty x', 'x' representing the number of days.

EXAMPLES

       $ date
       Tue Feb 19 20:26:52 CET 2008
       $ trash-list
       2008-02-19 20:11:34 /home/einar/today
       2008-02-18 20:11:34 /home/einar/yesterday
       2008-02-10 20:11:34 /home/einar/last_week
       $ trash-empty 7
       $ trash-list
       2008-02-19 20:11:34 /home/einar/today
       2008-02-18 20:11:34 /home/einar/yesterday
       $ trash-empty 1
       $ trash-list
       2008-02-19 20:11:34 /home/einar/today
       $ trash-empty
       $ trash-list
       <none>

BUGS

       Report bugs to http://code.google.com/p/trash-cli/issues

AUTHORS

       Trash  was  written by Andrea Francia <andreafrancia@users.sourceforge.net> and Einar Orn Olason <eoo@hi.is>.  This manual page was written
       by Steve Stalcup <vorian@ubuntu.com>.  Changes made by Massimo Cavalleri <submax@tiscalinet.it>.

SEE ALSO

       trash-put(1), trash-restore(1), trash-list(1), and the FreeDesktop.org Trash Specification at http://www.ramendik.ru/docs/trashspec.html.

       Both are released under the GNU General Public License, version 2 or later.

																    TRASH-EMPTY(1)
All times are GMT -4. The time now is 06:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy