Hi Team,
As StrAlpha copies the alphanumeric character form string.
Can we use the strAlpha function for any languages like Chinese etc...
Please give me more shed on this.
thanks!
Kindly explain your scenario more so that I can understand more easily because strAlpha copies only the alphanumeric characters from a string.
It's about what you expect. The method's target is non-alphanumeric values. I don't know in detail, but I think these values are language independent. As you can see below, the result is as we expected, but if "=" has a different spelling or equivalent in Chinese, you may not get the result you want.
thanks all,
My requirement is to ignore white space , invalid characters ( Chinese ) from a text.
The issue was in Purchname ( text ), Vend name or Item name. So, we wants to fix those issue. If any invalid characters found any fields it should remove those and able to export the report in excel aswell...
Is strAlpha() can do ?
I don't know the background but my guess is there are non alphanumeric values set. StrAlpha eliminates these values. In this case, it will not do what you want.If it works the other way around (extracting values that aren't in the alphanumeric list), you'll get the result of your request, but I don't think so.After all, it's pretty easy to try.Open a table with two fields. Check for length when returning PurchName values. If the lengths are different, it means that strAlpha worked on these records. If you save it in the table and check the values in the two fields, you can see if it does what you want.
while select nameTable where nameTable.PurchName { strAlhhaValue = strAlpha(nameTable.PurchName); if(strlen(strAlhhaValue) != strlen(nameTable.PurchName)) { newTable.AlhhaValue = strAlhhaValue; newTable.NameValue = nameTable.PurchName; newTable.insert(); } }
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 796
André Arnaud de Cal... 721 Super User 2025 Season 2
Sohaib Cheema 530 User Group Leader
