Questions tagged [locate]

locate is the main command in the mlocate package. It is used to search for files, by default by a substring of their full path, based on a database populated by the updatedb command.

263 questions
0
votes
1 answer

Return specific text from MySQL using LOCATE and SUBSTRING

I want to know how many yards were ran in my NFL SQL database. I use the following query: Select season, description, down, ydsto1st FROM nflpxp WHERE ( DESCRIPTION LIKE "%up the middle%" OR DESCRIPTION REGEXP "(left|right)…
NeilG
  • 683
  • 2
  • 7
  • 10
0
votes
2 answers

VBS Script to locate all files of certain extensions and copy them to a specific destination

I'm making a project out of creating a script to use at work to automate one of our processes. I'd like the script to check an input for username to search the specified user profile path for any files of .doc,.docx,.pdf,.pst ect. and copy them as…
MGMorrison
  • 1
  • 1
  • 1
0
votes
2 answers

Scp locate's output by Xargs

I want to make a list of files of locate's output. I want scp to take the list. I am not sure about the syntax. My attempt with pseudo-code locate labra | xargs scp {} masi@11.11.11:~/Desktop/ How can you move the files to the destination?
Léo Léopold Hertz 준영
  • 134,464
  • 179
  • 445
  • 697
0
votes
1 answer

sqlite string locate

What is the syntax in SQLite to get all values which contains given string? I tried: SELECT columnName FROM tableName WHERE LOCATE(string,columnName)!=0; but it didn't work.
SzRaPnEL
  • 171
  • 3
  • 17
0
votes
1 answer

Adjacent characters in php string

How can I find what characters are adjacent to a located string in php? I'm using a foreach loop to find each value inside a larger body of text with a variable of $value, so how would I also figure out what characters surround that string of…
David Grabon
  • 107
  • 7
0
votes
1 answer

Find a exact word form column A within Text in Column B (MySQL)

i have 2 tables, and try to eleminate all entries in table 1 (multiple words per row) wich contain one of the entries in table 2. These words from table 2 can be somewhere in the strings of Table 1. it should find things like: 'house' in 'big house…
0
votes
1 answer

Use charindex to locate an apostrophe

I have data like this: State ID ----- -- 'CA' 5 'CA' 3 'MA' 2 'NH' 1 'NJ' 8 'NH' 9 For all the states it is putting apostrophes around the states. I'm looking to somehow search by the state abbreviation but it won't let me…
Jt2ouan
  • 1,964
  • 9
  • 33
  • 55
0
votes
1 answer

GPS Android find location application

Is it possible to create a GPS application using Google Maps to locate the position of items. To do this, I think that the process would be to attatch a GPS transmiting device to an item (such as car keys or sun glasses) and if you lose them, their…
Garry
  • 1,251
  • 9
  • 25
  • 45
0
votes
1 answer

batch file to locate text that comes between a static left & right boundary

I'm looking for a batch file to locate text that comes between a static left & right boundary. The text found would be echoed to a new file. The beginning boundary, like the end, are tags (the left curly is really just an opening…
0
votes
2 answers

PHP Locate a stored file by a part of its name

friends. I need to locate a file, stored in my site while using php and finding it with a part of its name. I cant locate it by its entire name because the php file cannot know its extension. It might be png and might be jpg. How do I do that?
Ben Rokah
  • 33
  • 3
0
votes
1 answer

How to use cgal triangulation_3 locate?

Hi i'm using a Delaunay_triangulation_2 and Delaunay_triangulation_3 for finding points for interpolation. I found how to use locate for Delaunay_triangulation_2: Locate_type loc; int li; CgalPoint point(_params[0], _params[1]); Face_handle handle =…
Dorian
  • 377
  • 5
  • 18
0
votes
1 answer

can't locate VB picture

I've been modifying a picture, and the Old picture still does work even though I've delete all pictures in the vb project. Is there somewhere that still has reference to pictures in the project? If anyone could help me ,thank you!!
远 思
  • 3
  • 1
0
votes
1 answer

Regular Expression: omit search string

Let's say I'd like to find something specific on a filesystem, but to omit certain directories in the search. Rather than type locate string, I'd like to type locate string[omit anything which resides in specified directory]. So, for example, let's…
zeboidlund
  • 9,731
  • 31
  • 118
  • 180
0
votes
1 answer

how to i find out how old my locate database is?

locate -Sd /path/to/db does not give the age of the database. And i can't find any further info in the man pages of locate or updatedb. Cheers.
centerback
  • 619
  • 4
  • 16
0
votes
1 answer

Finding the window at a point on screen in java

Is there any cross-platform way to figure out which window is at a certain point on the screen? If there is not, what would be the equivalent function to getWindowAtPoint for linux (X11?) and OS X?
Jeremy Salwen
  • 8,061
  • 5
  • 50
  • 73