Group Formula of a field

[GSG]

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

[ido_millet]

If the alpha characters are always at the end, you can simply use:

ToText(Val(input),0,"");

[GSG]

Thank you for your reply. Alpha characters are not always there, we add alfa characters occasionally.

[ido_millet]

My solution works if alpha characters -- if they are present -- are at the end.

[GSG]

Is it will be the new formula or edit the exiting formula as stated in my initial question?

[ido_millet]

It completely replaces your formula. Much simpler because the Val() function extracts the numeric portion at the start of a string.