Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

XML variable for input in same input file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting XML variable for input in same input file
# 1  
Old 12-03-2013
XML variable for input in same input file
Dear All ,

i stuck in one problem executing xml .. i have input xml as

Code:
   <COMMAND name="ARRANGEMENT.WRITE" timestamp="0" so="initial">
        <SVLOBJECT>
            <LONG name="CSP_PMNT_ID" val="-1"/>
            <MONEY name="CSP_CEILING" amount="0.0" currency="AUD"/>
            <DATE name="CSP_VALID_FROM" year="2013" month="12" day="3"/>
        </SVLOBJECT>
        <RESULT>
            <SVLOBJECT>
                <LONG name="CSP_ID" val="2043"/>
            </SVLOBJECT>
        </RESULT>
    </COMMAND>
    <COMMAND name="ARRANGEMENT_ASSIGNMENT.WRITE" timestamp="0" so="initial">
        <SVLOBJECT>
            <LONG name="PAYMENT_ID" val="2043"/> -- 
            <LONG name="TERM_CODE" val="2"/>
            <DATE name="VALID_FROM" year="2013" month="12" day="3"/>
        </SVLOBJECT>
        <RESULT>
            <SVLOBJECT>
                <LONG name="PAY_ARR_ID" val="2043"/>
            </SVLOBJECT>
        </RESULT>
    </COMMAND>

now here in result of first command coming as name="CSP_ID" val="2043
and i want to use this in value in next command .. can anyone help on this ..


thanks in Advance !!!
Last edited by bartus11; 12-03-2013 at 04:49 AM.. Reason: fixed code tags
# 2  
Old 12-03-2013
Not clear what you want to achieve. Please be way more specific!
# 3  
Old 12-03-2013
Assuming you want to extract the value and use it later:
Code:
csp_id_val=$( awk '/CSP_ID/{gsub(/.*=\"|".*/,X);print;exit}' file.xml )

# 4  
Old 12-03-2013
Code:
$ csp_id_val=$(grep -Po -m1 '(?<="CSP_ID" val=").*(?=\"/>)' file)
$ echo $csp_id_val
2043

# 5  
Old 12-03-2013
Yoda, can you explain the | in your command gsub please.
Thx.
# 6  
Old 12-04-2013
It's like an "OR" in regexes; so either part when matching is replaced by the empty variable X.
# 7  
Old 12-04-2013
ok it's clear, thx.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can't input large file to variable

I have a file that I'm trying to place into a variable. I've tried the following: DATE=`date +%Y%m%d` filez=$(cat /tmp/Test_$DATE.txt)DATE=`date +%Y%m%d` filez=$(</tmp/Test_$DATE.txt)DATE=`date +%Y%m%d` filez=$(`cat /tmp/Test_$DATE.txt`)None of these lines allows the file to go into the... (3 Replies)
Discussion started by: newbie2010
3 Replies

2. Shell Programming and Scripting

Read xml file till script finds separation and run again for next input and so on

Hi All, I have one query, I managed to run script with user inputs through command line or with 1 file. But I need to read a txt file/xml file in which user can mention multiple sets of answers and script should run for each set till it reach the EOF. Thanks in advance for example, the file... (3 Replies)
Discussion started by: rv_champ
3 Replies

3. Homework & Coursework Questions

Removing punctuations from file input or standard input

Just started learning Unix and received my first assignment recently. We haven't learned many commands and honestly, I'm stumped. I'd like to receive assistance/guidance/hints. 1. The problem statement, all variables and given/known data: How do I write a shell script that takes in a file or... (4 Replies)
Discussion started by: fozilla
4 Replies

4. Shell Programming and Scripting

Read input files and merge them in given order and write them to input one param or one file

Dear Friends, I am looking for a shell script to merge input files into one file .. here is my idea: 1st paramter would be outfile file (all input files content) read all input files and merge them to input param 1 ex: if I pass 6 file names to the script then 1st file name as output file... (4 Replies)
Discussion started by: hyd1234
4 Replies

5. Shell Programming and Scripting

Script to delete files with an input for directories and an input for path/file

Hello, I'm trying to figure out how best to approach this script, and I have very little experience, so I could use all the help I can get. :wall: I regularly need to delete files from many directories. A file with the same name may exist any number of times in different subdirectories.... (3 Replies)
Discussion started by: *ShadowCat*
3 Replies

6. UNIX for Dummies Questions & Answers

SQL Script to use variable value from input file

Here is the requirement, When I run the "run file KSH (sql)", it should substitute '${pCW_Bgn_DT}' with 201120 and '${pCW_End_DT}' with 201124 Input File ---------- $ cat prevwk.dat 201124 20110711 run file KSH (sql) ------------------ In this file, I want to use the variables... (1 Reply)
Discussion started by: shanrice
1 Replies

7. Shell Programming and Scripting

Reading from a File and Using as an Input variable

I need to know how the the string constant from Input File should be read and provide as input data for the script . INPUT FILE CONST VARIABLE myname=/root/dir/syslog/myname1 myname=/root/dir/syslog/myname2 myname=/root/dir/syslog/myname3 urname=/root/dir/syslog/urname1... (6 Replies)
Discussion started by: baraghun
6 Replies

8. Shell Programming and Scripting

How to get input xml file as XMLout. output.

Hi , I am trying to get an reference of a XML formatted data using XML::Simple::XMLin and again trying to retrive the XML data as it was before using XML::Simple::XMLout. But finding a deviation in the format can any pls help me out. Input file sr.xml <?xml version="1.0"... (0 Replies)
Discussion started by: srkelect
0 Replies

9. Shell Programming and Scripting

Reading specific contents from 1 input files and appending it to another input file

Hi guys, I am new to AWK and unix scripting. Please see below my problem and let me know if anyone you can help. I have 2 input files (example given below) Input file 2 is a standard file (it will not change) and we have to get the name (second column after comma) from it and append it... (5 Replies)
Discussion started by: sksahu
5 Replies

10. Shell Programming and Scripting

How to get variable input from a file

Hi guys, I want to input some variables from a file. I tried it with following script, for i in 1 2 3 4 do read varible1 varible2 < ddd.txt echo $varible1 $varible2 done ... (1 Reply)
Discussion started by: maheshsri
1 Replies
Login or Register to Ask a Question