luis_marques
Member
Hi,
I need to replace old URLs for new ones, but i need capture text from de field called NOME (Name in english). For instance in the column A:
NOME
Roupa PJ Masks - Blusa PJ Masks - Corujita - Cinza - Malwee
Then i need to format like this in a new column:
NEW URL
roupa-pj-masks-blusa-pj-masks-corujita-cinza-malwee
So the requirements:
1. Remove all trailing spaces, spaces in general
2. Keep just one hyphen between words
3. Lower case all new url
I would appreciate help. Thanks in advance.
I need to replace old URLs for new ones, but i need capture text from de field called NOME (Name in english). For instance in the column A:
NOME
Roupa PJ Masks - Blusa PJ Masks - Corujita - Cinza - Malwee
Then i need to format like this in a new column:
NEW URL
roupa-pj-masks-blusa-pj-masks-corujita-cinza-malwee
So the requirements:
1. Remove all trailing spaces, spaces in general
2. Keep just one hyphen between words
3. Lower case all new url
I would appreciate help. Thanks in advance.