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?
User | Count |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |