No announcements
Found 1486718 threads
-
1 VotesInStr function
0 Then MessageBox.Show("Got matches") Else MessageBox.Show("No matches") End If End Sub ...Answered | 4 Replies | 2026 Views | Created by endeka - Tuesday, October 16, 2012 1:37 PM | Last reply by Paul P Clement IV - Tuesday, October 16, 2012 6:39 PM
-
7 Votes
Instr Function
On the other side a appreciate RegEx in VBE replace & search tools... but RegEx stays for me in class of tools, for which I ever rather write my own functions using standart Strings ...Answered | 7 Replies | 3404 Views | Created by Anonymous123sdaf - Thursday, December 4, 2008 9:44 PM | Last reply by Tom Shelton - Friday, December 5, 2008 8:53 PM -
0 Votes
Using the INSTR function
I guess working with instr is not an option because I guess it does not search through a string other then for a specific substring and not like the regex example I have in the top.Answered | 11 Replies | 1394 Views | Created by Les2011 - Wednesday, November 29, 2017 1:17 PM | Last reply by Les2011 - Thursday, November 30, 2017 1:58 PM -
0 Votes
instr related function in sql server
I suggest you look at this: http://www.sqlines.com/oracle/functionsAnswered | 3 Replies | 1446 Views | Created by ArunaMSBI - Thursday, June 4, 2020 11:39 AM | Last reply by Tom Phillips - Thursday, June 4, 2020 1:41 PM -
0 Votes
INSTR Function in MDX
You are missing a comma before the @NQSupplierAPSupplier parameter in the InStr call http://darren.gosbell.com - please mark correct answersAnswered | 1 Replies | 9055 Views | Created by Tarakq - Monday, May 9, 2011 5:25 PM | Last reply by Darren Gosbell - Tuesday, May 10, 2011 5:05 AM -
0 Votes
instr function work in a 64 bit machine?
Instr() was internally implemented in Analysis Services code base with AS 2005 SP2, according to the document below.Answered | 2 Replies | 3955 Views | Created by JoseMinistro - Wednesday, May 20, 2009 2:15 PM | Last reply by JoseMinistro - Thursday, May 21, 2009 1:03 PM -
1 Votes
Report Expressions: SWITCH, InStr and LCase
I have InStr function that seems not to match when numbers are at the beginning of the search string.Answered | 2 Replies | 949 Views | Created by blair_v - Friday, October 14, 2016 11:02 PM | Last reply by Visakh16 - Monday, October 17, 2016 6:14 AM -
0 Votes
Need clarification on MDX-- VBA function INSTR()
In this scenario, what INSTR returns is a value, we can only include those numeric or string expression within calculated member.Answered | 3 Replies | 1117 Views | Created by Mahesh Alam - Tuesday, November 3, 2015 12:29 AM | Last reply by Simon_Hou - Tuesday, November 3, 2015 11:07 AM -
0 Votes
InStr function not matching text
0 Then Hi Albert, I think you gety better results if you change the first parameter from 'i' to ...Answered | 2 Replies | 634 Views | Created by Albert S - Saturday, May 4, 2019 6:44 PM | Last reply by Albert S - Saturday, May 4, 2019 8:16 PM -
4 Votes
InStr methods
Use it like: Dim DNValues() As Integer = ExtractNumbers(TextBox1.Text) and if the array has more than one element choose the one you want.Answered | 15 Replies | 784 Views | Created by Nicolas Michelet - Friday, August 26, 2016 2:02 PM | Last reply by Nicolas Michelet - Monday, August 29, 2016 11:01 AM -
0 Votes
Need Function to compare two columns for matching SUBSTRING values
0 If InStr(s, freqm & CStr(q)) > 0 Then If qAnswered | 2 Replies | 990 Views | Created by TheBrenda - Friday, July 24, 2015 2:39 PM | Last reply by TheBrenda - Saturday, July 25, 2015 6:39 PM -
0 Votes
Access functions to match two address text field
Does anyone know fuzzy match scoring?Answered | 7 Replies | 1399 Views | Created by Miloann - Wednesday, September 9, 2015 1:26 AM | Last reply by Dirk Goldgar - Wednesday, September 9, 2015 3:30 PM -
0 Votes
C# of instr
Just be aware that InStr returns a 1-based result while IndexOf returns a 0-based result.Answered | 3 Replies | 14973 Views | Created by Can-Ann - Wednesday, April 4, 2007 4:01 PM | Last reply by Dave Doknjas - Thursday, April 5, 2007 12:40 AM -
0 Votes
InStr Error...Please help...
VB.NET is a completely different language and totally object oriented, which produce the SAME sequence of IL instructions as C# does (I've done many tests about this).Answered | 49 Replies | 4958 Views | Created by Baby Bench - Sunday, October 24, 2010 3:50 AM | Last reply by Renee Culver - Wednesday, November 10, 2010 1:20 AM -
0 Votes
t-sql equivalent to substring from the right/instring?
Have a look at CHARINDEX, this is basically the T-SQL versino of InString.Answered | 3 Replies | 6258 Views | Created by CoderDonna - Monday, May 10, 2010 7:19 PM | Last reply by Gert-Jan Strik - Monday, May 10, 2010 9:50 PM -
2 Votes
IIF with InStr and LEFT -1 Causes #Error in SSRS 2008R2
I found another work-around for using IIF with InStr and Left functions.Answered | 4 Replies | 6440 Views | Created by SomeDBGuyOutThere - Tuesday, March 17, 2015 2:25 PM | Last reply by mindy g - Wednesday, February 12, 2020 5:24 PM -
1 Votes
match subject line text with attachment file name
You can use the InStr function, take a look at the following forum threads for the sample code: Check if a string contains another stringAnswered | 1 Replies | 645 Views | Created by toppanam - Wednesday, March 9, 2016 2:22 AM | Last reply by Eugene Astafiev - Wednesday, March 9, 2016 7:24 AM -
0 Votes
InStr not working as I had expected
InStr returns the position where String2 was found in String1, or 0 if not found.Answered | 2 Replies | 4797 Views | Created by mbrad - Wednesday, January 18, 2012 3:30 PM | Last reply by mbrad - Wednesday, January 18, 2012 4:26 PM -
0 Votes
Using the MATCH function in Excel VBA
that error just means that a match wasn't found.Answered | 1 Replies | 79469 Views | Created by Norm Bullen - Wednesday, November 28, 2012 9:52 PM | Last reply by bnasu3 - Wednesday, November 28, 2012 10:10 PM -
0 Votes
How to match "TOP" vs "Top"
How are you searching (a prebuild function/API)?Answered | 8 Replies | 824 Views | Created by bthumber - Tuesday, March 8, 2016 11:17 AM | Last reply by Noam B - Wednesday, March 9, 2016 11:34 AM - Items 1 to 20 of 1486718 Next ›
No announcements
