GetValidFileName function – removes or replaces illegal characters from a file name

by Peter on November 28, 2009

in User Reference

Post image for GetValidFileName function – removes or replaces illegal characters from a file name

The <<GetValidFileName>> function will examine a value for characters which are illegal in a file name, and either remove those illegal characters, or replace them with a string supplied as a second argument to the function.

For example, if the data element name Reference contains the string Smith/Jones & Co then <<GetValidFileName(Reference,‘-’)>> will return the value Smith-Jones & Co. In other words, the character “/” has been replaced with “-”.

The fillpoint <<GetValidFileName(Reference,‘’)>> will remove illegal file name characters from Reference. Using the above example’s data values, this would return SmithJones & Co.

Related posts

Leave a Comment

Please remember your comments are subject to our comment rules.