Sep 03, 2013
Cristian
wrote
Hello,
I didn't find any information regarding my problem so I'm asking this question in this forum. How can I set the program to replace automatically some characters in my product names?
We are using diacritics and those characters (ă,î,â,ș,ț)are eliminated automatically from the url. How can I replace ș with s, ț with t, î with i and ă&â with a?
There is a menu in the Preferences but I didn't find any documentation on this specific issue.
Thank you in advance for your help!
I didn't find any information regarding my problem so I'm asking this question in this forum. How can I set the program to replace automatically some characters in my product names?
We are using diacritics and those characters (ă,î,â,ș,ț)are eliminated automatically from the url. How can I replace ș with s, ț with t, î with i and ă&â with a?
There is a menu in the Preferences but I didn't find any documentation on this specific issue.
Thank you in advance for your help!
Reply
1 Answer
Sep 04, 2013
Ira Kobylianska
agent
wrote
Thank you for your reply.
You an use the following expression during import:
REPLACE(REPLACE([CSV_COL(x)],'ș','s'),'ă','a')
where x = url key field from your database (you can assign product name to url key as well)
Please let us know how it goes
You an use the following expression during import:
REPLACE(REPLACE([CSV_COL(x)],'ș','s'),'ă','a')
where x = url key field from your database (you can assign product name to url key as well)
Please let us know how it goes