Currently having 2 issues when it comes to exporting my datasets and being able to get the desired output in my text files: (I need to be able to use automation for each of these issues)
I’m trying to export a dataset that uses fixed field spacing into a text file in the automation designer. When I do this Toad adds an extra space between the fields in the text file’s output. I know the issue of getting the space removed can be solved by choosing export table as flat file and then setting the space between fields option to 0. The problem is, from what I have seen, that this option is only available when you choose export to flat file and exporting as a flat file doesn’t look like it is available for automation. Is there a way to automate the flat file export so I can remove the extra space, or is there possibly another solution that will export my dataset the same way as the flat file export?
My second issue involves exporting the same dataset as a delimited text file. In my dataset there are some fields that are empty for some rows. I have all of my string and number columns being double quoted. Is there a way to get empty fields to be double quoted in the output? (Current output: “x”,“y” Desired output: “x”,"",“y”)
Thanks in advance