File Layout With CSV File With Qualifier

I have a .csv file with qualifiers around data values with double quotes.
So my fields in the file will be in the following format.

"Miami","FL"

I am trying to read this file using file layouts. I have defined the file
layout as CSV, set the qualifier as " and delimiter as comma. But the app
engine is failing saying that the country code '"USA"' exceeds the COUNTRY
field. It looks like PeopleSoft is reading each field along with the double
quotes. For instance, it is reading "USA" into the state field instead of
USA.

Any ideas as why this is happening? My tools version is 8.46. Any help is
very much appreciated.

Popular White Paper On This Topic

Hi,
You can test the file from file layout testing tool. You can test the file format and confirm tge condition.

Sarath email@removed wrote:

>Toolbox peopletools-l A, .slash {text-decoration:none; font-family:arial; color:#1867b6} Question from Sarath?on Aug 24 at 3:08 PM Hi all,
>
>I have a .csv file with qualifiers around data values with double quotes.
>So my fields in the file will be in the following format.
>
>"Miami","FL"
>
>I am trying to read this file using file layouts. I have defined the file
>layout as CSV, set the qualifier as " and delimiter as comma. But the app
>engine is failing saying that the country code '"USA"' exceeds the COUNTRY
>field. It looks like PeopleSoft is reading each field along with the double
>quotes. For instance, it is reading "USA" into the state field instead of
>USA.
>
>Any ideas as why this is happening? My tools version is 8.46. Any help is
>very much appreciated.
>
>Thanks,
>Sarath
>
> ?
>
> Reply to this email to post your response.

You can have a Default Qualifier (Set at the File Layout Segment Properties level) that will apply to all your fields within your file layout, but then each field can also have the Qualifier set/removed (Set at the File Layout Field Properties level).

I would check the Qualifier at the field level and make sure the double quotes were not removed.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.