Skip to Content
avatar image
Former Member

Split large file : Recordset per message

Hi experts,


I have a large file that I want to split: flat file -XI. This is an exemple of file :


HEADER;XYZ;123;123456

DETAIL;XYZ;123;123456

DETAIL;XYZ;123;123456

DETAIL;XYZ;123;123456

DETAIL;XYZ;123;123456

..

..

..

..

TRAILER;XYZ;123;456


Every splited file shoud contain 1500 of 'DETAIL' and also should contain the 'HEADER' structure.


Any idea ?


Cordialy,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 22, 2015 at 03:23 PM

    Mou,

    Please let us know, why you want to split file (1500 records each)? Does target system expect CSV file?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      It's a flat file not CSV as I shown in my exemple . We want to split file because that we have performance problem with the huge file.

      Cordialy

  • avatar image
    Former Member
    Apr 22, 2015 at 03:10 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2015 at 03:27 PM

    your requirement can't be met by record per message option.

    may I knnow the max file size for this requirement? n explain more about end to end requirement and expected outcome.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 22, 2015 at 03:55 PM
    Add comment
    10|10000 characters needed characters exceeded