Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Can u attach ur application here?
-Sathish
Hi Satish
Please find attached file. I do not want read Japanese names.
Thanks
Fareed
Hi
U want only numbers? or ?????
-Sathish
I want the data( Names) as it is except Japanese characters(Names).
Thanks
Fareed
Hi
Please find the attachements.
-Sathish
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
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.
Hi
Every week it ll increase then go for Michel Suggestion.
That 1 also work with all stages.
-Sathish
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