Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
silentwolf's latest activity
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 27, 2024
S
silentwolf
reacted to
CJ_London's post
in the thread
Help with Instr Function
with
Like
.
if you use sql to connect to the text file (or use transfertext to link to the file) you can do all that in a single query (or one per...
Apr 26, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 26, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 26, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
Ok..) First line is the string Second the expected result 1.) 000001222098 4377015051912129 ( 1 UMS) AT173900000001093566 / RZKTAT2KXXX...
Apr 26, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 26, 2024
S
silentwolf
reacted to
cheekybuddha's post
in the thread
Help with Instr Function
with
Like
.
VBA Like Operator If strtext Like "AT#*" Or strtext Like "DE#*" Then ' ...
Apr 26, 2024
S
silentwolf
reacted to
Josef P.'s post
in the thread
Help with Instr Function
with
Like
.
Are you looking for the IBAN position? public Function IbanPos(ByVal TextToCheck As String, Optional ByRef Iban As String) As Long...
Apr 26, 2024
S
silentwolf
reacted to
CJ_London's post
in the thread
Help with Instr Function
with
Like
.
Any reason you can't use? If strText Like "Überweisung:AT*DE*" or If strText Like "Überweisung:*AT*DE*" Some example data with the...
Apr 26, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 26, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 25, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 25, 2024
S
silentwolf
replied to the thread
Help with Instr Function
.
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...
Apr 25, 2024
S
silentwolf
posted the thread
Help with Instr Function
in
Modules & VBA
.
Hi guys, just wondering if someone could help me with this below function= I like to find words starting with AT followed by any...
Apr 25, 2024
S
silentwolf
replied to the thread
Solved
Update one field with another using like operator
.
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...
Apr 21, 2024
Home
Members
Top
Bottom