What's new
By:
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

computer issues: part infinity

Re: computer issues: part infinity

I did read only and renamed the one document that was locked. I guess I should have just asked if renaming the personal macro workbook messes with Excel since it's a default file for the program.
 
Re: computer issues: part infinity

St. Clown said:
People mock that reply they give, but it works so much more often than the average user expects. There's a reason it became one of the first replies they give.
Click to expand...

I know full well, and I always reboot first to see if it fixes the issue. And I unplug the modem first if the wifi is down, and in my business we shut down and restart digital controllers first if the mechanical equipment is acting up.
 
Re: computer issues: part infinity

Spartanforlife4 said:
I did read only and renamed the one document that was locked. I guess I should have just asked if renaming the personal macro workbook messes with Excel since it's a default file for the program.
Click to expand...

You might try a two-step: open the locked document, as you have, and rename it. Then delete the original and then resave the new document under the original name.

I've done that before (on PC not Mac) and it worked fine.
 
Re: computer issues: part infinity

I heard the following on the radio this morning.

"you cannot believe everything you read on the internet."
-- Abraham Lincoln
 
Re: computer issues: part infinity

I had 15 minutes of *ahem* downtime today and I made a shortcut in iOS to automatically take a tweet from twitter and copy the embed code all in one click. I hated how you had to open it in safari, then click the drop down and select embed then click the stupid copy code button.
 
Re: computer issues: part infinity

dxmnkd316 said:
I had 15 minutes of *ahem* downtime today and I made a shortcut in iOS to automatically take a tweet from twitter and copy the embed code all in one click. I hated how you had to open it in safari, then click the drop down and select embed then click the stupid copy code button.
Click to expand...

Huh. Wonder if it would be possible to do an Android version. Any way to share the iOS shortcut or not because of their locked ecosystem?
 
Here are my Speakeasy download speeds for the last 4 days:
Code: 
6/12 11:10 am  53 Mb
6/14 08:31 am 217 Mb
6/15 06:20 pm 477 Mb

That aint normal variance. What is going on?
 
Long story long ... but has good info and a reasonable ending for me.

I'm running Win10 Ver 20H2. I needed to install some software to program a brand of PLC I'm not fond of (so off to bumpy start before I start). I start the installer and the machine freezes. Then it reboots; the Dell BIOS screen comes up fine, but then it "blue screens". I'd never seen a Win10 blue screen of death. It can't jump to Windows; it reboots, Dell BIOS, can't jump to Windows. Lather, rinse, repeat.

I've been bricked.

Had to create a "boot stick" USB drive (two hours I'll never get back) and boot from that. Using that I found the machine had created a restore point at 0400 hours that morning. (I got really lucky there.)

I was able to restore the machine. < big exhale >

Seems the software's (InstallShield) installer doesn't check to see if you have the software license manager installed and it's mandatory before putting in the software. Nothing in the docs; no warning from the software installer. Just the blue screen. Worse? When I called tech support they admitted about half the time they brick machines for this very issue.

So, go get license manager to try again. But beware -- use the license manager for my Ver 20H2 says the download page. (First good info in any of this.)

Finally get manager and software installed.

But wait ... there's more!

Over the weekend I took a big Windows Update push. And after that my (didn't realize it was configured when it saved me) automatic restore point creation was shut off by the update!

An auto restore point saved my bacon.

If you took a Windows push in the last week or so, you might want to see how your machine is configured.
 
The Sicatoka said:
Long story long ... but has good info and a reasonable ending for me.

I'm running Win10 Ver 20H2. I needed to install some software to program a brand of PLC I'm not fond of (so off to bumpy start before I start). I start the installer and the machine freezes. Then it reboots; the Dell BIOS screen comes up fine, but then it "blue screens". I'd never seen a Win10 blue screen of death. It can't jump to Windows; it reboots, Dell BIOS, can't jump to Windows. Lather, rinse, repeat.

I've been bricked.

Had to create a "boot stick" USB drive (two hours I'll never get back) and boot from that. Using that I found the machine had created a restore point at 0400 hours that morning. (I got really lucky there.)

I was able to restore the machine. < big exhale >

Seems the software's (InstallShield) installer doesn't check to see if you have the software license manager installed and it's mandatory before putting in the software. Nothing in the docs; no warning from the software installer. Just the blue screen. Worse? When I called tech support they admitted about half the time they brick machines for this very issue.

So, go get license manager to try again. But beware -- use the license manager for my Ver 20H2 says the download page. (First good info in any of this.)

Finally get manager and software installed.

But wait ... there's more!

Over the weekend I took a big Windows Update push. And after that my (didn't realize it was configured when it saved me) automatic restore point creation was shut off by the update!

An auto restore point saved my bacon.

If you took a Windows push in the last week or so, you might want to see how your machine is configured.
Click to expand...

Wow. Thank you. That is a BFD.

My favorite problem with my old Windows 10 machine:

Boot up, nothing
Manual reboot, nothing
Manual reboot, blue diagnostics screen
Run diagnostics, "Try pulling all usb plugs and rebooting." (???)
Um... okay, pull usb plugs (printers, mouse, keyboard)
Run programmatic reboot from diagnostics screen, nothing
Manual reboot, nothing
Manual reboot, blue diagnostics screen
Run diagnostics, "No keyboard detected. Are you sure your usb is connected?"
 
Last edited:
Trying to figure out why my laptop screen was flashing on and off while running Word and Chrome together.

Tried rebooting and closing Word to see what happens. I'm praying it's not a backlight or something I can't afford to fix right now.
 
Any SQL query pros here? I’m trying to parse SWIFT message file using MS SQL Management Studio and need to extract a variable length field.

example text:

:20C::SEME//ABC123XX
:23G:NEWM

The 20C message tag is variable length, and while I know how to start the field extract in the right spot, I can’t nail down a how to stop the the extract based upon the :23G: location.

Any help around here? It’s be much appreciated.

(Also, these SWIFT file layouts are easily available on the web, so no corp secrets revealed.)
 
Usually with a variable character length field, you have to parse for a null space or a data separator (like a comma) at the end of the substring you want to extract. In other languages, this is most commonly done by separating each character into an array and then looping through each character in the array. I'm not sure how you'd do that with SQL alone.
 
St. Clown said:
Any SQL query pros here? I’m trying to parse SWIFT message file using MS SQL Management Studio and need to extract a variable length field.

example text:

:20C::SEME//ABC123XX
:23G:NEWM

The 20C message tag is variable length, and while I know how to start the field extract in the right spot, I can’t nail down a how to stop the the extract based upon the :23G: location.

Any help around here? It’s be much appreciated.

(Also, these SWIFT file layouts are easily available on the web, so no corp secrets revealed.)
Click to expand...

I reached out to one of the architects on my current team. Not sure if this will help, here's what he came up with. It assumes the tags are consistent and are not duplicated within the message.
Code: 
assuming the data is in a column called fld, then it's

select substring(fld, charindex(':20C:', fld) + 4, charindex(':23G:', fld) - charindex(':20C:', fld) - 4)
 
TalonsUpPuckDown said:
I reached out to one of the architects on my current team. Not sure if this will help, here's what he came up with. It assumes the tags are consistent and are not duplicated within the message.
Code: 
assuming the data is in a column called fld, then it's

select substring(fld, charindex(':20C:', fld) + 4, charindex(':23G:', fld) - charindex(':20C:', fld) - 4)
Click to expand...
Thank you very much for that!
 
St. Clown said:
Thank you very much for that!
Click to expand...
Glad it worked out. I was reviewing this with the architect and pointed out that his solution matched very closely with stuff I'd coded in Excel to do the same thing. I am not SQL literate at all but due to being a coder two lifetimes ago (ala the 1980's pre-object oriented world of Turbo Pascal, COBOL, RPG and other dead, Latin-like, procedural-based languages and hierarchical databases) I'm quite good with Excel. After I pointed out the similarities between his syntax and Excel and he commented that it's all Microsoft so under the covers it'll all be basically the same. Duh. I pass this observation along on the off chance it may be useful in the future. Anyway, here it is in Excel assuming the message string is in cell A1:

=MID(A1,FIND(":20C:",A1)+5,FIND(":23G:",A1)-5)
 
You must log in or register to reply here.
Back
Top