So in my Case I receive BankStatements with CSV as discussed.
This Field is up to 600 chars so pretty big, therefore I split some data out of that field into diffent fields.
That is all well and good.
After that update I am left with Data discussed above.
My FieldName at that point is "UMS"...
Pretty need CJ :-)
Some very good points there I will look into it and see if I can put it all in place in my system.
Will let you know how I am going!
Cheers !
Hi CJ,
well at the moment there are not more but I do have another account where I need to check but it should be pretty much the same.
I was going down the path with having a table and compare it with a Like Operator...
My thought where like: Importing the Data "Original CSV-File" into a...
Hi Eberhard,
thanks for the info.. I am still working on how to have a working system to isolate parts of the string but I slowly getting there.
As you mentioned using a seperator is surely an option.
To start off I am using filters to limit Text Patterns.
I guess that would also speed up the...
Hi David,
thanks yes I was trying that too..
now I have it sorted but I am sure there is a much better way of doing it.
Maybe someone could adjust it a bit so it is a little nicer.
Public Function IbanPos(ByVal TextToCheck As String, Optional ByRef Iban As String) As Long
Const Pattern As...
Hi Josef,
yes I need to get the Iban position :-)
just testing your code.. but how can I get reg ex to get this part out as dicriped in my previous post :rolleyes:
Hi CJ,
the issue is that "Überweisung does continue with Dates so each of them is different and the double dots are at the end of that date.
e.g. "ÜBERWEISUNG INTERNET AM 2022-06-30: "
others are without ":" "ÜBERWEISUNG INTERNET AM 2022-08-12 AT1245xxxx" and have a different pattern so those...
Thanks Gasman I will do that :-)
maybe arnelgp could also let me know what to do if you like to replace some string with blanks with regex ;-)
That would be fantastic
Cheers
Hi guys,
just wondering if someone could help me with this below function=
I like to find words starting with AT followed by any digits and the same with DE followed with digits
This is what I got so far..
Public Function ReturnZahlung(strText As String) As String
If strText Like...
Hi Pat,
yes I am aware of this but in this case it has nothing to do with relational database.
One table only updates one field with a temp file. No linked linked tables or no two field with same data in a table.
Hi there,
thanks for the input! I would need to look into that but in my case there a not really alot of data so it is for my need planty of speed.
But never know when it comes down to alot of data there is always good to know that there are different ways and perhaps better ones.
Never mind.
Worked it out!
strSQL = "UPDATE AUSZUG, UmsatztextTable SET AUSZUG.Umsatztext = [UmsatztextTable].[Umsatztext] " & _
"WHERE (((AUSZUG.Umsatztext) Like ""*"" & [UmsatztextTable].[Umsatztext] & ""*""));"
This does the job :-)
Hi Pat,
thanks for your reply.
Well I have data from a CSV File the field names are long or to long. The Field is called "Umsatztext"
Because there are always multiple same names in that table I created a different table where this Text is shortend so.
125 Cr Avenue, Mr. Bill Sorrow AT1245...