Stack Overflow
Stack Overflow

Questions tagged [instr]

89 questions
0
votes
1 answer

How to get only 3 string after @ from @get.com or @getting.com in VBA

How to get only 3 string after @ from @get.com or @getting.com in VBA for example i have to achieve @get from provided string @get.com or @getting.com
Omkar
  • 1
0
votes
1 answer

how to parse first and second occurrence of number between two strings

can you help me with parse of numbers from string? I want select first and second occurrence of number from string that look like : PKGGeneral.SetObjectAttribute(i_DimObject=4,i_ObjectID=163225122,i_Attribute=NAME,i_Value…
matooo81
  • 11
0
votes
2 answers

Right instr formula in Crystal Reports is causing label to not print

I am trying to have text in a field print but only if it is after "~" with the following formula: right({ShipLabel.view_Part_Description},instr(strreverse({ShipLabel.view_Part_Description}),"~")-1) This is working perfectly when a "~" is present but…
Jessica Danielson
  • 1
0
votes
2 answers

Instr in vba not working with a formula cell

I have a cell (example L22) with has a formula (which refers to another sheet (Sheet!1A22) and returns a value sale 110 (108%). I wanted to change the text color of (108%) only (and not the entire cell value). My approach was to use Instr to find…
Arun kumar Nair
  • 1
0
votes
0 answers

How to use INSTR in HIVE?

I have a code, which is working on ORACLE, I was looking to migrate the same in Hive. Recently I realized that in Hive, INSTR function takes only TWO arguments. So that's an issue for me. Not able to figure out the way around, Kindly help! Code in…
sareen
  • 19
  • 4
0
votes
0 answers

Highlight matching strings, found in in a form-field text box, either from a table or static array (using MS Access)

I have an Access tool/database with external database (ODBC) connections. It's purpose is to review call logs for issues and the user will decide the severity based on the contents of a message. I have an idea, to assist the review, using VBA. I…
Mark L
  • 1
0
votes
2 answers

Joining tables in mySQL using INSTR()

I have 2 tables to connect without matching id, as shown below; table_a id name 1 moe 2 joe 3 bob 4 sue table_b id accessid 10 moe99 11 joe53 12 bob51 13 312sue i tried to connect/join these 2 table using INSTR().…
sqln00b
  • 1
0
votes
1 answer

Using InStr in Access VBA to lookup a string value from another table

Very new to access VBA and would love some guidance on this. I am searching through a string and looking for a particular substring in this field. This substring would have a value based on another table, ie order = "Reference order QQ131415" The…
DamnGroundHog
  • 57
  • 1
  • 8
0
votes
1 answer

Formula picking up almost all values

I am retrieving the following values but it is not consistent. I need the values after the GESTATIONAL AGE:. Sometimes it picks up after sometimes it does not. The following are the values being returned. Sometimes it contains Gestational Age,…
sharona
  • 1
  • 1
  • 1
  • 3
0
votes
1 answer

Finding first non-alpha character

I need to look at a string, and find the first non-alphanumeric character in it, and truncate everything from that non-alphabetic character until the end of the string. I know REGEXP_INSTR probably is involved, but cannot figure it out. Can anyone…
Landon Statis
  • 683
  • 2
  • 10
  • 25
0
votes
1 answer

Can InStr be used to find multiple String1 values?

I'm manipulating some data, by searching through a list and and printing out the row numbers of the cells that match the criteria I'm looking for. I'm using InStr to do this - can this be used to search for multiple items? I've tried "Or", "And" etc…
user2819098
  • 13
  • 3
0
votes
3 answers

vba program to extract word between two special caracters from cells value

I have an .xlsm doc that contains hundreds of rows, and I want to set the value of C column based on B column. For example : B1 contains " + New node '145872-12547-4885' created " My purpose is to extract using a macro that loop all rows just the…
MaNaR
  • 47
  • 6
-1
votes
1 answer

SQL Substring function usage

This the column Description Entity=10||WorkdayReferenceID=9000100332||HCMCostCenterMgr=nicoleb@broadinstitute.org||FRP=|| I want to retrieve the emailid only in the above scenario the desired output would be nicoleb@broadinstitute.org I tried…
varun dixit
  • 11
  • 1
-1
votes
3 answers

How do I dynamically extract substring from string?

I’m trying to dynamically extract a substring from a very long URL. For example, I may have the following URLs: https://www.google.com/ABCDEF Version=“0.0.00.0” GHIJK https://www.google.com/ABCDEFGH Version=“0.0.0.0”…
Crimp
  • 389
  • 1
  • 22
1 2 3 4 5
6