Alteryx Designer

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

Parse filename

Highlighted
8 - Asteroid

Hi, I want to parse the file name, can help on how to parse it? Some sales name has latin special character not English character.

 

parse.PNG

Highlighted
11 - Bolide

If you use the Text to Columns tool, you can out in multiple characters in the delimiter field to be parsed out. So you can do ,/| and it would parse be each of those. 

 

Seth

Highlighted
8 - Asteroid

Could you kindly help how to write, I am new to alteryx. thank you

Highlighted
Alteryx Certified Partner

@lilyyangadsk 

 

Please provide the data, not an image. Please describe the desired output that you want to achieve as well.

Highlighted
8 - Asteroid

I try to use this, but only get name with xxx_xxx, I can't take if name has xxx xxx xxx that has long name with many space or name saved as xxx_xxx with underscore or name with latin word.

 

and I need help to parse the date range, kindly pls help thank you.

 
 

2.PNG

Highlighted
8 - Asteroid

Here is the file I want to parse result, big thank you!!

Highlighted
Alteryx Certified Partner

That file you sent is quite different than the image you posted. I created a workflow, attached, and a packaged workflow, attached, that parse both the image and the file you sent. In either case, you only have a month and day, no year. I made the assumption that these are in 2020 and hardcoded that. Please check.

Highlighted
8 - Asteroid

Thank you so much for your quick reply and help. But there are some filename not standard format saving and I use the workflow it doesn't work to all of them. Is there any other ways to solve? thank you

Highlighted
Alteryx Certified Partner

.

Highlighted
Alteryx Certified Partner

Hi @lilyyangadsk 

 

please try this workflow.

Labels