Being somewhat new to UNIX I naturally need some help. I have an XML file the I need to retrieve data from and that data is between the opening and closing tags. I have this so far....
Code:
for records in $lvar_sourcedir/$lvar_sourcefile
do
write_output "Retrieving the data from the XML file now....."
while read states
do
if [[ $states == *\<ALERT\ ALTID=* || $states == *\<DISPDTE* || $states == *\<DISP* || $states == *\<CMNT* || $states == *\<WFDOMN* || $states == *\<UID* ]]; then
get_alertid=`echo $states | sed -e 's/^.*<ALERT ALTID="//g' | sed 's/[.">].*$//'`
get_dispdte=`echo $states | sed 's/^.*<DISPDTE>//g' | sed 's/[</DISPDTE>].*$//'`
get_disp=`echo $states | sed 's/^.*<DISP>//g' | sed 's/[</DISP>].*$//'`
get_cmnt=`echo $states | sed 's/^.*<CMNT>//g' | sed 's/[</CMNT>].*$//'`
get_wfdomn=`echo $states | sed 's/^.*<WFDOMN>//g' | sed 's/[</WFDOMN>].*$//'`
get_uid=`echo $states | sed 's/^.*<UID>//g' | sed 's/[</UID>].*$//'`
echo "-------------------------------"
echo "Alert ID - $get_alertid"
echo "-------------------------------"
echo "Disp Date - $get_dispdte"
echo "-------------------------------"
echo "Disposition - $get_disp"
echo "-------------------------------"
echo "Comments - $get_cmnt"
echo "-------------------------------"
echo "Doman - $get_wfdomn"
echo "-------------------------------"
echo "User ID - $get_uid"
echo "-------------------------------"
fi
The problem exists where the data being retrieved has a letter in the same case as in the XML tag. For example,
-------------------------------
Alert ID - 0000005132
-------------------------------
Disp Date - 2000-08-28
-------------------------------
Disposition - Add to Fraud
-------------------------------
Comments -
-------------------------------
Doman -
-------------------------------
User ID - 5132
-------------------------------
Notice the Disposition section has "ADD to Fraud" but the XML file data has "Add to FraudDatabase" and the XML tags are <DISP>Add to FraudDatabase</DISP>
If I change the data to be "add to frauddatabase" there is not problem and the line is read, but this is not an option for me.
XML Snippit
Code:
<ALERT ALTID="0000005132."><DISPDTE>2000-08-28</DISPDTE><DISP>add to frauddatabase</DISP><CMNT>This is just a test1</CMNT><WFDOMN>Money Laundering1</WFDOMN><UID>5132</UID>
<ALERT ALTID="0000005146."><DISPDTE>2000-09-28</DISPDTE><DISP>Add to FraudDatabase</DISP><CMNT>This is just a test2</CMNT><WFDOMN>Money Laundering2</WFDOMN><UID>5146</UID>
<ALERT ALTID="0000005156."><DISPDTE>2000-10-28</DISPDTE><DISP>Add to FraudDatabase</DISP><CMNT>This is just a test3</CMNT><WFDOMN>Money Laundering3</WFDOMN><UID>5156</UID>
I would suggest you replace your 2 sed statements with the following sed/awk
sed 's/^.*<DISP>//g' | awk -F"<" '{print $1}'
This way the sed gets you past the start xml tag - and identifies it for you - and the awk then takes whatever is there upto but not including the next '<' character. This way the case is irrelevant. It may be worth using this for all of your tag extraction statement to avoid possible future kicks in the ******
Hi.
How can I create a history function? (By "read" command or so)
&
How can I configure a read command so that the arrow keys are not displayed so funny? (^[[A)
Thanks in advance. (4 Replies)
Hi,
I am facing issues with the below:
I have a lookup file say lookup.lkp.This lookup.lkp file contains strings delimited by comma(,).
Now i want to read this command from file and execute it.
So my code below is :
Contents in the lookup.lkp file is :
c_e,m,a,`cd $BOX | ls cef_*|tail... (7 Replies)
Hi
I am new to writing script and want to use a Bash Piped while-read and read from user input.
if something happens on server.log then do while loop or if something happend on user input then do while loop.
Pseudocode something like:
tail -n 3 -f server.log | while read serverline || read... (8 Replies)
Hi
i am looking a way to look at a log file(log.txt) from the last time I've read it.
However after some days the main log file(log.txt) is rename to (log.txt.1).
So now i will have two log files as below.
log.txt.1
log.txt
Now, i have to read the log from the point where i have left... (3 Replies)
Hello All,
i am a newbie and need some help when reading a csv file in a bourne shell script. I want to read 10 lines, then wait for a minute and then do a reading of another 10 lines and so on in the same way. I want to do this till the end of file.
Any inputs are appreciated
... (3 Replies)
hi,
this is my script #!/bin/ksh
cat temp_file.dat | while read line
do
read test
if ]; then
break
else echo "ERROR"
fi
done
when i execute this code , the script does wait for the user input . it directly prints "ERROR" and terminates after the no. of times as there... (3 Replies)
Hi Guys,
Happy New Year to you all!
I have a requirement to read an embedded new-line using KSH's read builtin.
Here is what I am trying to do:
run_sql "select guestid, address, email from guest" | while read id addr email
do
## Biz logic goes here
done
I can take care of any... (6 Replies)
Hi the following c-code utilizing the 'read()' man 2 read method cant read in files larger that 2gig.
Hi I've found a strange problem on ubuntu64bit, that limits the data you are allowed to allocate on a 64bit platform using the c function 'read()'
The following program wont allow to allocate... (14 Replies)
# include <stdio.h>
# include <fcntl.h>
# include <stdlib.h>
# include <sys/stat.h>
int main(int argc, char *argv)
{
int fRead, fPadded, padVal;
int btRead;
int BUFFSIZE = 512;
char buff;
if (argc != 4)
{
printf ("Please provide all of the... (3 Replies)
Can I use the read command to read the contents of a variable? I'm trying by using the following code and getting nothing back. I'm in a Linux environment.
#!/bin/ksh
IFS=~
VAR1=1~2~3~4
echo $VAR1 | read a b c d
print "$a $b $c $d" (9 Replies)
09-14-2007
SOLVED!!!!! - Weeeeee
