Excel VBA - Range.Find Error 1004

Below i have some code: Sub Priority() ActiveSheet.Name = "Raw Data" Dim ws As Worksheet Set ws = Sheets("Raw Data") Dim ws2 As Worksheet Set ws2 = ThisWorkbook.Sheets.Add(After:= _ ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)) ws2.Nam...
more »

2017-06-20 11:06 (1) Answers

Find a file and copy it to a folder

I'm doing a script that is intended to copy a file to another directory based on a given file path as input. Problem is that it copies the whole folder but the file I'm trying to copy. I tried different options and commands but the result is the same...
more »

2017-06-19 20:06 (0) Answers

Python find() "inaccuracy"

I'm using find to search for a string in another string. As is shown in this tutorial, "find" will locate "exam" in "example", "screw" in "screwdriver", etc. I need this to not happen, and only find an exact match. Is there some other way to achieve ...
more »

2017-06-17 14:06 (0) Answers

Replace words according to list sublime 3

I have a long list of substitutions (translations), i.e. hello -> hallo, this -> that, green -> yellow, etc and a text file where I would like to apply this, too. The list is very long and I do not want to do it one by one but rather provi...
more »

2017-06-15 23:06 (0) Answers

What the best way to delete files by extension?

I am looking the best way to delete files from directory by extension. I am planning to do it by date. But now, i am testing how it works. This: dir=/tmp/backup/ mask="jpeg jpg png gif bmp pdf" for i in $mask; do find $dir -name "*.$i" -type f -de...
more »

2017-06-15 16:06 (1) Answers

Working with the result of a VBA Find in Excel

I've trawled through a few hours of Google looking for an answer for this, so I apologise if it seems obvious to you, it really isn't to me! I'm trying to take a cell value from 1 workbook, search for it in another. As a result of that, select some ...
more »

2017-06-15 13:06 (1) Answers

MATLAB Find Strings,store in array and concatenate

I have a 6x2 cell array as follows: 'Word1_MSW' '1234' 'Word1_LSW' '5678' 'Word2_MSW' '1234' 'Word2_LSW' '5678' 'Word3_MSW' '1234' 'Word3_LSW' '5678' What I'd like to do is find all corresponding words and concatenate them automatically. For examp...
more »

2017-06-13 15:06 (2) Answers

How can i find files containing multiple patterns

I have many files within folders and subfolders. I have file called patterns.txt which contains patterns per line. Now i want o find files which match all those patterns. Patterns can be in any order. Example patterns.txt userdata "/" "{a: 1}" ...
more »

2017-06-13 05:06 (1) Answers

find command not working for the / (Root) Server

When i try to run the below command out put shows only from the certain folders., specially the file under the user home path is not listing. any other suggestion to excue the find from the / path ? im using Linux2.6 find / -type f -name abc* -exec...
more »

2017-06-12 13:06 (0) Answers

Compare directory structures

Is it possible to compare directory structures of two different server? I need to compare the directory structure of a test with that of a production server and list the directories that exists on prod but no in test (the test server has lot less inf...
more »

2017-06-12 11:06 (0) Answers

Excel 2010 - Find and Add

Current Data I need to find all instances of each value in "Column B" - Product Number and then add each value from "Column C" - QTY to get a total amount of the product number. I want the answer to the function to be placed in "Column I" on the sa...
more »

2017-06-11 23:06 (1) Answers

SailsJS not able to do multiple 'find'

here's the idea: I want to do a little website/manager game, and I'm trying to do a form to create a new player. I need to be able to select a position ("poste"), a city ("ville_naissance"), and some skills, and I'm stuck doing this. Via the PlayerC...
more »

2017-06-10 11:06 (0) Answers

Using arrays in Excel

I have one cell that contains the following information: door, chair, lock, bed, I want to take each word (so look for the comma) and use that word in a vlookup to get a price and then put the price in another field. I can get this to work for th...
more »

2017-06-09 14:06 (1) Answers

Is there a findall in Scala maps?

In a Scala Map, how do I get all keys in a Map that have the same value? For example in my Map I have 3 keys which have the value 27 Eg: large -> 27 indispensable -> 27 most -> 27 I tried val adj1value = htAdjId.find(_._2 == value1)...
more »

2017-06-09 13:06 (3) Answers

Remove all between two exact expressions in excel

Im trying to do something with my opencart store, i want to remove wrong formatting from all product descriptions, so i made one export in excel of all my products and descriptions ( products are near 8000) and i want to do this io this is my exporte...
more »

2017-06-08 21:06 (1) Answers

std namespace optional on find_if

I have run into a few circumstances in C++ 11 where it seems like the "std" namespace is optional. For example, the std::find_if() function. This will compile with and without the "std::" namespace qualifier. I had initially thought that I might h...
more »

2017-06-08 20:06 (0) Answers

find command error in shell script

I have a file "log_data.txt" which contains various log files and the mtime next to the names with a space. Contents of the file are as shown below, Log1 2 Log2 6 Log3 5 Log4 7 Log5 3 The intent here is my script shown below has to assign itself t...
more »

2017-06-08 16:06 (2) Answers