Search function

Mees · April 15, 2011 7:05AM

Hi there,

I am using the search function in DM, but it behaves in a way I can't explain.
I need to position of the space in the UK postcode value. For most postcodes it works, but for some it doesn't.

Examples:
- Postcode = BH10 4HT: Search(" ", [Postcode]) => 5 (is expected result)
- Postcode = MK45 2QW: Search(" ", [Postcode]) => null (is not the expected result)

Can you please advise?
I attached a simple example file for your convenience.

Thanks
Arjan

chris · April 18, 2011 5:18AM

Hi,

Thanks for the post. The SEARCH function doesn't appear to be working when you are trying to search for space (" ") characters. It does work for other characters. We will investigate and fix this. I will let you know once we have implemented a fix.

Chris

chris · April 18, 2011 10:22AM

Hi. This has now been fixed. The fix will be available in tonight's Omniscope 2.6 release. Please let us know if you encounter any more problems or have any questions.

Welcome!

Categories

Ideas Parade