File adapter conversion - how to use wild card for xxx.keyFieldValue

[Former Member]

Dear all,

I have to read in and convert a csv file using the file adapter.

The source file may contain either an error text or exchange rates.

I have know to configure the file asdapte as following:

The SourceFile (with Error):

ERROR: This is an error text, and so on

will be mapped to

- <ns:ExchangeRatesMessage_CSV xmlns:ns="http://corpintra.net/pi/ExchangeRates">

- <Error>

<Error>ERROR</Error>

<ErrorText>This is an error text, and so on</ErrorText>

</Error>

</ns:ExchangeRatesMessage_CSV>

The SourceFile (with rates):

EUR USD 2008-08-30 1.4600

USD RUB 2008-08-30 0.0122

<ns:ExchangeRatesMessage_CSV xmlns:ns="http://corpintra.net/pi/ExchangeRates">

<Rates>

<HomeCurr>EUR</HomeCurr>

<ForeignCurr>USD</ForeignCurr>

<QuoteDate>2008-08-30</QuoteDate>

<Mid>1.4600</Mid>

</Rates>

[Former Member]

Sorry I hit the Post message to early.

The issue withe the two different set would be easy, if the rates would always start with the same currency in the first column. But how can I use wildcards for the keyFieldValue to read in all currencies.

Note: I file, which contains an error does never contain exchnage rates and vice versa.

Kind regrds,

peter