I am importing text from an Access databases and most of the fields end in a space. It would seem that Omniscope is removing these spaces, or applying an automated TRIM? Can I switch this off?
A field I am importing from Access is a concatenation of 4 other fields. These are all text fields and in order to keep the data integrity I have included a space between each concatenation. Field 1 is mandatory but the other three are optional. If any of the subsequent fields are null I need the space as it is included in a SEARCH function within omniscope. I could include a search which doesn't include the space but i risk poor results. for example picks up the specific word COM but without the space in the search could identify COMPANY which I don't want it to.
I still don't fully understand. Are you saying that you concatenate the fields inside Omniscope? If so why don't you add the space in Omniscope when concatenating the fields rather than inside Access. In order to get a better understanding of your problem would it be possible to arrange a short screen-sharing session with me? Please contact us on support@visokio.com and let us know when it would be convenient.