Publié Thu, 07 Feb 2019 06:09:50 GMT par 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.

Publié Wed, 12 Feb 2020 11:34:15 GMT par 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?


Publié Wed, 12 Feb 2020 12:20:14 GMT par Simon H. Hellmann Toshiba Tec Germany Imaging Systems 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

You must be signed in to post in this forum.