xml data

[DozAdmin]

I need to write a formula on a filed that is, I think, xml based. this is new for me. I need an if/then statement based on data in the middle of this and the field data looks like this.

<OPTIONS><WEB><PERSONALDATADISPLAY enroll="O">
<Name value="Y" edit="Y" enroll="N" />
<Address value="Y" edit="Y" enroll="N" />
<Birth_date value="Y" edit="N" enroll="N" />
<Marital_status value="Y" edit="Y" enroll="N" />
<Gender value="Y" edit="Y" enroll="N" />
<Home_phone value="Y" edit="Y" enroll="N" />
<Office_phone value="Y" edit="Y" enroll="N" />
<Other_phone value="Y" edit="Y" enroll="N" />
<Home_e-mail value="Y" edit="Y" enroll="N" />
<Office_e-mail value="Y" edit="Y" enroll="N" />
<Other_e-mail value="Y" edit="Y" enroll="N" />
<E-mail_notification_option value="Y" edit="Y" enroll="N" />
<Alternate_verification value="Y" edit="Y" enroll="N" />
<Elected_out_of_electronic_mailings value="N" edit="N" />
<Hire_date value="Y" edit="N" enroll="N" />
</PERSONALDATADISPLAY></WEB></OPTIONS>

help is appreciated.

 

[lbass]

You haven't explained what the formula should do, i.e., what is it that you want the formula to return? Also please explain whether your data above is all in one row or whether these are multiple rows.

-LB

 

[DozAdmin]

Sorry, that is the way I put the question... Thanks for responding!

I'm building a form - a document. The whole report will be text boxes. Different text will be displayed based on data fields. Some text will be omitted completely based on data fields.

Here is an example text box that fills a section in the report.
++++++++++++
IF you do not have on-line access, review the attached General Plan Provisions for completeing the agreement {@electionform}and benefit form.
++++++++++++
In the above exampel the formulas verifies data in a field, if the field is "y" then the formula adds text, if "n" then it does not. Most of the fields are user defined fields, normal Y or N, but some are xml that store program settings.

I have a few different formulas to write on this but one example, I need to hide a section if
<Birth_date value="Y" edit="N"
and show the section if
<Birth_date value="N" edit="N"
"the enroll=" part can be anything.

 

[lbass]

Try a conditional formula like this for suppression or hiding:

instr({table.field},'<Birth_date value="Y" edit="N">') <> 0

-LB