Substitute Function to clean field name

[Greg O'Connor]

Greetings.

Surely, it is somewhere in the archive, but I cannot find it:

How to write a Substitute function:

Substitute(text;searchString;replaceString)

to change all those characters to an underscore:

,(comma), +, -, *, /, ^, &, =, ≠, >, <, ( ), [ ], { }, ", ; (semicolon), : (colon), : (relational indicator), $ (variable indicator)

Or is there a custom function available to do this?

Any help would be great.

Thanks

Greg

[Greg O'Connor]

I have come so far:

Substitute ( Text ;

[",";"_"];

["+";"_"];

["-";"_"];

["/";"_"];

["^";"_"];

["&";"_"];

["=";"_"];

["≠";"_"];

[">";"_"];

["<";"_"];

["(";"_"];

[")";"_"];

["[";"_"];

["]";"_"];

["{";"_"];

["}";"_"];

["*";"_"];

[" ";"_"];

[";";"_"];

[":";"_"];

["::";"_"];

["$";"_"]

)

I am not able to substitute the character "", backward slash. Is there a way?

Isn't there a more simple way? .. or a custom function available?

Greg

[comment]

To substitute a backslash, use:

...

[ "" ; "_" ] ;

...

I don't see how a custom function would be simpler in this case. Unless you often change that list of characters - if so, you might want to have a look at this:

http://www.briandunning.com/cf/101

Disclaimer: I am not the author of the function, and I haven't tested it in any way.