Check null value in xml


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Check null value in xml
# 1  
Old 03-04-2013
Check null value in xml

Hi,

I have a log file which is having some xml tags. I need to check the value for a particular xml field is null or not and if it is null i have to add current time as the value for that xml field.

I tried below code to check whether the word count is 0. But even if the xml field is null it is showing the count as 1.

Code:
if [ `cat Log.out | grep "<timestamp1>.*</timestamp1>" | wc -l` -gt 0 ]
then
echo timestamp is not empty
fi

# 2  
Old 03-04-2013
What do you mean by "null"? Value "0" (zero) or empty field?
That .* means 0 or more occurrences of any char, so the word count will not equal 0 if that "<timestamp1> . . . </timestamp1>" occurs somewhere in your file.
Try <timestamp1>.+</timestamp1> or <timestamp1>..*</timestamp1> to discriminate empty fields.

And then - UUOC and UUOB.
Code:
grep -q "<timestamp1>.+</timestamp1>" Log.out && echo "found" || echo "empty/non existent"

will do.
# 3  
Old 03-04-2013
Hi RudiC

Thanks for the quick reply.

I meant the value is empty.

I tried with
Code:
<timestamp1>..*</timestamp1>

and I am able to get the count if it having null values.

But if the log file is having an empty value for timestamp1 then i have to pull the entire xml and insert current time to that empty xml field.

Sample xml:
<submit>
<ID>16</ID>
<Reference/>
<timestamp1></timestamp1>
....
.....
</submit>

Could you please help me to do this.

Last edited by Neethu; 03-04-2013 at 06:52 AM..
# 4  
Old 03-04-2013
Following these fora for nearly half a year, you should be able to at least try a solution yourself. What would you come up with in the first place? We are happy to help should you get stuck...
# 5  
Old 03-04-2013
Hi RudiC,

I tried the following code
Code:
awk '/<submit>/,/<\/submit>/' log.out > xml
if [ -s xml ]
then
grep "<timestamp1>..*</timestamp1>" xml > tvalue
else
echo xml is empty
fi

This will not pull any value if timestamp is empty in xml file. I want to check the value of timestamp1 in xml file and if it is empty i want to insert the current time. But in this code it is not pulling any xml tag.

Last edited by Neethu; 03-04-2013 at 07:53 AM..
# 6  
Old 03-04-2013
Fine so far.
Quote:
and insert current time to that empty xml field.
What ideas do you have to insert the timestamp? Searching these fora might give you a head start...
# 7  
Old 03-04-2013
I noticed that in your code you are checking if your file size is empty, but if that is what you want, it is OK.

But if you are looking for a method to check if tag value is empty and insert current timestamp in it, then code something like:
Code:
awk -F'[<>]' ' BEGIN {
                cmd = "date +%Y%m%d%H%M%S"
} /<timestamp1>/ {
        if ( $3 == "" )
        {
                cmd | getline dt
                close(cmd)
                $0 = "<timestamp1>" dt "</timestamp1>"
        }
} 1 ' xml

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check null values column

hi, I had a small question.I had a file from which i need to extract data. I have written the below script to check if the file exists and if it exists extract requierd columns from the file. IFILE=/home/home01/Report_1.csv OFILE=/home/home01/name.csv.out1 if #Checks if file exists... (1 Reply)
Discussion started by: Vivekit82
1 Replies

2. Shell Programming and Scripting

If condition to check null variable

Guys, Please help me on the below sample.cfg var=NULL sample.sh #!/bin/sh . /sample.cfg if ;then 1 st command here else 2 nd command here fi (3 Replies)
Discussion started by: AraR87
3 Replies

3. Shell Programming and Scripting

Check for null values in columns

Hi , I have below data with fixed with of 52 bytes having three columns value data. 01930 MA GLOUCESTER 02033 02025 COHASSET 01960 MA ... (3 Replies)
Discussion started by: sonu_pal
3 Replies

4. Shell Programming and Scripting

Check for null

Hi Champs!!! im a newbie in unix, need ur expert help for my problem... I need to search if there are any "NULL" entries in the string String without Null Str1: 203652|1000003653|tellt|RUPV|4649|1|07/28/2011 01:56:12 String with Null (RUPV is removed) Str2:... (5 Replies)
Discussion started by: guruprasad7
5 Replies

5. Shell Programming and Scripting

check for null

hi, i have 3 lines of output , if second line exists then only condition within the if loop has to exeute other wise it has exit from loop. i had tried like this but not getting please help me ... Code: if ; then echo "success" else echo "" Use code tags please,... (8 Replies)
Discussion started by: sreelu
8 Replies

6. UNIX for Dummies Questions & Answers

Check for null values in a column

Hi All, I have a file with 10 columns and get the required data for nine columns properly except 8th. In 8th column i have both NULL and NON NULL values...i.e certain records have values for all the columns including 8th column and certain records have 8th column as NULL.My requisite is,without... (20 Replies)
Discussion started by: ganesh_248
20 Replies

7. Shell Programming and Scripting

How to check for null value from makefile

My makefile has some code as follows: if ; then \ echo copying tools; \ cp -f `../${TOOLS_ROOT_PATH}/ext_tools.sh 1` ${EXTERNAL_BIN_DIR} || exit $$?;\ fi; \ The ext_tools.sh is as follows: cat ttx.conf | grep external | grep -v ^# | awk '{print $1}' It can sometime result... (1 Reply)
Discussion started by: jake_ryan
1 Replies

8. Shell Programming and Scripting

how to check null variable

korn shell If then update_smartcare_user_password "$u_id" else echo "Not a database user" fi i get this error Syntax error at line *** : `then' is not expected. what should i do. I want to check whether $a is null or not. (2 Replies)
Discussion started by: sachin.gangadha
2 Replies

9. Shell Programming and Scripting

check for not null string in file

Hi, If, in a text file a string is expected at a certain fixed position(for eg at position 5 or from 5-10 on every line) how to check whether data is present on that position or not? Thnx in advance (6 Replies)
Discussion started by: misenkiser
6 Replies

10. Shell Programming and Scripting

check for NULL variable

Hello I want to check for NULL variable.. but this is not working..please help thanks in advance esham (2 Replies)
Discussion started by: esham
2 Replies
Login or Register to Ask a Question

Featured Tech Videos