Stack Overflow
Stack Overflow

Questions tagged [instr]

89 questions
0
votes
0 answers

How to find number in a cell

Could you please help me to solve this issue with a vba code? this is my data What I want to do is to create a vba code that search the value from column B in Column C if the value is found or not found then in column A add a comment the issue is…
Carlos Martinez
  • 1
0
votes
2 answers

Saving attachments with specified text found in file name

I receive e-mails, from two vendors, that have two types of attachments, with extension of xml and pdf. XML can contain data of three types, which is reflected in the name of the XML file. The types of XML let's say can be: "IE529", "IE599",…
DamianD
  • 43
  • 5
0
votes
2 answers

VBA tag rows if a cell consists of at least one of some provided strings

I try to get my finances together and for that downloaded my data from the local bank as excel. As it is pretty wild (and some years), I want display the data summed up for what I use my money for, as "food", "rent" and stuff. For that I want to go…
Martin Herzuba
  • 87
  • 1
  • 7
0
votes
1 answer

Oracle INSTR vs Hive INSTR

I have Oracle-query and need to use the same in Hive. select INSTR('some string', 's', 1, 1) - INSTR('some string', 's', 1, 2); >> -5 but Hive doesn't have INSTR like Oracle. I can use only this one: select INSTR('some string', 's'); >> 1 and it…
Yurka
  • 21
  • 5
0
votes
0 answers

INSTR command in Doctrine querybuilder

I am currently working with php and using doctrine. I have this query that I want to rewrite by using the querybuilder so I can make use of it in my graphql command. It selects a string field that is compared with a like statement. All fine and good…
Totumus Maximus
  • 7,543
  • 6
  • 45
  • 69
0
votes
2 answers

How to strip a string to get the exact expected output regardless of how the string is formatted in Oracle 11g

I have a set of strings on which I am performing some operations to retrieve only the part of the string that I want for further operations. I have used various substr, instr, regexp_replace etc and achieved for some of the strings in a huge list. I…
venkatcg0
  • 1
  • 2
0
votes
0 answers

how to find a pattern which is repeated n number of times in a column of a table in informatica

i have a scenario in which a field, of a particular record, in my table looks like below (array format) The set of id, email and address can be repeated n number of times for each record. So i need to set up a mapping in informatica where it will…
Anish Biswas
  • 1
0
votes
1 answer

PL/SQL - ORACLE APEX: Why does the INSTR function not return anything for the query when given a Page Item as input?

I'm currently struggling to get the following query to work: UPDATE HT_USERS SET HT_USERS.ZONE = 1 WHERE INSTR(:P8_MEM, USER_ID) > 0; where :P8_MEM is a page item in the apex environment. The page item is a check box group which contains the…
emilyantosch
  • 1
0
votes
1 answer

How to match 3rd repeated keyword in json string with my keyword in oracle sql?

I'm able to match the first repeated keyword in json string using INSTR(json_string,'keyword') but trying to figure out how to match 3rd repeated keyword occuring in that json document? Appreciate if someone can give me a clue here? Thanks, N
Naseer
  • 127
  • 10
0
votes
1 answer

Converting function instr from Oracle to PostgreSQL (sql only)

I am working on converting something from Oracle to PostgreSQL. In the Oracle file there is a function: instr(string,substring,starting point,nth location) Example: instr(text, '$', 1, 3) In PostgreSQL this does not exist, so I looked up an…
Luice712
  • 3
  • 2
0
votes
0 answers

Excel VBA Validation

Hi I am new to Excel to VBA and I am wondering if anyone could explain what this code means? If InStr(posA, cityB) > 0 And Len(cityB) > 0 _ And InStr(cityB, "(") > 0 And StrComp(Right(cityB, 1), ")", vbTextCompare) = 0 Thank you! Was…
donkey shrek
  • 13
  • 4
0
votes
2 answers

Oracle INSTR replacement in MySQL

Requirements: Before, I used instr() in Oracle to achieve the requirements, but now I want to use MySQL to achieve the same effect, and try to use the functions in MySQL to achieve it. INSTR(A.SOME_THING.B,".",1,2)<>0 --ORACLE
lkxk
  • 1
0
votes
3 answers

Oracle SQL, getting string value between 2 points

I need to select a string value between two dots. (dots include) Given abc.musadeneme.dce I need .musadeneme. I need your help, thanks.
Musa Keskin
  • 15
  • 4
0
votes
0 answers

Array value is not working correctly for InStr statement

So I have created multiple arrays that include various info (states, names, etc). Using these arrays, I need to check to see if the values match to a fixed spreadsheet. So doing so for the names array I do within a loop: If InStr(Worksheets("Import…
Fernando Toledo
  • 1
  • 1
0
votes
2 answers

Select substring in Oracle SQL up to a specific character

Let's consider the following example. Say I have a table column called N.Note and it contains the string: Veg: Lettuce 200 ¶ Fruit: Oranges 200 ¶ Dairy: Milk 300 ¶ This string is not constant and always changes positions. I would like select…
python
  • 1
1 2
3
4 5 6