Filtering out records based on UNICODE values

Inquisitive · Post by **Inquisitive** » Mon Apr 23, 2007 3:53 pm

Hi,

We have a requirement to filter out Japanese languade address records from the source when we extract and process records.

Is there any we can eliminate these records based on UNICODE values in those fields?

Thanks

nick.bond · Post by **nick.bond** » Mon Apr 23, 2007 4:24 pm

No sure but to identify an individual character outside of the standard Ascii you could try

Code: Select all

If input.field > Char(127) then 'Invalid' Else 'Valid'

Not had to do it before though.

DSguru2B · Post by **DSguru2B** » Mon Apr 23, 2007 4:54 pm

Nick's code will not work if your input is a string. You need a recursive mechanism to check for ascii values if you want to go down that path.
Do you have NLS installed? If you view these characters at the OS level, how do they show up?