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.
Hi @lilyyangadsk
please try this workflow.
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
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.