Solved

Turn text into web-safe strings

+8

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

Best answer by Kamille_Parks11

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

+27

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

+8

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

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

Sign up