No announcements
Found 2887508 threads
-
0 VotesUsing the INSTR function
Although the Instr function should do it job, is it a little bit antique in use. In most program languages the first item is 0 and not 1 ...Answered | 11 Replies | 941 Views | Created by Les2011 - Wednesday, November 29, 2017 1:17 PM | Last reply by Les2011 - Thursday, November 30, 2017 1:58 PM
-
0 Votes
Extracting First Name - conditioned on if Middle Initial Exists - Using Instr and InstrRev functions
initials and some don't. This is why I'm trying to do an IIF function so that when the difference between the InStrRev and InStr values is less than zero I ...Answered | 2 Replies | 3784 Views | Created by Patrick Briggs - Wednesday, June 10, 2009 12:48 AM | Last reply by Patrick Briggs - Wednesday, June 10, 2009 9:41 PM -
0 Votes
DTS (active X issue)
for each I am using the InStr function to determine if the partial file name is in the directory since the filename can change daily and ... -
0 Votes
VBA - InStr Function Not Finding Substring
;|" symbol. I sort the data using this key and compare the data using VLookup (with 4th parameter True). Then, I use InStr to see if the book ...Unanswered | 2 Replies | 3282 Views | Created by JPJax - Friday, August 31, 2012 7:05 PM | Last reply by evohnave - Tuesday, September 4, 2012 1:42 PM -
1 Votes
Trouble using regex in a instr function
Hi MB, Thanks for this info. Is there a way of using regex capabilities in an INSTR function?? Can't seem to find the ...Answered | 9 Replies | 4234 Views | Created by Les2011 - Saturday, October 12, 2013 1:51 AM | Last reply by Acamar - Saturday, October 12, 2013 6:12 AM -
7 Votes
Instr Function
I'm using the Instr function in VB.net what I would like to know is there a way to use it with place holders or wild chars... example what I'm ...Answered | 7 Replies | 3125 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
instr function work in a 64 bit machine?
Hello, I'm using SSRS 2005 32 bit version to made some reports that have Analysis server as DataSource. In that Reports i use INSTR ...Answered | 2 Replies | 3577 Views | Created by JoseMinistro - Wednesday, May 20, 2009 2:15 PM | Last reply by JoseMinistro - Thursday, May 21, 2009 1:03 PM -
0 Votes
InStr function not matching text
Hello, I have a function using InStr that is not matching text correctly. I am trying to remove characters that can't be used in a ...Answered | 2 Replies | 410 Views | Created by Albert S - Saturday, May 4, 2019 6:44 PM | Last reply by Albert S - Saturday, May 4, 2019 8:16 PM -
0 Votes
ASP - Instr Function and Find Exact String
Hello , I have my website in ASP. I am using Instr function that find given string in other string. I have problem that my string say ...Answered | 1 Replies | 11557 Views | Created by Go .Net - Saturday, May 31, 2008 8:40 AM | Last reply by Anthony Jones - Sunday, June 1, 2008 10:07 PM -
0 Votes
Function works in MS Project Pro 2010, but not in MS Project Server 2010
I have an custom enterprise text field in Project Server 2010 that uses the "Instr" function and it works fine. I created a local custom text field in ...Unanswered | 1 Replies | 1353 Views | Created by DKLJoe - Friday, July 18, 2014 9:08 PM | Last reply by Alexander Rodov, PMP, MCTS, CSM - Friday, August 8, 2014 5:36 PM -
0 Votes
Unexpected behaviour with INSTR function
Also, you're still using the VB6 functions like Instr and Mid. Do a search for the system.string type in your Object Browser (press F2): you'll see a whole bunch of ...Answered | 2 Replies | 3460 Views | Created by Dreaded Eddie - Sunday, January 21, 2007 7:48 PM | Last reply by nogChoco - Sunday, January 21, 2007 8:52 PM -
0 Votes
VBA - InStr Function Not Finding Substring
> If InStr(1Proposed | 6 Replies | 7373 Views | Created by JPJax - Friday, August 31, 2012 7:19 PM | Last reply by Ron Rosenfeld - Tuesday, September 4, 2012 2:02 PM -
0 Votes
Find Function in VBA
Instr function simply returns zero. The next thing is an explanation of using the Instr function in conjunction ...Answered | 3 Replies | 839 Views | Created by foxguy - Saturday, February 7, 2015 7:31 PM | Last reply by foxguy - Monday, February 9, 2015 6:27 AM -
1 Votes
Mid Function
What about using the InStr() function to return the first blank ...Answered | 3 Replies | 2427 Views | Created by scorpdevil - Thursday, August 11, 2011 2:44 PM | Last reply by danishani - Thursday, August 11, 2011 3:20 PM -
0 Votes
InStr function
I have been trying to rack my brain on why the InStr function works with a text box in access but not in a rich text box. Below is the code I'm trying to work ...Unanswered | 1 Replies | 679 Views | Created by yooper59 - Friday, May 10, 2019 2:31 AM | Last reply by Alex-KSGZ - Friday, May 10, 2019 5:17 AM -
1 Votes
InStr function
Inst Returns an integer specifying the start position of the first occurrence of one string within another. If you are ...Answered | 4 Replies | 1776 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 -
1 Votes
How to use InStr function in Dataset.DefaultView.RowFilter
own syntax, which is "similar to" SQL, but different in many ways. Obviously, InStr is not a valid operator of DataColumn.Expression but an Oracle ...Answered | 4 Replies | 13545 Views | Created by Beppe71 - Friday, January 14, 2011 3:29 PM | Last reply by Beppe71 - Wednesday, January 19, 2011 4:34 PM -
0 Votes
Right, Len, and InStr functions
I like the function below from MSDN and tried then using it to get the LEFT side and couldn't. Any help with an explanation would be ...Answered | 2 Replies | 7270 Views | Created by Merrik - Friday, October 5, 2012 6:22 PM | Last reply by Mike Yin - Sunday, October 7, 2012 4:13 PM -
0 Votes
LIKE keyword in MDX
= 1)) (If you are using AS2kAnswered | 2 Replies | 7178 Views | Created by Hendrik Gunawan - Friday, October 26, 2007 2:15 AM | Last reply by Hendrik Gunawan - Sunday, October 28, 2007 11:28 AM -
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 | 8720 Views | Created by Tarakq - Monday, May 9, 2011 5:25 PM | Last reply by Darren Gosbell - Tuesday, May 10, 2011 5:05 AM - Items 1 to 20 of 2887508 Next ›
No announcements
