parse flat file in MII

[Former Member]

Hi folks, I got flat file having no delimiters, that is fixed positions are assigned to the columns. There is also no end of line characteristic besides "carriage return".

I am wondering if there is any way of parsing this besides usnig string functions? I tried to use advanced flat file parser but I do not have an EOL character. So I tried to somehow manage to use "carriage return" using base64 encoding..no success.

String functions is the only way here? Any ideas?

Thx for your suggestions

[former_member185280 · Accepted solution]

Personally I would try to do it with an xsl transform.

Regards,
Christian

[Former Member]

Good point Christian, it is working fine!

Thx Marco

[Former Member]

Hi Swaroop, plz find below a sample. Those files can be very long what is why I don't like the idea of using string functions. Greetings, marco

sample.txt

[swaroop_anasane]

Hi Marco,

Can you put a sample of you file here to see if we have any ideas.

Regards,

Swaroop