Remove spaces

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.

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
 

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