Messages

326

General Software Discussion / Re: Test cell value for BLANK in Excel and take action (or not) based on it

« on: September 11, 2015, 01:38 AM »

OK, let see what we can do here....

the simple answer is to substitute the formulas in columns C and D for the XXXX so the formula now becomes

   C3=if(trim(a3&B3) = "","",(LEFT(md5hash(A3&B3),8))

of course this doesn't cater for the situation where the (damn!!) user enters the same value twice, so

   C3=if(trim(a3&B3) = "","",if(trim(A3) = trim(B3), "GODAMMIT, I TOLD YOU NOT TO PUT THE SAME VALUE IN BOTH FIELDS, NOW GO BACK AND DO IT PROPERLY",(LEFT(md5hash(A3&B3),8))

this will test if the fields match (and prompt the user), or are empty, and do nothing).  Match this up with some conditional formatting and you've got a pretty good flag

Of course as IanB pointed out data quality is a key consideration, eg what are the criteria for generating the values in Ax and Bx?  Do they have to be numeric, or alpha, or alphanumeric?  Do they have to be a certain length, or within a set length (ie 6 to 8 chars), and so on.  Answering those questions in as much detail as possible will enable you too better refine the rulesets

327

General Software Discussion / Re: Test cell value for BLANK in Excel and take action (or not) based on it

« on: September 10, 2015, 12:00 AM »

=if(trim(a3&B3) = "","",XXXX)?

this will check both Ax AND Bx for a value, and return nothing if true, or XXXX if false

still too many variables for me to say with any certainty (I can still think of several possible scenarios/solutions).

To work correctly, both A and B have to be a "real" value of some kind and if either one is empty it means somebody didn't fill in the sheet correctly

this infers some sort of some sort of data validation rules could be applied which might solve some (if not all) of your data quality issues.

328

Post New Requests Here / Re: I input a CSV file and you tell me if X is within the range of Y.

« on: September 09, 2015, 04:36 PM »

can you provide some dummy data sets? and the 'matching' criteria?

329

Official Announcements / Re: Forum Upgraded August 30, 2015 - Report issues here

« on: September 08, 2015, 06:00 PM »

I find that there isn't enough contrast between pinned threads and everything else (eg the living room) particularly when viewed on a small device (like my 10" netbook).  Did the old format have a dedicated icon (I can't remember, but it was quite plain)

-Target (September 07, 2015, 07:15 PM)

Check again now please (make sure to F5 to reload css).

-mouser (September 08, 2015, 05:58 AM)

contrast is the same, but the pins are quite plain

many thanks!!

330

Official Announcements / Re: Forum Upgraded August 30, 2015 - Report issues here

« on: September 07, 2015, 07:15 PM »

could be this has already been discussed but I couldn't see it

I find that there isn't enough contrast between pinned threads and everything else (eg the living room) particularly when viewed on a small device (like my 10" netbook).  Did the old format have a dedicated icon (I can't remember, but it was quite plain)

Not a biggy by any means, it just takes me a bit longer to get to the 'current' threads

331

General Software Discussion / Re: HELP! AMD Catalyst update broke my PC - How best to reinstall Windows 7?

« on: September 06, 2015, 11:59 PM »

If you can boot into Safe Mode see if you can remove the AMD Catalyst drivers and your AV program, (to stop it interfering in any other operation - the AV will cease to function after an In Place Upgrade anyway.)  This might allow the system to boot normally and you'd only need to reinstall any necessary drivers and your AV.

-4wd (September 06, 2015, 11:26 PM)

+1 for this

I've had experience with both AVG and Catalyst borking updates so I'd try this first.

and as a rule I just install the video drivers instead of the entire catalyst suite

332

General Software Discussion / Re: Test cell value for BLANK in Excel and take action (or not) based on it

« on: September 03, 2015, 12:35 AM »

there are probably dozens of ways to do this, but without knowing more about your particular case you can try this (obviously this is for cell Cx)

=if(aX = "","",XXXX)

333

Announce Your Software/Service/Product / Re: Context Note

« on: August 26, 2015, 05:36 PM »

And there are subtle issues when you do like it so much you create like 400 stickies over time.

-TaoPhoenix (August 26, 2015, 04:53 PM)

I think you might have misunderstood the term 'subtle'

334

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« on: August 25, 2015, 11:14 PM »

trying it now - interesting experience actually.  Tried 2 separate downloads from sourceforge on 2 different machines and while they 'installed' they wouldn't run.  After a bit of hunting around sourced from the cyberfox site and it's running (with onetab installed!!).  Time will tell if it's any better than native FF I suppose

-Target (August 25, 2015, 06:18 PM)

so this is getting bizarre - been running cyberfox today with onetab and noscript only.  Onetab was there this morning but has since vanished.  It's still installed, but no functionality is exposed.  wtf?

335

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« on: August 25, 2015, 06:18 PM »

Perhaps give Cyberfox Portable a go, I just copied my profile from PM and then installed OneTab and everything worked, (except PM specific add-ons, to be expected).

https://cyberfox.8pecxstudios.com/

-4wd (August 25, 2015, 04:32 AM)

trying it now - interesting experience actually.  Tried 2 separate downloads from sourceforge on 2 different machines and while they 'installed' they wouldn't run.  After a bit of hunting around sourced from the cyberfox site and it's running (with onetab installed!!).  Time will tell if it's any better than native FF I suppose

336

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« on: August 25, 2015, 02:04 AM »

To add insult to injury, I just installed FF 40.0.2 as a test and OneTab installed fine

-4wd (August 24, 2015, 08:41 PM)

maybe it's the portable part - just setup a fresh copy and it still doesn't work 

and FWIW I can't use a full install in this situation

337

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« on: August 24, 2015, 08:11 PM »

ok, I already had that setting in config, and I installed the tester tools app - net result was nil

seems like that addin might be a bit flakey (then again, FF might be being over zealous)

given the increasingly unstable nature of firefox it's looking like I'm going to have to change browsers.  trouble is, FF is the only one that seems to match some significant parts of my work flow 

338

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« on: August 24, 2015, 04:43 PM »

Details seem missing from the story.

I agree.  Details seem a bit sketchy.

He was quick on the draw.
 

-cranioscopical (August 23, 2015, 12:26 PM)

It was only penciled in at the time.

-wraith808 (August 23, 2015, 02:07 PM)

Canvasing the comments has proven quite interesting.

-MilesAhead (August 23, 2015, 04:47 PM)

I still wouldn't draw any conclusions from it. I'd wait until we get the complete picture.

-x16wda (August 23, 2015, 05:34 PM)

I see the fountain of wisdom in that penning.

-wraith808 (August 23, 2015, 06:10 PM)

I think it's time that somebody here took the lead.
 

-cranioscopical (August 23, 2015, 11:18 PM)

All is well that pens well.

-MilesAhead (August 24, 2015, 06:51 AM)

That's penning review.

-wraith808 (August 24, 2015, 07:19 AM)

where there's a quill there's a way

339

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« on: August 24, 2015, 01:34 AM »

huh, it seems onetab won't work for me no way no how (FF40.0.2 portable).

it seems to install ok, but no controls or menus are exposed so if it is there I can't interact with it.

Tried disabling ALL addins, changing to the default appearance, etc, and no go 

sure would like to recover some resources...

340

General Software Discussion / Re: win update issues

« on: August 20, 2015, 01:27 AM »

These may help you get back on track -

https://support.micr...67#/en-us/kb/2700567

http://pcsupport.abo...ws-update-frozen.htm

The Microsoft Fix It (first link) worked for my Vista Home Premium update freezes.

-crabby3 (August 20, 2015, 01:08 AM)

nope, the fixit tool...didn't.  And FWIW there are apparently 2 versions, one of which can be more 'aggressive' in its actions

341

General Software Discussion / Re: win update issues

« on: August 20, 2015, 12:38 AM »

it never fails... within about 30 mins of posting this it started to update 

that said, i'm not at all confident that the issue has resolved itself 

342

General Software Discussion / win update issues

« on: August 19, 2015, 11:55 PM »

looking for assistance in resolving a win update problem (essentially it doesn't)

On my win7 SE netbook windows update performance (?) has deteriorated over time, such that it hasn't displayed progress for some time, and has now refused to download or apply updates altogether.

I've googled and it appears to be a relatively common issue, but none of the common fixes seem to work in this case (ie it's been sitting on the desk for the last 6+ hours 'updating' without change - no progress, no change)

Anyone here got any suggestions (other than a rebuild)

343

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« on: August 17, 2015, 12:59 AM »

How to vote?

-Renegade (August 17, 2015, 12:37 AM)

the ultimate rick-roll?

344

Non-Windows Software / Re: Thoughts on "next generation" forum systems? (Discourse, nodeBB, etc.)

« on: July 20, 2015, 05:29 PM »

Isn't the difference in the attention span of the respective audiences? (and consequently the content)

-Target (July 20, 2015, 12:30 AM)

This has a lot of words in it! Can you make it simpler? Like in a meme gif?

-TaoPhoenix (July 20, 2015, 04:01 PM)

345

Non-Windows Software / Re: Thoughts on "next generation" forum systems? (Discourse, nodeBB, etc.)

« on: July 20, 2015, 12:30 AM »

isn't the difference in the attention span of the respective audiences? (and consequently the content)

346

Post New Requests Here / Re: Script for replace any substring in a text file accodring a csv data file

« on: July 08, 2015, 12:34 AM »

In my case i think is simpler. I need only one parameter.

-Contro (May 04, 2015, 08:28 AM)

simpler than that...

this is (untested) in AHK...

[Select]

inputbox, srch, Search String                      ; get a search string

inputbox, rep, Replacement string                  ;get a replacement string

fileselectfile, tmp_,,,Select a file, CSV(*.csv)   ; select a csv file

fileread, tmp_2, %tmp_%                            ; read in to a variable

stringreplace, %tmp_2%, tmp_2, %srch%, %rep%, all  ; replace all occurrences of the srch string with the rep string

fileappend, %tmp_2%, %tmp_%.csv                    ; write out to a new file

exitapp

347

Living Room / Re: Interesting "stuff"

« on: June 30, 2015, 07:56 PM »

do androids use robotic dogs to round up sheep? (sorry,very weak pun )

Sony's robotic dogs are dying a slow death

348

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: June 24, 2015, 07:09 PM »

nice job, but now I want to look through your record collection

349

General Software Discussion / Re: automatically number images in word

« on: June 23, 2015, 06:33 PM »

here's a word vba macro that will number the images for you

[Select]

Sub captions()
Dim i As Integer

For i = 1 To ActiveDocument.InlineShapes.Count
    If ActiveDocument.InlineShapes.Item(i).Type = wdInlineShapePicture Then
        ActiveDocument.InlineShapes(i).Select
        Selection.InsertCaption Label:="Figure", Title:=" - This is image #" & i, Position:=wdCaptionPositionBelow
    End If
Next i
End Sub

google is your friend...

350

Announce Your Software/Service/Product / Re: WildGem 1.1

« on: June 16, 2015, 05:32 PM »

Idea: What about a way to disable/hide replace and size the find and the textarea accordingly if all you want to do is build regex in your program for use elsewhere?

-hamradio (June 16, 2015, 05:15 PM)

were you experimenting with the program when you wrote this?