All Forums Tools
aaibinder 9 posts Joined 08/16
23 Aug 2016
TPT, how to output columns enclosed in quotes?

So, I'd like a database that's pulling in a file that looks like this:
 
Right now I have this...
blah blah, 123, bleh bleh
I want...
"blah blah", "123", "bleh bleh"
 
Right now I'm using this:
 

/* 235 */      ATTRIBUTES

/* 236 */      (

/* 237 */         FileName = 'sales_detail_fact.txt', 

/* 238 */         Format = 'DELIMITED', 

/* 239 */         OpenMode = 'Write', 

/* 240 */         IndicatorMode = 'N', 

/* 241 */         TextDelimiter = ','

/* 242 */      )

 

Any help? Can't figure it out in the documentation.

feinholz 1234 posts Joined 05/08
23 Aug 2016

Set QuotedData to 'yes'.

--SteveF

aaibinder 9 posts Joined 08/16
23 Aug 2016

Thanks, worked!

You must sign in to leave a comment.