Accessing a particular node in a child group

[faheemhameed]

Hi there,

First of all I am very new to XSL/XML. I have been asked to export a set of filemaker data into a formatted Excel sheet. I understood that FMP/XML with XSLT could do that. I had a quick look at the XSL examples which comes with FMP 6. Now I am testing it with the following XML

I have a simple XML (a part cut/pasted from FM's XML export) as follows:

<ROW MODID="0" RECORDID="1">

<col><DATA>aaa</DATA></COL>

<col><DATA>bbb</DATA></COL>

</ROW>

<ROW MODID="0" RECORDID="2">

<col><DATA>ccc</DATA></COL>

<col><DATA>ddd</DATA></COL>

</row>

I want to get the data from the second COL ( or a particular COL) without using XSL's for-each loop on the COL collections. I am insided the for-each on the ROW.

Is there a way to identify a particular column's value using a ID or the field name?

Thanks for your help in advance.

Best regards,

Hameed

[Anatoli]

I probably don't understand the problem.

And I never touched XML.

Couldn't you do the TAB or merge export?

[Fenton]

From Beverly Voth's FileMaker Pro 6 Developers Guide to XML/XSL:

[] Gives the position of the child in a family.

child[1] is the first child.

These square brackets are also used when a test of the value of the element is needed:

parent[child="test"]

[faheemhameed]

Dear Fenton,

Your method worked for me. Thank you and all.

Hameed