AnsweredAssumed Answered

Text formatting with function help

Question asked by BobSchwenkler on Oct 12, 2009
Latest reply on Oct 12, 2009 by mrvodka

Title

Text formatting with function help

Post

Hi All,

 

My function skills are still at a relatively basic level, so I'm turning here for some help with a formatting function. What I need to do with it is pretty simple: Take a string of text and strip any non-letter or non-number characters (including spaces), and replace them with hyphens. After that I need to remove any instances of multiple hyphens in a row, leaving just one.

 

Example: "Kickball -  Everything is a Miracle... Vinyl" becomes "Kickball-Everything-is-a-Miracle-Vinyl"

 

Probably relatively simple thing, but I still don'thave my mind around functions within functions.

 

Thanks! 

Outcomes