Recent content by silentwolf

Hi Isaac, all good just did not know and it is nice that you are pointing this issues out!

Ok thanks I will need to look into it a bit more )

hmm ok.. What I did try was in one new module using Compare Text and it was working as Josef discribed.. But still very confused about this lol (

I tried with option compare Text.. getting an Error sayin it is used serveral times ?? Does this statement not come on top of the Module like Option Compare Database Option Explicit Option Compbare Text I have nowhere a option compare Text in my database so not sure what this error means and...

Oh I see says the blind man ) I will do that and let you know how I went with it! Cheers for making it more clear to me )

Hi Josef, you making me looking bad very bad lol 🙄😳 I have no clue what you are saying at this point oh my gosh ;)

I understand what you mean.. well I hope it is robust enough for what I am doing. But many thanks for pointing out those possible issues!!

Yes I guess so but it is still a bit much for me to handle all propabillities. For one statement over a year it is working as intended need to look for other years and check there will be for sure more to do or do update different functions. That is why RegEx comes handy but I am still very...

Hi David, my function returns everything after the Mandatsnummer: xyz to the REF: so everything in between. It is a bankstatement as you for sure guessed but there are as always many different ways they provide the Data. And in some I just need what ever is after the Mandatsnummber:xxx and...

Ok I understand! Cheers Pat )

Hi David, oh I did manage with this function below Public Function TestFunction03(strText As String) As String If strText Like "*Mandatsnummer*" Then If strText Like "*Zahlungsreferenz*" Or strText Like "*Auftraggeberreferenz*" Then TestFunction03 = "" Else...

I think I am getting there just had a aha effect lol maybe not the elegant way but ...

Well I am not sure how to use or get the length of the mandatsnummer out of my function :( because there are many of this kind of functions in that module so I dont need to rewrite them over and over again

So this is what I got at present.. Public Function TestFunction(strText As String) As String If strText Like "*Mandatsnummer*" Then If strText Like "*Zahlungsreferenz*" Or strText Like "*Auftraggeberreferenz*" Then TestFunction = "NA" Else mStartPos =...

Yes I will but I am taking a short break from it getting headache :) Cheers