Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Text output formatting

Ash_dsz
6 - Meteoroid

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_0Data_0FullPath
Tax=0 C:\Users\Downloads\Tax + ".txt"
A112,A114 C:\Users\Downloads\Tax + ".txt"
 Data=0C:\Users\Downloads\Data + ".txt"
 A113,A115C:\Users\Downloads\Data + ".txt"

 

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.

 

 

12 REPLIES 12
Ash_dsz
6 - Meteoroid

Got it! Thank you so much!

Ash_dsz
6 - Meteoroid

Got it! Thank you so much.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Ash_dsz 

Cheers and have a nice day!

Labels