This is the data I am having in a file
Just for sample I have given 3 records. The file which I am having consists of n number of records.
trackingnum in the position 1-6 6 bytes
trackingnumsuffix in the position 8-9 2 bytes
effdate in the position 11-20
tstmpupdated in the position 22-57 26 bytes
I dont know how to use substring.
Basically I need to extract the trackingnum, trackingnumsuffix and tstmpupdated and pass those values to a query. If it is present in that table, then I need to store the output of query to a file.
I have tried by writing the shell script as follows.
The above shell script is not working. It throws error message.
Can anyone help me to fix this issue.
Krishnakanth
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
try to echo $line inside while loop and check whether you are getting the required line..
and you have to use double quotes if $line has space
because i am getting no errors
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)