Thanks a lot. It works with your suggestion" strHold = Replace(Trim(pStr), ".", ":") ". This helps to shed off the alpha or special characters so that an invoice number could be read as a general index number to prevent duplicate payments.
It's about extraction of numbers from string .
You had offered a solution in 2011 " Function SaveNumer2(ByVal pStr As String) As Long" but not effective when there is a period in between while extraction of numbers. Example
"Inv.1234". Could you please help.
QUOTEE=pbaldy;1444280]What code...
Hi,
This is very useful. Thanks for the solution.
How to tweak this to extract a number from a string that contains a period(.). Example:. "Inv.1234".
Thanks
Hi All
I am Ganesh alias GT from India, Chennai. Thanks for this gateway. I am a freelance business process consultant with Accounting domain. Happy to interact with you all.
Thanks