All Questions
660
questions
0
votes
0
answers
12
views
Find string in data
I am reading out an API interface to get an average price of a specific material.
The response of the API gives me a database including several different materials with a min and high price.
First I ...
-1
votes
3
answers
111
views
Multiple substrings in string python within variable check [duplicate]
I have the following code:
check = "red" in string_to_explore
How can I replicate it for multiple substrings?
I tried with:
check = "red|blue" in string_to_explore
but doesn't ...
0
votes
1
answer
33
views
VBA function FindInRow not always work - Find a cell in an excel row containing either text or date
Sometimes my VBA function FindInRow works, sometimes it doesn’t.
The VBA function FindInRow is used to find if a 'text' exists in an Excel row or not. If the text is found in the row, the function ...
0
votes
0
answers
27
views
generate a graph between 15k+ strings of recipe ingredients
you know real world data is messy, and i have an interesting problem that i cannot find the solution to or cannot find the right keywords to search.
so i have about 15k+ recipe ingredients written in ...
0
votes
1
answer
115
views
SharePoint Calculated Column to get the First letter after a dash
I am trying to get the first character after an underscore "_"
So I can create a view based on that first charter, for instance 12345_Name (Title field) and then my calculated field would ...
0
votes
1
answer
24
views
Batch - How to find strings from the first file in the second file and print which strings from the first file don't exist in the second one?
I have the first text file, example:
amet
sint
perspiciatis
minima
And I have the second file full of text, example:
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor ...
0
votes
1
answer
62
views
Big Query: Find number of characters in a column which are contained in a list
For each row in the example string-formatted column below,
Response
A
A, B
A, C
B, C
A, C, D
A, B, E
I want to find the number of characters which are contained in the list (A, C, E).
I ...
-3
votes
5
answers
317
views
how can I find the position of the last LETTER in a string in python?
I want to include a function in my code that can return the position in the string that the last letter in the string can be found.
e.g: if the input were " hello world k ...^&", the ...
0
votes
1
answer
58
views
Python Pandas: Confirm if a substring of DataFrame A is part of a string in DataFrame B
I have two dataframes:
import pandas as pd
countries_list_a = pd.DataFrame({'Country' : ['Australia', 'United Kingdom', 'United States'], 'Code' : ['A', 'B', 'C']})
countries_list_b = pd.DataFrame ({...
0
votes
2
answers
73
views
Unexpected results from Pyhton find() function
I have this string
string = "DLR1=A,B,C,D,E,F,G|DLR2=A,B,C,D,E,F,G|DLR=A,B,C,D,E,F,G|"
And I want to find the indexes of DLR, DLR1 and DLR2.
However, when I use the Python find() function I ...
0
votes
1
answer
39
views
Issue with python's string find method returning -1
I'm trying to write a function that takes a string and returns the token positions. The function works fine when tokens = query_string.split() but if I try to use the string lower method, as shown in ...
1
vote
1
answer
692
views
Find and change multiple strings in the entire registry using powershell commands
I'm trying to make a script to change values in the entire registry in all keys and subkeys for a string called "Value" and make it 0. So whenever string "Value" is found, it's ...
0
votes
3
answers
55
views
Removing a File Extention from a String in Python (Reverse Indexing)
In a recent project I had to remove the '.txt' extention in a string. I tried using the .find() function as well as .index() and .search() in many ways but nothing came out of it. So, I wrote the ...
0
votes
1
answer
54
views
Is there a function to replace matched string with another column's value?
Im trying to replace a matched string only - and nothing else within the column, with another value.
For example:
My name is GaryBrooks.
The Partnertime series was good.
Match:
GaryBrooks
Partner ...
0
votes
0
answers
71
views
Count cells in a range that contain a value that exists in another string in Excel
I want to be able to count the number of records that contain a value that is contained within a string in another cell in Excel.
For example:
My range contains the values red; green; yellow;
String =...