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.
Solved! Go to Solution.
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
Could you kindly help how to write, I am new to alteryx. thank you
Please provide the data, not an image. Please describe the desired output that you want to achieve as well.
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.
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.
.