How to use Regular expression (RegEx) to complete the account no?
Posted: 08 Jan 2023, 11:27
Suppose I this short account number of the customer- 1012345
Now i want to complete this account no by adding- 8899 at the starting of the above account no and 000 after "10" and before "12345"of the above account no. Namely the full account number of the customer will be- 88991000012345 (14 digit). please look at this image for understanding what i want-
i tried these codes but with fail-
I know there could be more ways to do what i want namely using commands like substr() and other string related commands and functions. But i want do it by using Regular expression for learning purpose. Please tell me how to do that...???
Thanks a lot....
Now i want to complete this account no by adding- 8899 at the starting of the above account no and 000 after "10" and before "12345"of the above account no. Namely the full account number of the customer will be- 88991000012345 (14 digit). please look at this image for understanding what i want-
i tried these codes but with fail-
Code: Select all
MsgBox % RegExReplace("1012345", "^", "8899")
Thanks a lot....