Find and Replace keeps crashing

I am using a Find and Replace, simple VBA code as below: Sub MultiFindNReplace() 'Update 20140722 Dim Rng As Range Dim InputRng As Range, ReplaceRng As Range xTitleId = "KutoolsforExcel" Set InputRng = Application.Selection Set InputRng = Applicatio...
more »

2017-12-03 23:12 (1) Answers

Find Rightmost Used Column in Excel with VBA

I am having trouble with something that I think should be quite simple and I can't figure out why it isn't giving me the result I want. I have an Excel worksheet sht_Attributes that is laid out as below: I want to get the last (farthest right) cel...
more »

2017-11-30 16:11 (0) Answers

mysql and php algorithm stack

First of all sorry for my bad English. I have two tables, one with products and one with stocks In the one with stocks I insert new products, or delete them if stock is greater or zero. Most important columns in stocks table are: productId (which h...
more »

2017-11-28 09:11 (0) Answers

Copy Paste Cells under certain Conditions

I would like some help with the code I'm currently having issues with. This is what the code is designed to do: Inside the "Data" sheet, the code looks for "[whichever term] - Competency", and when it finds it, the steps are as follows: Highlight...
more »

2017-11-27 18:11 (0) Answers

How to all the details of record in mongodb

I have a post request which saves the data in the following format { "_id" : ObjectId("5a1bb15a8f7748197b175b9f"), "created_at" : ISODate("2017-11-27T06:31:54.288+0000"), "updated_at" : ISODate("2017-11-27T06:32:22.943+0000"), "s...
more »

2017-11-27 10:11 (1) Answers

Recursive Find and Replacing String?

My question is about finding and replacing strings in a text file. This program is supposed to find the instances of the word ghost within A Christmas Carol text file and replace them with bunny for ghost, Bunny for Ghost and BUNNY for GHOST. It work...
more »

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

Find (and replace) styles in Word using C#

I'm coping with finding (and eventually replacing) some text by styles in Word. The idea is, let's say, to convert all "Heading 2" paragraphs to "Heading 1". But I don't know how to find ONLY style, regardless of its contents. Can anyone point me in...
more »

2017-11-26 19:11 (1) Answers

What is the update for find() in Swift 3?

I used find() to reference two arrays of Floats in Swift 1, but cannot find the equivalent for Swift 3. I've tried indexOf and array.first with no luck. I've been unable to find any other alternatives. Can someone provide some guidance here? I'm no...
more »

2017-11-25 23:11 (0) Answers

Paths must precede expression Linux find

I have the following command: find -xtype f -iname '*NEN*' -o '*1990*' I get the error "find: paths must precede expression: 1990" Why is this? I have quoted the wildcard, so I don't see the error. How to fix this? Thanks! ...
more »

2017-11-25 14:11 (1) Answers

Faster alternative for find and sort in MATLAB

I am working on community detection with a genetic algorithm. Communities are represented in locus-based representation, that each index(gene) and it's value are in same community. For example in the figure below, if the chromosome is (b) the commun...
more »

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

MONGODB - find on "_id" with JAVA

I am trying to do this query : db.indexInverse.find({_id:ObjectId("5a153409b9c52933c8aab068")}).pretty() with Java ... actually i try many things ... but that don't find my document ... Document vraiDoc = collectionIndexInverse.find(Filters.eq(...
more »

2017-11-22 19:11 (1) Answers

strrpos find second occurrence

in PHP, Why cant I find the second occurrence of "some test" using strrpos function fnd ($a){ $offset = 1; $sTag = "some test"; echo "offset ".$offset ."<BR>"; echo "Start Tag " .$sTag ."<BR>"; $pos1 = strrpos ($a, $sTag, $o...
more »

2017-11-21 19:11 (0) Answers

Python find row position into matrix

I need help with a problem. I have a list like the sample above: list = [[{'bu':'01-DAM-XNXX'}, 45, 60], [{'bu':'02-TAC-MWKKK'}, 80, 120], ...] and I need to find the number of the row depending of the value of the 'bu' key of the dictionary. In t...
more »

2017-11-21 16:11 (3) Answers

Excel - How to find unique count with 2 criteria

Please assist. I want to count unique names in 'Sheet1!B:B'. It should only count those unique names that have 'Project A' or 'Project B in 'Sheet1!D:D'. If possible, I would like to do it with a formula instead of using VBA. Tried some formulas fro...
more »

2017-11-21 15:11 (0) Answers

Linux LS -T output in Find command

I have prepared a script with ls -t to fetch latest file and compare with duplicates i use below ls -t *xml |awk 'BEGIN{FS="_"}{if (++dup[$1] >= 2) print}' However for large size folder ls command not working. so i tried with find ./ -type f \...
more »

2017-11-21 04:11 (1) Answers

How to prioritize Git-Bash binaries on Windows

I have Git Bash installed on a Windows build agent and when running scripts, whenever I would use "find", it would run the DOS Find ( instead of the Unix one. What is the best way to get my sc...
more »

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

c# find replace in word

I recently started learning C#. I'm trying to write some of my macros (written in VBA) in C# - actually I'm trying to make a new ribbon for Word with buttons doing some activities... So, I'm trying to make a button doing simple find/replace in activ...
more »

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

Deleting a hidden cron job

Long story short, I have a cron job on my system that is displaying annoying messages. The cron is hidden on the system (that is, not located in the cron hourly, weekly, etc. I have also tried looking in /etc/crontab/ and /var/spool/cron/), making it...
more »

2017-11-19 22:11 (0) Answers

Sails js find() finding non-existing users

I'm trying to build a simple server in SailsJS and encountered a problem: I send a POST request to the service in Sails, and I always get a 200 response, even when there's no matching user in the on-disk DB. My model: module.exports = { attribute...
more »

2017-11-19 17:11 (1) Answers