Awesome as always LJ. Thank you. Mark
From: ARSList [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Monday, February 26, 2018 10:07 AM To: ARSList <[email protected]> Subject: Re: Increment a character "number" Grab the RIGHT($field$, 4) and put it into an integer field, increment that field, then use an LPAD to re-add the ABC to it as necessary. On Mon, Feb 26, 2018 at 7:43 AM, Brittain, Mark <[email protected]<mailto:[email protected]>> wrote: HI All I have a requirement to take a number such as ABC0005 in a character field and automatically increment. The case is I have a form where I list the first number (ABC001) and the quantity (5). When the create button is selected, there would be a push field to create a new record (x5) with sequential numbers (ABC001, ABC002, ABC003, ABC004, ABC005). Anyone do something like that? ARS 9.1 Thanks Mark Mark Brittain | Senior Systems Engineer | 315.634.9337<tel:(315)%20634-9337> 125 Elwood Davis Road | Syracuse NY 13212 [new_spectrum] -- ARSList mailing list [email protected]<mailto:[email protected]> https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
