Is there a way to add/customize field entry validation rules? I'm using Japanese characters. Some Japanese characters can be entered single width or double width - they are the same character (see the attached image). To avoid duplicate entries, I would like to prevent single width Japanese characters from being entered into the system (from the web browser and from imports). This is typical in most Japanese system so I would like to add this validation rules to Marketo as well.
Welcome any suggestion on how to do this. I can use "Change Data Value" but doing this on each name is too time consuming.
Thanks for the reply. As you replied, I can I can just add my js conversion routine to my custom forms to convert alphanumeric from double width to single width and kana characters from single character to double characters. I was wondering if there was any way to extract invalid entries from the Lead Database "Lead" page.
One option to extract invalid entries from the Lead Database "Lead" page would be SOAP API getMultipleLeads, setting lastUpdatedAt from the date you noticed the single characters.
A short PHP or Java program would loop through each line, parse first and last name based on the position of preceeding comma (evaluated from column headers) and convert kana characters from single character to double characters.
You can then either re-upload using the regular Import feature or SOAP API syncMultipleleads.