2,976
Hello,
Is there a way to decrease the String value, as INCSTR do increase the String value
E.G.
String := C0001;
Share
ReportINCSTR(String)==> C0001 -> C0002 ;
You can also suggest your Custom Function. But i am looking for the efficient way to handle this function.
Thanks.
*This post is locked for comments
the links i provided show typical looooong nav style functions.
using .net classes i developed a much smaller, cooler function:
// loc. vars
// DocNo : Code-20
---------------------------------
OnRun()
DocNo := DecStr('ABC00010'); // typical document no.
MESSAGE(DocNo);
---------------------------------
// loc. vars
Prefix Text
NoString Text
Number Integer
Regex DotNet System.Text.RegularExpressions.Regex.'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
DotNetInt DotNet System.Int32.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
PadLength Integer
---------------------------------
DecStr(DocNo : Code[20]) : Code[20]
Prefix := Regex.Replace(DocNo,'\d+','');
NoString := Regex.Match(DocNo,'\d+').Value;
Number := DotNetInt.Parse(NoString); // instead of using Evaluate
IF Number > 0 THEN BEGIN
Number := Number - 1;
PadLength := STRLEN(DocNo) - STRLEN(Prefix) - STRLEN(FORMAT(Number));
EXIT(Prefix + PADSTR('',PadLength,'0') + FORMAT(Number));
END;
ERROR('Resulting number would be negative.');
---------------------------------
Results in: ABC00009
the resulting number has the same length.
Write a function to extract the numeric part and decrease the number, then padding 0's add that number to the str.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (