Validate the string if in English

bakshdwh · Post by **bakshdwh** » Mon Dec 17, 2012 2:26 am

Dear All

I'm trying to validate a string, which has arabic and English data in it..

If the data is in Arabic then pass '' else pass the column as is..
Could you'll pls help in this case.

Tried Alnum/Alpha, but doesn't work

ray.wurlod · Post by **ray.wurlod** » Mon Dec 17, 2012 3:41 am

Code: Select all

svIsEnglish <-- (Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ ,.'-", "", UpCase(InLink.TheString)) = "")

Convert all English characters, including punctuation, into "" then see if there's any characters remaining.

bakshdwh · Post by **bakshdwh** » Tue Dec 18, 2012 2:04 am

Thanks
This really helped..

Appreciated.. thanks again