MQSeries.net :: View topic

javaforvivek · Posted: Tue Sep 14, 2004 11:50 pm Post subject:

Hi,
I have a message like this:
<Blank Line>
<Blank Line>
Title1 Title2 Title3 Title4
---------------------------
T1,T2,T3,T4 <CR><LF> (Comma Separated Data)
A1,A2,A3,A4<CR><LF>
..... so on

This message consists of two blank lines at the begining, then a line containing titles, then a '----' line and then actual data which spans over multiple lines, each line contains comma separated data.
I have defined my message for comma separated data as TDS physical format, All elements delimited, Delimiter = ',' . But I don't know how to define first four lines of the message. My ultimate aim is to convert the CSV data in XML format and then process it to produce XML output. The first four lines are of no use to me.
Currently, I am using a Java Client to put this message on the input queue. And prior to putting this message, I am programatically removing first four lines and just putting CSV data to the input queue.
Can anybody suggest the proper message definition for this message, so that my Java code should not do the removal of the first four lines, and message flow should handle it.
_________________
Vivek
------------------------------------------------------
...when you have eliminated the impossible, whatever remains, however improbable, must be the truth.