BW Flat file Load error

[Former Member]

I am doing flat file in BW System. InfoPackage setting are as follows,

File is CSV file

Data Separator = ,

Escape Sign = u201C

In Transfer Structure all are char fields.

1st Filed is of length 18

2nd Filed is of length 18

3rd Filed is of length 25

4th Filed is of length 10

e.g of data in flat file is as follows

"00q80000003AmvHAAS","00530000000jSm8AAE","US02CALVER;H21020101","2008-11-24u201D

This data will load successfully every time, but if data comes like this

"00q80000003AmvHAAS","00530000000jSm8AAE","US02BVERFU;H21020101;H21020102;H21020104;H21020201;H21020202;H21020203;H21020204","2008-11-24u201D

Then in preview itself I canu2019t see the date(4th filed will be blank) it will blank or some times it will be some char like 200 or 2008 or 2008-11 etc.

Can you please tell me why this is so? How to solve this issue?

[patrick_williams]

That didn't come out well (I need a preview!) but you get the point.