Hello,
i have a text like this
and want to extract the text after ":".
The length of the extractet text can variate. My Idea was to do this with the Mid Function like this
but the the length is not right. I think that im using the Newline Character wrong.
I can solve the problem with
But this will not work for the last entry cause i dont have a word after it like "Datum:"
I mean, i can spilt the text with NewLine() in a collection, but there must be an easier way..