String Handling

veera24 · Post by **veera24** » Mon Dec 22, 2008 9:19 pm

chulett wrote:Obviously, they want or need something quoted or this conversation would have been over quite some time ago.

Yeah chulett. We want some of the columns needs to be quoted and the rest needn't.

veera24 · Post by **veera24** » Mon Dec 22, 2008 9:23 pm

ray.wurlod wrote:Use 000 for the quote character on the Format, and use SQuote() function for each field that needs to be quoted. This allows individual fields to be quoted without all string fields to be quoted. ...

Hi ray,
Thanks for your suggestion. By doing so i can achieve the quotes in the column wherever i want.am i right?

Previously i thought that i can concatenate the double quotes in the columns i want. But now, by using SQuote() function i can achieve i suppose. Let me check the output. Thanks again ray.

chulett · Post by **chulett** » Mon Dec 22, 2008 11:53 pm

veera24 wrote:
chulett wrote:Obviously, they want or need something quoted or this conversation would have been over quite some time ago.
Yeah chulett. We want some of the columns needs to be quoted and the rest needn't.

You *do* realize that in all of this exchange that you've never given us specific examples of the data types in this file and what in the heck you want quoted and what you don't want quoted? This really isn't rocket science here.

SQuote() will wrap data in single quotes and DQuote() will do the same with double-quotes. If you really need some odd, non-standard mishmash of quoted and unquoted fields then make them all strings, set the quote character to '000' in the file and use one of the two functions noted to add quotes of the proper type to the fields that need them.