File as very long string: chopping in records

[Former Member]

Hi

We receive a file as a "never-ending" string.

Somewhere in this file there is are indicators for

L -> envelope of message

T -> Header1 (1:1)

H -> Header2 (1:1)

D -> Details (1:n)

The lines have a fixed length but there is no clear separator between the lines.

Is there a way to chop this kind of file in records?

Regards and thanks

Ron

[Former Member]

No problem anymore

[Former Member]

ur FCC seems to be correct.

When using the key field they shud be enlosed within " ".

i.e TQS_Envelope.KeyFieldValue - "L"

Refer this blog,same as yours

[Former Member]

Hi,

The data in the input file contains the ". So that's why these are in the FCC.

(I also tried the " but it didn't work in my casë)

Regards

Ron

[Former Member]

wat is the actual file content?

u mean the file has (") characters.

something like

"L"wettreyeryryfe890"T"afsdtgsdg4646

[Former Member]

>>The lines have a fixed length but there is no clear separator between the lines

You can use .fieldFixedLengths parameter in File content conversion.

Please search SDN for "Handle fixed length file" in blogs section,you will find lots of information

Thanx

Aamir

[Former Member]

Hi,

Our FCC looks like this at this moment (displayed partially)

TQS_Envelope.fieldNames RecordType,Filler1,Filler2

TQS_Envelope.fieldFixedLengths 1,7,5

TQS_Envelope.keyFieldValue L

TransportOrderData.fieldNames RecordType,Filler3,Filler4

TransportOrderData.fieldFixedLengths 1,3,5

TransportOrderData.keyFieldValue T

DetailData.fieldNames RecordType,TransportOrderNumber,TransportNumber

DetailData.fieldFixedLengths 1,6,2

DetailData.keyFieldValue D

Our file looks like this (displayed partially)

L1234567abcdeT00012345edcbaD987654abD987654abD987654abD987654ab

Our result should be something like this in XML

L

1234567

abcde

T

000

12345

D987654

ab

D

987654

ab

D

987654

ab

D987654

ab

Regards

Ron

[S0003485845]

Hi,

the Seeburger EDI-Adapter allows you to define such a structure (if it is a fixed record length).

Also if you know the positions of the fields within each record, the Adapter also creates an XML-File where each field is placed within its own XML-tag

Greetings

Stefan

[Former Member]

Hi,

this customer doesn't have Seeburger.

We receive these files from Webspere MQ.

We tried File Content Conversion (FCC) but then you need some clear and defined end separators.This is not the case. Now only the first line is identified and the rest is skipped.

Regards

Ron