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:
GB123456789
123456789
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:
123456789
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
Oleg Karpun
shared this idea
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
Hi,
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. -
Anonymous
commented
Dear,
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) -
Alex
commented
you can do this with a field validation. http://help.docuware.com/en/#b57862t55792n67943
-
David
commented
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.