Stack Overflow
Stack Overflow

Questions tagged [instr]

89 questions
0
votes
0 answers

CATIA VBA InStr function having problems. How to solve it?

Im trying to generate an Excel BOM data base without using CATIA. For this porpouse I did an Excel subroutine that reads a CATPart file as a txt file. This way I can manage to get the parameters inside the CATPart file using a simple InStr…
Seba Sain
  • 1
  • 3
0
votes
2 answers

vba doing something I dont want it to do, using if else

I have this piece of code that analyses the values on Column J [Valor]. If the code is negative, it checks the Column K [Descrição] if there is a specific Array of text. If the text exists, it does a few changes, if not, a few other changes. But,…
Afonso Medeiros
  • 67
  • 1
  • 10
0
votes
1 answer

Instr function only on specific font

I´m trying to find a way to use Instr to work only with words that have a specific font. I´m currently using a code that allows me to find differences between two paragraphs and show the changes on another column by chainging the words that are the…
rafael rivera
  • 41
  • 4
0
votes
0 answers

VBA finding substring in string

I am looking to make a macro to find if a patient has certain complications . For example list of conditions patient A has: "Urinary calculus, unspecified; Unspecified joint derangement; Fibrosis and cirrhosis of liver; Liver cell carcinoma", and I…
Shawn Alcantara
  • 31
  • 2
0
votes
1 answer

How get some parts of a main text (EXCEL VBA)

I have a text that is segregated with "/" and I need to get some parts of it. Operator is my variable that gets the main text from the system. The text is segregated with "/", so for example I need to get the text between the 2nd and 3rd "/". Ex1:…
Denis Dos Santos
  • 1
  • 1
0
votes
1 answer

Oracle SQL - how to split up a string into parts but not break up words

I need to split a long description into 4 parts of up to 60 characters each, but I need each part to end with a space (not break up any words). What is the best method to do this? Below is the snippet of the code, however I need it to not break up…
Amy
  • 1
0
votes
1 answer

Updated Question-Oracle case statement to extract value for all occurance associated with a substring in a single line

I want to write a case statement which can extract value for a particular substring from a column named details which has multiple occurrences for [address] is it possible with REGEX along with case? sample Data in the column: [address]:kattengat…
Linnea
  • 65
  • 1
  • 6
0
votes
1 answer

SQLite Studio Question for Substr making some of my values disappear?

I'm working with a free dataset from Kaggle to learn SQL further and I've hit a spot where I am stuck. I'm working with an NFL Draft dataset that has player names listed like this: FirstName LastName\UserName However, some of the rows are simply…
Joe
  • 1
  • 3
0
votes
0 answers

How to concatenate a Select query inside a INSTR() in SQLite?

I was trying to order a result set by the order of the values in an IN() clause. SELECT * FROM CrossReference WHERE cross_reference_id IN (SELECT Id FROM FilteredIds) So I tried to find a function such as MySql FIELD(). Then I found these answers…
Kamal Thennakoon
  • 1,439
  • 1
  • 7
  • 8
0
votes
1 answer

Subject not being replaced by VBA Macro

Okay so, I'm trying to edit this code I found that allows me to input variable information into a pop up box for emails. This is great and works flawlessly (although kinda slow), however I'm running into a weird issue trying to do the same thing…
alxd133
  • 1
0
votes
2 answers

VBA: Getting value/string between/in square brackets

so I have found a great answer on here showing how to get the values or strings between brackets (Get the value between the brackets) The code works perfectly, but when square brackets are involved, as in the following code, it gives me an error…
Bilal Abdou-Karim
  • 11
  • 2
0
votes
0 answers

Extract text string from another cell formula problem

I’m currently trying to include a VBA code into a larger Macro however one particular line (in Part B) is throwing out an error with the FIND function. The objective of the code is to insert two formulas into two diiferrent cells that extract text…
ETMB
  • 1
0
votes
2 answers

Use a conditional "instr" function in Excel VBA to NOT add an item to a list

I am trying to populate a list box with the open files. The whole procedure will export the selected sheets from the existing file to another workbook and save it with a date time stamp appended into the same directory. It builds this export name…
Terry McC
  • 13
  • 3
0
votes
2 answers

Why can't I find "read&tn=" in a String?

Dim urlString As String Dim posn As Integer urlString = WebBrowser1.Url.ToString If urlString = "https://bookscan.cojc.org/bookscan/scan/trackingForm?read" Then ... works But when I try to find "read&tn=" and I know that the full…
JerrMerr
  • 11
  • 4
0
votes
0 answers

InStr is not finding the substring/Is it searching the whole string?

InStr code and value. We are looking for "M" in StndMCardIndic. StndMCardIndic is "S(16B,17B)|M(18B)|IO(19B)". As you can see I am searching StndMCardIndic for the character "M". The value of StndMCardIndic is "S(16B,17B)|M(18B)|IO(19B)". A "M" is…
DanielWhite92
  • 1
1 2 3
4
5 6