MVSFORUMS.com

[yugee]

Hi,
I have an input XML string with many fields. I need to get the value of a particular field. Can it be done using the INSPECT?
for example:
Input file:
fild1 fld2 fld3 - not the actual record, just for reference
ABC 123 {NAME^KUMAR KRISHNA^string}{PHONE^XXX-XXX^string}
ABD 124 {PHONE^YYY-YYY^string}
ABE 125 {NAME^RAJ^string}

I want the output file as (need only phone from field3)
ABC 123 XXX-XXX
ABD 124 YYY-YYY
ABE 125

Field3 is of variable length. Phone number may be or may not be there in the field3 and it can start in any position.
Could some one help me with this?

[dbzTHEdinosauer]

Yes, INSPECT can be used to find the location of 'PHONE' in field3.
is the format of the PHONE entity always the same? UNSTRING could be used to extract the phone number.

You should use BBCode to enable readers to better understand your data. For example:

[yugee]

Hi,
The format of the PHONE entity will always be the same. If the customer has entered the phone number, then the field3 will always have the PHONE string in the below format:
{PHONE^XXX-XXX^string}

[dbzTHEdinosauer]

Ok. Where I have lived (about 13 countries) phone number was never xxx-xxx.
that aside,

you can UNSTRING Field3 delimited by } into however many fields-groups that could be contained in Field3. If PHONE is always in the 1st or 2nd you've got it made. I picked an arbitrary length of 50. if these subgroups can be larger, use that value.
Want to make each UNSTRING receiving object large enough that you don't have to deal with overflow/underflow problems.

[yugee]

Hey, I have just put a sample string for the phone number. Actually the field I am lookin is some thing else. Sorry for confusion, I should have used some realistic values. The only disadvantage with UNSTRING is, I don't know the position of Phone number Field. The Field3 is a dynami XML message, it depends on the number of fields user enters. This XML data is passed to us by an online application, on which user can enter their information. Some times he may not even enter the phone number. In this case, the XML will not contain the tag for phone number and I need to pass spaces in the output file for this record. This makes the problem bit complex. I was trying to solve this using EASYTRIEVE, but I couldn't succeed.

[CICS Guy]

[yugee]

Hi,
The above approach will work if the Phone string is in the XML. Is there any way I can move spaces it we don't have the phone number?
Thanks a lot for your help .
Yugee

[Nic Clouston]

i guess you could INSPECT... TALLYING... and if the result is 0 then you move spaces otherwise you extract as indicated.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

[CICS Guy]