Turn text into web-safe strings

[Adam_Kramer]

Hey guys,

I am wondering how I would go about importing text from another field like “Diamond Plus” and translating it into “diamond-plus”?

Any way to do this without just building a really long IF statement?

Thanks so much,
Adam

[Kamille_Parks · Accepted solution]

LOWER(SUBSTITUTE({Field Name}, ' ', '-'))
^ that formula replaces spaces with a dash, then sets all letters to lowercase.

[Adam_Kramer]

Kamille_Parks:

LOWER(SUBSTITUTE({Field Name}, ’ ', ‘-’))

Thank you so much! Works like a charm :slightly_smiling_face: