Search results

Sure, here is what I did: Module: Option Explicit Function regexp(StringToCheck As Variant, SearchPattern As String, Optional CaseSensitive As Boolean = True) Dim re As New regexp re.Pattern = SearchPattern re.Global = False re.IgnoreCase = Not CaseSensitive Dim m For Each m In...

I will have a look at that. Thanks for now!

[clientno] like regexpr([importgliberish];"[a-z]\d{5}";False) - like that?

Alright mate, now you got me. What on earth is a "non-equi join"?

Yes, but since the field, I need to compare the client-number with, in its imported state looks something like: "DimvlaanA23142Order#722638445" I need to separate the client number first - then I can do the query and verify the correctness. Does that make sense? Anyway, I found the solution, I...

You also pointed me to the right direction, yet Galaxiom was a bit earlier, so I was on the path already. Thanks!

Sir, this is a very good answer. Actually the one I was searching - but sometimes one searches for things with absolute wrong expressions, so an answer might never be found. I used this in my db, and now I have the data separated from the rest, which is what I needed. Perfect! Thanks!

At some point, yes. Since the banksystem only gives me a csv with the data. Running a query in our db could be done, but I need to extract the client number from this one specific field, first, else I can't connect them to the payments made.

Hi, reason why I look for a module-solution is, we import the file from our banking-system into access, extract this clientnumber, and then combine it with the data from our clients, residing in our db (which is not connected to the bank). We need to export it again in a different format, so...

Hi, yes, the "client" is always this format, and if it is not present, or missing some letters, which I would check, after running any script, I would look for an order-number, which also might be present, but which we are trying to eliminate for the ease of use. But this is a long process, as...

Hello everyone, I need your help. I am in search for a module (or whatever might work) for my Access 2016. I need to find a "random" 6 string value within a field from a table. We are processing transactions, and we need to more or less easily find the client-number in this field...

Hello to everyone here! I have been a long-time "read-only" person, but now I need some specific help... and I am sure, you guys can. Thanks for reading this :)