Search results

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

No it is only for text between End of Mandatsnummer: xxx-xxx*-xxx and REF: If there is a text I need it but if there is Auftraggeber or Zahlung then not this is already processed ;)

Ok I will try that ) Thanks

Sorry for posting so many threats today but need to finish a project of my self today and am a bit stuck at times. I got this RegEx code from someone here on the forum but not sure who it is right now! Sorry Public Function ReturnMandatsnummer(strText As String) As String Dim RegEx As...

Hi guys thanks again! Yes it works as arnelgp has provided and yes your rigth Minty I need to put comments into it just need to understand it first lol ) Very complex for me his function but it works like a charm :) @Josef P. thanks also I will try yours as well later on to see if I can make...

Hi guys, many many thanks to you all!! @Minty I will try your function with an Case Else statement too! Many thanks @arnelgp Yes that works now perfect!! Cheers!!