on 02-21-2024 5:29 PM
Hello All,
I have created a Group formula as follows:
local numbervar i;
local stringvar ID := {Command.EVSTRNAME};
local stringvar ID2;
If isnumeric(ID) Then
tonumber(ID)
Else
(
for i := 1 to len(ID) do
(
if ID[i] IN ['0' to '9'] then
ID2 := ID2 & ID[i];
);
tonumber(ID2);
)
It only shows numeric values in the groups and ignores all values with strings as suffixes. I need help if the above formula shows 101AA in the group. Please let me know if you have any questions. Would appreciate the help
If the alpha characters are always at the end, you can simply use:
ToText(Val(input),0,"");
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
11 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.