Remove preceding/trailing/in-between spaces in Store dialog fields
We having issues with certain fields (eg VAT numbers) in Intellix Store Dialog, these fields are used in conjunction with Filtered Select Lists.
Problem is - different companies write VAT fields different ways:
GB 123 4567 89
which is completely break our filtered select lists, since we query customer CRM for that VAT number, where all of it kept uniform, like:
We need ability to format post-Intellix fields in store dialogs - remove spaces, or certain characters using Regex or just list of characters to be removed, like:
GB| |VAT (second item is blank space)
Thank you for your idea. Right now we are focusing on other topics, so we are not considering this idea for future releases. If the demand for this topic increases, we might add it to future plans.
Christophe Mathieu commented
Also need to remove some characters (like dots) when using DW Import. Because recognized text is not always formated as expected depending of the sender (123.456.78, 123-456-78, 123 456 78, ...)
A rule in the store dialog should do the job for both prefill method.
Should be also nice to have this feature within import configuration. In my case, for example, I've a filed like " *** Customer Nbr ***" , I would like to remove the * character.
(We can use the AutoIndex module for this, but it's not a proper solution)
you can do this with a field validation. http://help.docuware.com/en/#b57862t55792n67943
Yes, could be a good idea if we can apply auto-correction/format within field (as we are able to do with Printer or Import configuration).
This correction/format could be set in Intelligent Index setting bannet when we setup link between Intelligent indexing index and storage form index.