Backslash in Name causing bot-generated file location to create folder

I have the following filename prefix when a bot generates a file:

CONCATENATE([DO Number]," ",[Customer Key].[Customer Name])

This works fine 99% of the time. The exception occurs when the Customer's name contains a backslash. 

Eg: "Jane D/O John" where D/O is part of her name.

The result is that the folder where the file should be has a new folder within it called "12345 Jane D" and in that folder contains the file with name "O John".

How do I overcome this problem of the backslash without changing the customer's name entry?

0 1 56
1 REPLY 1
Top Labels in this Space