Invalid Character when converting to Path

Hi,

I would like to use a content of a column to generate a filename.
The problem: it contains invalid characters that prevents string to path conversion.

I think this could be solved by a String Manipulation regexReplace() but I’ve never really understood the syntax of RegEx.

Basically I would like to remove or to replace by a “_” all forbidden character (<,>,:,",/,,|,?,*) and also trailing char < > ( I had this error as well).

Do you have a solution ?
Thank you.

Hi @Zarkoff95

You can remove all special characters, and replace them with “_” by using this regex in the string manipulation’s regexReplace function: [^a-zA-Z0-9/]

My string manipulation node’s expression: regexReplace($column1$,"[^a-zA-Z0-9]" , “_”)

input:af645*//=#$%&%$^<>
output:af645_____________

5 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.