Please forget about the above awk commands it would be confusing below is the sample xml file
i want string value JOB_ID to be extracted and assigned to a variable NEW_VAR
Hi Karthik,
PLEASE pay attention to what you are doing! There cannot be a <space> between the name of a shell variable and the <equals-sign> that follows it if you are trying to assign a value to that variable. This has been said several times in this thread and yet you still write that you want the result to be:
Code:
NEW_VAR ='30544,30545,30546'
which, as stated before tells the shell to run a utility named NEW_VAR with one operand that is the string =30544,30545,30546 and note that that operand does not contain the <single-quote> characters that will be removed by the shell as it prepares the arguments to be passed to the NEW_VAR utility when it is invoked.
Note also that you have not told us what operating system you're using. With a sample file that is 8,157 bytes long and contains only a single line, that is not a text file on many BSD, Linux, and UNIX systems and the awk, sed, and most other standard text processing utilities have undefined behavior if the input files being processed are not text files.
Note also that you say that the output to be produced from your sample input should have three numbers (Job IDs) in the output, but there are five Job IDs in the sample input? Why shouldn't all five values be extracted from the XML file?
If we assume that the awk utility on your system can handle text files with unlimited line lengths, the following might do what you want:
Code:
NEW_VAR=$(awk -v sq="'" -F'<ns11:Job_Id>' '
{ for(i = 2; i <= NF; i++) {
sub(/<.*/, "", $i)
printf("%s%s", cnt++ ? "," : sq, $i)
}
}
END { print sq
}' file
)
printf 'NEW_VAR has been assigned the value: %s\n' "$NEW_VAR"
which, on macOS Mojave version 10.14.3, produces the output:
Code:
NEW_VAR has been assigned the value: '30544,30545,30546,30547,30548'
if the file named file contains the sample data you provided in post #22 in this thread.
These 2 Users Gave Thanks to Don Cragun For This Post:
Iam using Linux OS and the file is .xml , And i need all the values of job_id as you mentioned not just 3.
OK. So does the code I suggested in post #23 produce the output you want if you change the name of the file in the script to match the name of your input file?
This User Gave Thanks to Don Cragun For This Post:
#!/bin/sh
# Add all Input files to array
FileList=($(ls | grep "../Inbound/sampletest*\\_[0-9]"))
echo "$FileList"
#loop array for Input files
for x in "${FileList[@]}"
do
#for each element in array
#File Split Begin
awk -f xml_tag_handler.awk -f File_split.awk OUT=$x"" ROWS="500" $x $x
mv $x ../Staging
done
rm Response.xml Extr*.xml
for f in ../Inbound/sampletest_*
do TMP="${f/sampletest_/Extrfile}"
mv "$f" "${TMP%.*}"
done
# add all files to array
arr=($(ls | grep "../Inbound/Extrfile[0-9]*.xml"))
Last edited by Don Cragun; 02-18-2019 at 12:19 AM..
Reason: Remove quote tags around update; get rid of earlier version of duplicated post.
#!/bin/sh
# Add all Input files to array
FileList=($(ls | grep "../Inbound/sampletest*\\_[0-9]"))
echo "$FileList"
#loop array for Input files
for x in "${FileList[@]}"
do
#for each element in array
#File Split Begin
awk -f xml_tag_handler.awk -f File_split.awk OUT=$x"" ROWS="500" $x $x
mv $x ../Staging
done
rm Response.xml Extr*.xml
for f in ../Inbound/sampletest_*
do TMP="${f/sampletest_/Extrfile}"
mv "$f" "${TMP%.*}"
done
# add all files to array
arr=($(ls | grep "../Inbound/Extrfile[0-9]*.xml"))
Hi karthik,
All of the code marked in red above will ALWAYS expand to nothing because the output from ls when invoked with no operands will NEVER yield any string containing ../. Therefore the script you showed us is logically equivalent to the script:
Code:
#!/bin/sh
# Add all Input files to array
FileList=()
echo ""
#loop array for Input files
#for each element in array
#File Split Begin
rm Response.xml Extr*.xml
for f in ../Inbound/sampletest_*
do TMP="${f/sampletest_/Extrfile}"
mv "$f" "${TMP%.*}"
done
# add all files to array
arr=()
I assume that you are not getting what you want because you never run any of the awk scripts in your shell script; you only move around and change the names of files that already existed before you started running this script.
This User Gave Thanks to Don Cragun For This Post:
Hi There!
I am saving the file count of all files in a directory to an output file using:
wc -l * > FileCount.txt
I get:
114 G4SXORD
3 G4SXORH
0 G4SXORP
117 total
But this count includes header and footer. I want to subtract 2 from the count and get
... (7 Replies)
Hi Every one,
what is the coomand to remove header or footer from a file.
Please help me by providing command/syntax to remove header/footer from unix.
Thanks in advance for all your support. (5 Replies)
This is my file(Target.txt)
name|age|locaction
abc|23|del
xyz|24|mum
jkl|25|kol
The file should be like this
1|03252012
1|name|age|location
2|abc|23|del
2|xyz|24|mum
2|jkl|25|kol
2|kkk|26|hyd
3|4
Column 1 is row indicator
for row 1 and 2, column indicator is 1,for data rows... (1 Reply)
I am having report file with header and footer . The details in between header and footer are separated by a pipe charater. I want to sort the file by considering multiple columns in between header and footer.
pls help (4 Replies)
I have one large file, after every 200 line i have to split the file and the add header and footer to each small file?
It is possible to add different header and footer to each file? (7 Replies)
I have one large file, after every 200 line i have to split the file and the add header and footer to each small file?
It is possible to add different header and footer to each file? (1 Reply)
I am trying to get a total number of tapes w/out headers or footers in a ERV file and append it to the file. For some reason I cannot get it to work. Any ideas?
#!/bin/sh
dat=`date +"%b%d_%Y"`
+ date +%b%d_%Y
dat=Nov16_2006
tapemgr="/export/home/legato/tapemgr/rpts"... (1 Reply)
Hi, I need to chope the header and footer record from an input file and make a new output file, please let me know how i can do it in unix.thanks. (4 Replies)