Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

How to generate file include quote only for some field?

0 views

Skip to first unread message

Bruce Li

unread,

Feb 8, 2009, 8:01:01 PM2/8/09

is there someone can tell me how to generate Flatfile like :

,,, "20090209",,"thanks", , "MY GOD" ,,

comma is delimited. data be quoted. NO quote if it is empty filed.

Bruce Li

unread,

Feb 8, 2009, 8:02:00 PM2/8/09

Dan Rosanova

unread,

Feb 10, 2009, 9:32:01 AM2/10/09

Not sure on the empty does not include quotes, but did you try setting
the Default Wrap Character on the schema or Wrap Character on your
records?

Kind Regards,
-Dan

ademu...@gmail.com

unread,

Feb 10, 2009, 4:26:23 PM2/10/09

You first need a flat file schema. You can create one by using the
flat file schema wizard under the Add -> New Item of the project
context menu. It will ask you for an instance file and walk you
through creating the schema. Select your line delimiter and set your
line to a repeating record, then set your item record delimiter to a
comma and finally set your escape character to a double-quote.

I was able to create this schema with the example you provided. The
record info is as follows.

<b:recordInfo structure="delimited" child_delimiter_type="char"
child_delimiter="," child_order="infix" sequence_number="1"
preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" escape_char_type="char"
escape_char=""" />

pavanakumari

unread,

Nov 9, 2009, 4:45:30 AM11/9/09

I have the same scenario except but, I also need double quote when there is data or even when there is no data. If you could succeed in this, Plz. share how you did.

Thanks in advance for the help

BruceL wrote:

How to generate file include quote only for some field?
08-Feb-09

is there someone can tell me how to generate Flatfile like :