Yeah chulett. We want some of the columns needs to be quoted and the rest needn't.chulett wrote:Obviously, they want or need something quoted or this conversation would have been over quite some time ago.
String Handling
Moderators: chulett, rschirm, roy
Hi ray,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. ...
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.
Thanks in advance...
veera...
veera...
veera24 wrote:Yeah chulett. We want some of the columns needs to be quoted and the rest needn't.chulett wrote:Obviously, they want or need something quoted or this conversation would have been over quite some time ago.
![Confused :?](./images/smilies/icon_confused.gif)
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers