How to Unread the Japanese/ Chinese Characters

[#1]

Hi

I have one column which contains both English names and Japanese/ Chinese names.

I would like to read only English names but not Japanese/ Chinese.

Is there any condition, only to read English names excluding Japanese/ Chinese names.

Thanks

Fareed

[sathishkumar_go]

Hi

Can u attach ur application here?

-Sathish

[#3]

Hi Satish

Please find attached file. I do not want read Japanese names.

Thanks

Fareed

[sathishkumar_go]

Hi

U want only numbers? or ?????

-Sathish

[#5]

I want the data( Names) as it is except Japanese characters(Names).

Thanks

Fareed

[sathishkumar_go]

Hi

Please find the attachements.

-Sathish

[#7]

Hi Satish

Thanks for your effort that is what I am looking for. you have created the attached application based on filters function , but my data keeps on increase every week.

What If my names exceed above 350 lines, I need the condition where i can run the scripts once i have more names.( These names will be jumbled every week)

Qlikview has to recognize these Japanese characters and it has to exclude from the table.

Thanks

Fareed

[Anonymous]

Fareed,
Try to use keepchar(Name, 'abcd...xyz'). It will remove all charatcers from the field except the latin alphabet. The names which don't have any of these letters will be converted to null, and easy to eliminate.

[sathishkumar_go]

Hi

Every week it ll increase then go for Michel Suggestion.

That 1 also work with all stages.

-Sathish

[Anonymous]

Another approach is to use the Ord() function that returns the ASCII number of the first character in the string.

A returns 65 and then it ranges up with special characters etc. Looking at the japanese characters, they're in QlikViews 20000 range so a simple if statement ought to do it:

if(ord(Reg)<200,Reg) as Reg

//jsn