Skip to Content
0
Former Member
Feb 23, 2009 at 02:00 PM

Escape sign loading flat file

654 Views

Hi all.

I am working in BW 3.5 and trying to load a flat file in to my ODS. Everything thing seems to work fine with one exception.

If I have a file such as: 05, 12345, "Masters Inc.", 98765

I can load this fine because I have set my data separator as , (comma) and my escape sign as " (quote).

So my third column shows Masters Inc.

My understanding is that the escape sign is there in case a data separator shows up legitimately as a part of the data. So I expect that the system recognizes the beginning quote and the end quote and places all the data between them in the third column.

For example: 05, 12345, "Masters, Inc.", 98765

In this case, the comma would show up in the third column as a part of the data and not as a data separator. So my third column should be Masters, Inc.

My problem is that what shows up in the third column of my ODS and in the preview is: Masters, Inc.", 98765

And my fourth column is blank...because the third column is showing everything after the first quote is hit.

Anyone have ideas on why it is doing this? Or is my understanding of the escape sign incorrect?

Thanks.