Hi all,

I am trying to write a calculation to make a URL safe string from a field. By URL safe I mean only containing A-Z 0-9 _ and - .

I have a PHP script using regexp to do this on the web side but need to convert it to FM.

Requirements

-------------

Replace one or more spaces with a single "_"

Replace one or more & with "_and_"

Replace anything not A-Z 0-9 _ with "_" ([^_a-z0-9]+

I've been playing with the Substitute function but it appears I would have to do this individually for every character I dont want, and then check for double (triple, quad..) underscores.

Can anyone help with this.

Cheers

Matt

Edited June 2, 200619 yr by Guest

Sounds like a job for a custom function. Admittedly you will have to allow for all your parameters, but it will simplify the job.

Yes, you will have to use the Substitute function. I don't see any way to make it easier.

Think I sorted it, not perfect but seems to work OK

Substitute ( 

  TrimAll ( 

    Filter ( 

      Lower ( text ); 

        "abcdefghijklmnopqrstuvwxyz _-" ); 1; 0); 

" "; "_")

:cofeebrake: