I'm having troubles extracting the date "DD.MM" inside my clipboard correctly. My clipboard typically looks like this:
In this case I can get the text using:Ja NBS 26.09.2019 123456789 Team Auto FIRSTNAME LASTNAME K12345 A RI NOK 4.656,04
Code: Select all
oldestdate:= SubStr(clipboard, 8, 5)
There are never any digits before the actual date, so the first thing that comes to mind is something like:
Code: Select all
oldestdate:= SubStr(clipboard, FIRST INSTANCE OF A DIGIT, 5)
Thanks for any input