Page 1 of 1

Export To Text File with Text Qualifiers

PostPosted: Tue Oct 26, 2010 1:12 pm
by breener96
I would like the ability to select which columns of data that I want to be exported with text qualifiers as opposed to all or nothing. Is there a way that I can select a single row and make it the only row that will export using a text qualifier?

For example, lets say that I have the following columns that I will export to a text file.
FirstName, LastName, MiddleName

I would like to put text qualifiers on MiddleName, and not on FirstName and LastName. How can I do this?


I ran into an issue when I exported the data using SQL Reporting Services as it allowed for this where I was unable to figure out a way to do this with DataSlave.

Re: Export To Text File with Text Qualifiers

PostPosted: Tue Oct 26, 2010 1:49 pm
by ian
If I understand your requirement, you can use the Prefix and Suffix Transform functions to add the text qualifiers to the columns you want them added to. Then export to a text file witout qualifiers.

Please feel free to send us samples of data in and data out. We can then create a sample map to illustrate.

Re: Export To Text File with Text Qualifiers

PostPosted: Tue Oct 26, 2010 2:56 pm
by breener96
I was able to add the Prefix and that worked, but I do not see the option to add a Suffix Transform. I am looking at the transform, Functions->String and many choices are available, just not Suffix. I am running DataSlave v2.2.2 Standard. Am I missing something?

Re: Export To Text File with Text Qualifiers

PostPosted: Tue Oct 26, 2010 4:11 pm
by ian
My mistake. The other function is append.

I attach a sample map to illustrate how to do what you want.

Re: Export To Text File with Text Qualifiers

PostPosted: Tue Oct 26, 2010 4:22 pm
by breener96
That worked. Thanks!