Alteryx Designer Desktop Discussions

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

How to handle a "\" in a field that is used in a file path.

orangebomber
7 - Meteor

I have a workflow creating individual excel files.  The path was created using a formula tool and adds the supplier name to the file name.  We have one supplier with a "\" in their name.  This creates an error message "Unable to open Archive for zipping...the system cannot find the path"  I noticed the supplier name had "Corp.\Max" in the name and clearly the backslash was being interpreted as part of the path.  I pull this list and would like a dynamic way to handle.

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@orangebomber 
As far as for Windows, the "\" is an illegal character for File Path or File name, right?
So how do we expect the "\" will be used?

caltang
17 - Castor
17 - Castor

As @Qiu mentioned, I don’t think there’s a way around this unless you remove the “\” from the name. 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
orangebomber
7 - Meteor

My first thought was how to leave it in but on the way home I thought about using Regex to replace it with another acceptable character like a "-".  This is still dynamic and doesn't impact the path.  Thank you!

Labels