Hi All,
I am stuck on the below part of my canvas and it would be great if anyone has any method to generate the below mentioned output.
The below is just an example of the data that I am stuck on and you can consider it as an input as well.
Tax_0 | Data_0 | Path |
Tax=0 | C:\Users\Downloads\Tax | |
A112,A114 | C:\Users\Downloads\Tax | |
Data=0 | C:\Users\Downloads\Data | |
A113,A115 | C:\Users\Downloads\Data |
Basically the desired output should generate in a text format without the quotes and also in different folders that i have mentioned above. Just an example of the desired output.
In folder C:\Users\Downloads\Tax the required output is .txt is
Tax=0
A112,A114
In folder C:\Users\Downloads\Data the required output is .txt is
Data=0
A113,A115
Currently in the canvas output when i use .csv and try to generate this output I'm stuck on the following pointers .
1. If the first line is a delimiter there will be quotes. But i need to make sure that my first line is a delimiter without the quotes in. (I have tried parse and formula tool as well but I'm not sure if its working for me.)
2. Also for Data folder output i am getting a ( , ) before the data.
Thanks,
Ash.
Hi @Ash_dsz
Could you try changing your delimiter to something else, e.g. |
And then you can change Quote Output fields to Never:
It will error if you change quote output fields to never when you are using a comma IF you have a comma in your data.
Please let me know if this helps at all.
Cheers,