UNIX for Dummies Questions & Answers

Thanks for your response, I did the following.

Code:

tr -d '\000' <datafile>datafile2

Now after this when i tried to do grep PROVIDER datafile2, the whole file keeps scrolling i assume it's because of noel. Would it be possible to do successful grep with out scrolling or even not applying tr -d '\100', please advise thank you.

grep will print the entire line. If the whole file is one giant line, well...

Try this, to split each tag onto a separate line:

Code:

tr -d '\000' < inputfile | sed 's/>/>\n/g' | grep -i provider

I got this output

Code:

<Provider n1:schemaLocation="http://www.xyz/xasdas" PROVIDER="16" SCHEMA_VERSION="2.5" xmlns="http://www.xyz/xasdas" xmlns:xsi="http://www.xyz/xasdas" xmlns:n1="http://www.w3.org/2001/XMLSchema-instance">
</Provider>

I modified your input to get the final output which is the provider number. Do you have any better way of doing this, please suggest. thank you.

If you're doing grep | grep | sed | awk | cut, you might as well just rewrite it in awk.

Code:

tr -d '\000' < inputfile.xml | awk -v RS="<" -F'"' '/[pP][rR][oO][vV][iI][dD][eE][rR]/ {for(i=1;i++<=NF;)if($i~[pP][rR][oO][vV][iI][dD][eE][rR]) print $(i+1) }'

I am receiving the below error

Sorry, a missing / there:

Code:

tr -d '\000' < inputfile.xml | awk -v RS="<" -F'"' '/[pP][rR][oO][vV][iI][dD][eE][rR]/ {for(i=1;i++<=NF;)if($i~/[pP][rR][oO][vV][iI][dD][eE][rR]/) print $(i+1) }'

I am dissecting the code and trying to understand piece by piece

tr -d '\000' -- This will remove the binary zeroes in the data file
RS="<" -- Record Seperator is <
NF -- total number of fields
/[pP][rR][oO][vV][iI][dD][eE][rR]/ -- You were trying to match both upper case and lower case combination for a better match
-F'"" -- to get the value of provider in between double quotes
-v -- passing shell variables to awk variables ...????

you were finding the PROVIDER tag and for each record/tag until total number of fields/characters and formatting the output to trim it to the value. can you please explain it if i am wrong? i didn't understand what is the significance of -v ?

Thank you.