Finance | Project Operations, Human Resources, ...

Can we use the strAlpha function for any languages like Chinese etc...

(1) Share

Report

Posted on by @rp@n

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 have the same question (0)

All responses (4)

Answers (0)

Laraib 131 on at

Like (0)

Report
Copy link

Link copied!

Kindly explain your scenario more so that I can understand more easily because strAlpha copies only the alphanumeric characters from a string.

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (1)

Report
Copy link

Link copied!
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(); } }

Was this reply helpful? Yes No