Exctracting data

, ,
1

Hi,

I am new to webMethods and I am hoping that I can get some help from webMethods experts. J

I am reading (getFile) in flat file. I am converting the flat file content to string. Now I need to extract the flat file content in order to use the data for the SMTP flow. Is it possible to convert string to XML? Or should I write javascript to convert the flat file to XML and then extract data?

Flat file example:

<number>
E<email>
S<subject>
S<subject>
B<body>
B<body>
A<attachment>
A<attachment>
A<attachment>
A<attachment>

The letters are present in the flat file and the represent to content of the given line in the flat file.

ANY help greatly appreciated!!!

Thanks,
Sebastian

2

Sebastin,

Build a flatfile schema based on the flatfile content you receive and use convertToValues (this gives ffvalues after flatfile parsing against the schema)…and this use DocumentToXMLString to get in xml format based input specify the DocumentType name it will give out xmldata.use this xml string in your smtp flow.

HTH,
RMG

3

That work great! Thanks!