You’re offline. This is a read only version of the page.
Announcements
18
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!
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.
Share
Report
All responses (
Answers (
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();
}
}
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 ?
Please give me more shed on this.
thanks!
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.
#1
André Arnaud de Cal...
294,120
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
