207 questions
3
votes
0
answers
88
views
How to text-search in PostgreSQL when using RLS?
Over the past week, I’ve been working on implementing text search in a NestJS application using PostgreSQL. The challenge is that the app supports multiple tenants, all sharing the same tables, so we ...
0
votes
1
answer
56
views
vim/gvim multi/consecutive line value/pattern highlighter
Log:
smac integral 48 'hab12
dmac integral 48 'hcd34
len integral 32 32
...1000 lines...
smac integral 48 'hblah
dmac integral 48 'hblah
len integral ...
0
votes
3
answers
96
views
Pull specific data from text files in PowerShell with search parameters
We are trying to Pull AP name, bss, and ess values out of text files provided by a network team, in PowerShell 5.1. We have numerous files to go through and multiple AP Targets in each file.
Here's ...
0
votes
0
answers
30
views
Extracting and Joining Variable-Length Account Numbers from Unstructured Strings using Snowflake
Problem:
I have two tables in Snowflake: a dimension table with account information and a fact table where the account numbers are embedded as part of a string in a PARAM_VALUE column of type string. ...
- 301
0
votes
1
answer
59
views
Powershell text search won't find strings with spaces
I have aproblem with this Powershell snippet. The problem is that when @search_string is one single string, it finds it in the file, BUT when @search_string contains as space, it doesn't find it. e.g....
- 519
1
vote
0
answers
109
views
Restrict Electron webContents.findInPage() search to specific page element(s)
Using Electron's webContents module and its findInPage() method, one can search the entire page for a text pattern. However, when implementing this with a modal Find window, the search pattern entered ...
- 683
1
vote
2
answers
972
views
Mongo Atlas combine $search with match
I'm searching through a collection either by hard data (numbers, other values) with $match and operaters like $regex, $in, $eq, $size, $gte, etc.
{'$match': {'$and': [{'isbn': {'$exists': 1}}, {'form':...
- 178
1
vote
0
answers
1k
views
Isar: Is there a way to do a text search on the items of an IsarLinks object using indexes?
I have a collection of Bars, each of which have isar links to Foos:
@collection
class Bar{
Id? id;
final foos = IsarLinks<Foo>();
... // Bar stuff
};
Each Foo object has a field named ...
- 554
2
votes
1
answer
110
views
How to do full field match in Solr?
I want Solr to return a document only if all the tokens are present in the query. For example if a document have a text of "foo bar", then it will only be retrieved with a query like "...
- 119
2
votes
3
answers
841
views
How to use Puppeteer to count the occurrences of a specific text on a web page?
I am working with NodeJS and the Puppeteer library to load a website and then check if a certain text is displayed on the page. I would like to count the number of occurrences of this specific text. ...
- 9,923
0
votes
1
answer
581
views
Excel - FIND function (case-sensitive) ignores case?
Does anybody happen to know why the FIND function isn't case-sensitive here:
I used conditional formatting on my table with =OR(ISNUMBER(FIND($B$1:$B$13,A1))).
And the word "Rektor" in ...
- 13
1
vote
2
answers
345
views
Databases: Effectively implement string contains query
I need a way to effectively do a string contains query like:
# In SQL
LIKE '%some-string%'
# In mongo
{ $regex: /some-string/ }
But its very slow when the dataset size is big. Eg. I tried in a dummy ...
- 89.1k
0
votes
2
answers
442
views
How to sort and search in text while ignoring diacritics of all kinds?
Background
Various languages have what's called "Diacritics" . Special signs that come with "normal" letters, one way or another. They might change how the letters sound, or just ...
- 117k
0
votes
1
answer
171
views
Text match and search on Mysql table column
I have a Mysql table with couple of columns, one column contains search_text VARCHAR.
The table is recording data with high frequency and contains millions of records.
I want to search a group of ...
- 11
0
votes
2
answers
376
views
Partial text search in mongoDB
I want to write a query to make the search operations on partial words but not getting any kind of solution other than Atlas Search. I have one solution to use regex but by using regex query is taking ...
- 161
0
votes
1
answer
101
views
Substring search with a (regex?) condition Python
I have a situation where I want to search if a substring exists in a large text. So, I was simply using:
if pattern in text: ...
But, I want to ensure that the existence of "pattern" in &...
- 5,315
2
votes
2
answers
1k
views
How to create search bar for name search json javascript using filter
I am creating website of student community.
Having difficulty in adding Search Bar option to website.
I can add normal for search but had bug for all together.
How should I add name search here?
...
- 155
0
votes
1
answer
13k
views
Text.Contains for multiple values power query
I am attempting to create the following query:
The idea is to check if each row in the source query contains any of the following keywords in the Search list and return the Found words is present.
...
- 927
0
votes
1
answer
605
views
Text search in aggregation using pymongo
I have a collection named users, it has following attributes
{
“_id”: “937a04d3f516443e87abe8308a1fe83e”,
“username”: “andy”,
“full_name”: “andy white”,
“image” : “https://example.com/xyz.jpg”,
… etc
}...
- 29
0
votes
1
answer
381
views
Search for closest correct word in PostgreSQL full text search
I have a search functionality in my application done with https://www.postgresql.org/docs/current/textsearch.html.
I want to add the correction of spelling mistakes, in the fashion of "Did you ...
- 1,540
0
votes
1
answer
42
views
I'm having trouble with a simple search form with javascript
I know what I'm stuck with is simple.
My example is here: https://www.w3schools.com/howto/tryit.asp?filename=tryhow_js_filter_list
I want to do the opposite. Nothing appears at first. They start ...
0
votes
0
answers
594
views
PostgreSQL- Full Text Search limitations (~, ~*, LIKE)
Hi there! I've been asked to explain some limitations that could have the operators (~, ~*, LIKE) when doing Full text limitation.
I've seen some things but nothing really relevant.
Could someone ...
3
votes
1
answer
901
views
What is the GitHub search syntax for mandatory search terms?
What is the syntax for specifying that words must appear in the results of a GitHub search? - Similar to using the double quotes around words in a Google search.
- 16.3k
0
votes
1
answer
438
views
Google text search API returns results located in USA
I'm using Google's text search with location bias by including geoPoints in URL but for some reason, 3 results out of 60 are of USA while the geoPoints I provide are in India.
I want all the results ...
1
vote
1
answer
287
views
searching for a phrase in Mongodb: weird behaviour
i have the following collection:
books> db.books.find()
[
{
_id: ObjectId("61ab85b0056b5357b5e23e6b"),
fields: 'hello good morning'
},
{ _id: ObjectId("...
- 555
1
vote
2
answers
53
views
Extracting all Number/Letter Code (C2, H3, W1 etc) from a text cell in Excel
I have an Excel list with course names and their number like this:
V3 Varikosis Masterclass
B3 Botulinumtoxin Premiumkurs, H2
M1 Mykologie Basiskurs [Digital], D1 Dermatoskopie Basiskurs [Digital]
...
- 11
0
votes
0
answers
98
views
Performance when using phrases in MongoDB text search
I observe worse performance than I expected when using phrases in MongoDB's text search.
Given the following MongoDB text index that contains next to other data phone numbers stored in international E....
- 5,649
0
votes
0
answers
19
views
Advice on which PostgreSQL indexes to use to search for text?
I have some tables in scheme of PostgreSQL. I need to find text in some tables at the same time. I need find the same phrases in different tables and also different phrases in different tables. In the ...
- 1
-1
votes
1
answer
47
views
How do I locate the same string of text across different revisions of the same text (an ebook)?
I have a string of text highlighted in an ebook. This ebook has new, revised versions coming out every couple of years. I want to programatically re-locate this highlight across all these updated ...
- 2,854
0
votes
1
answer
261
views
Search And Replace With Regex with header and tail
I'm new to regex and I want to search and replace every occurrence of a "variable".mean() with average("variable")
m863991.mean() to average(m463641) or
m863992.mean() to average(...
- 39
3
votes
1
answer
714
views
Tackling MongoDB single text index limit
I have a collection of around 200m documents. I need to build a search for it that looks for substrings. Using a regex search is incredibly slow even with a regular index on the field being searched ...
- 15.1k
0
votes
0
answers
220
views
How to do quickly search with multiple string in postgreSQL in case of very large database?
I try to build a data search system with around 9 million data for my supershop project.
So I need to search with multiple strings like product code, name, type etc. But when I search it took too ...
0
votes
0
answers
383
views
Weighted text search with MongoDB
I have a MongoDB Atlas cluster that I reach from a node.js server.
I implemented a text search where I take an input from the user, let's say "rainbow", and create a string like that: "...
- 1,661
0
votes
1
answer
153
views
Best practices - Big data with mysql
I have a video surveillance project running on a cloud infrastructure and using MySQL database.
We are now integrating some artificial intelligence into our project including face recognition, plate ...
- 555
0
votes
1
answer
2k
views
Postgresql, tsquery doesn't work with part of string
I'm using postgres' tsquery function to search in a field that might contain letters in multiple languages and numbers.
it seems that in every case the search works up to a part of the searched phrase ...
- 267
0
votes
1
answer
285
views
What is the shortcut to search for a text inside all project files in Android Studio?
I need to find a text occurrence inside all files and classes in Android Studio. I am unable to achieve it with the double Shift or Ctrl+Shift+F. Is there any shortcut key for that?
- 4,482
4
votes
1
answer
2k
views
How to create an index for partial text search on MongoDB?
I'm following the tutorial instruction: https://docs.mongodb.com/manual/core/index-text/
This is the sample data:
db.stores.insert(
[
{ _id: 1, name: "Java Hut", description: "...
- 1,277
0
votes
0
answers
146
views
How to implement an algorithm to search Lucene Index for Equities?
The Security Lookup user control was implemented in C# using the Lucene.Net assembly to search securities while reading Lucene Index which stored US and Global equities.
Security Lookup is a User ...
- 327
0
votes
2
answers
302
views
Can Cypher do phonetic text search with only a part of the text, without using elastic search?
Say I have a job as financial administrator (j:Job {name: 'financial administrator'}).
Many people use different titles for a 'financial administrator'. Therefore, I want abovementioned job as a hit, ...
- 19
0
votes
1
answer
571
views
MongoDB indexed text search only works for exact match
I have field 'user_name' populated with data.
This code gives me no results:
history = db.history
history.create_index([('user_name', 'text')])
history.find({'$text' : {'$search' : 'a'}})
But when I ...
0
votes
0
answers
133
views
Score of MongoDB text search is indifferent to the order of found tokens
I am using MongoDB text search. I see that the score of the result is indifferent to the order of the found tokens.
For example:
I am using a text search on the phrase: "aaa ccc"
In mongo, ...
- 297
1
vote
0
answers
280
views
Whoosh Phrase Frequency in One Document
I am trying to find the frequency of phrases in the text. But if there are several phrases in one document Whoosh still counts the whole document as a hit but not the Phrases entry.
Example:
self....
0
votes
1
answer
1k
views
gspread: Is there a way to load a dict into sheet.update_cells()?
I have what I think is extremely sloppy code here:
industry = []
headquarters = []
specialties = []
totalEmployeeCount = []
growth6Mth = []
website = []
for i in cvs_data:
j = ci_data[0]
for ...
- 19
-5
votes
1
answer
125
views
Finding 9 characters before a particular string in Python [closed]
For example here I have a line '2020-08-12 13:45:04 0.86393 %contrastWeber' and I need to extract 9 characters before ' %contrastWeber' string in text file.
So, here my answer will be '0.86393'. I ...
0
votes
2
answers
326
views
MongoDB $text $search not found with keywords: ['by','and','me'...]
I had a question about using find to search keyword 'by', 'and'... in my collections, but it were wrong with some situation, does any know how to fix it?
This is my collection & indexes:
db.stores....
- 120
0
votes
1
answer
442
views
Oracle text search with special character
I haved index as below;
create index cidx_column1 on MY_TABLE(column1) indextype is ctxsys.CTXCAT;
SELECT
from
MY_TABLE
WHERE catsearch(column1, '$*', null) > 0 and taken >
to_date('01/01/...
- 1
1
vote
1
answer
1k
views
Can a text be searched Blockwise in a PDF using PyMuPDF?
page.getTextBlocks()
Output
[(42.5, 86.45002746582031, 523.260009765625, 100.22002410888672, TEXT, 0, 0),
(65.75, 103.4000244140625, 266.780029296875, 159.59010314941406, TEXT, 1, 0),
(48.5, 86....
- 94
0
votes
1
answer
801
views
How to perform text search query in MongoDB using NodeJS?
I have documents like this
{
Name: "some data"
Another: " a lots of data in string"
Another: "string data here too
}
And have an array
Keyword = ["key1", "key2", .."keyn"]
I want to run a ...
0
votes
1
answer
147
views
Using $text search inside $or in mongodb
I'm trying to use $text search inside $or.
await Creators.aggregate([
{$match: {
$or: [
{ $creatorId: { $in: [407, 409] } },
{ $text: { $search: "Michael"} } ]
} }
])
The query won't ...
- 907
2
votes
0
answers
260
views
jupyter lab: case sensitive text search
if type ctrl+f in jupyter lab, there appears a text finder, but the search is not case sensitive. How may I configure it to make an case sensitive search?
- 304