投稿済み Thu, 07 Feb 2019 06:09:50 GMT 、投稿者 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.

投稿済み Wed, 12 Feb 2020 11:34:15 GMT 、投稿者 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
 
投稿済み Wed, 12 Feb 2020 12:20:14 GMT 、投稿者 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

フォーラムに投稿するためにはログインが必要です。