Jump to content

Substitute Function to clean field name


This topic is 6097 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6097 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.