Publicado Thu, 07 Feb 2019 06:09:50 GMT por 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.

Publicado Wed, 12 Feb 2020 11:34:15 GMT por Dean Birks ABC Digital Solutions LTD Professional services
Hi,

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?

Thanks

Dean
 
Publicado Wed, 12 Feb 2020 12:20:14 GMT por 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

You must be signed in to post in this forum.