Veröffentlicht Thu, 07 Feb 2019 06:09:50 GMT von Kjetil Kulterud Service Owner

Is it possible to remove spaces between characters in a field?

When using One Click Indexing a number is stored like this 111 222 333. 

When searching the customer want to search on the whole number without spaces, ie111222333.

Veröffentlicht Wed, 12 Feb 2020 11:34:15 GMT von Dean Birks ABC Digital Solutions LTD Professional services

did anyone ever find a solution to this. I have a similare issue with serial numbers. It adds spaces after a number or letter.

eg . A5C21343455 when autoindexed comes out as A 5 C 21343455

Any ideas?


Veröffentlicht Wed, 12 Feb 2020 12:20:14 GMT von Simon H. Hellmann Toshiba TGIS GmbH | IT-Consultant - Document Management Solutions

Hello Dean,

you can do this with a data assignment in a Workflow using the "replace" function in an arithmetic expression:

Replace(String, String, String, Int32, Int32, CompareMethod)
//Returns a string in which a specified substring has been replaced with another substring a specified number of times.

example: Replace(GV_Number," ","") would replace all spaces in the global variable "Number" with nothing.

Hope this helps.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.