Skip to Content
avatar image
Former Member

parse flat file in MII

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 13, 2017 at 09:38 PM

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

    Regards,
    Christian

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 11, 2017 at 09:30 AM

    Hi Marco,

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

    Regards,

    Swaroop

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2017 at 07:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 16, 2017 at 02:01 PM

    Good point Christian, it is working fine!

    Thx Marco

    Add comment
    10|10000 characters needed characters exceeded