Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PaulSc

    Import-CSV with dynamic fieldname filter.?

    Hi after picking a few brains (again...) please about a query I have using PowerShell.. I have a CSV file which contains the following data REF, SUN,MON,TUE,WED,THU,FRI,SAT,ACTIVE Ref001,N, Y, Y, Y, Y, Y, N, Y REF002,Y, N, N, N, N, N, Y, Y REF003,N, N, N, Y, N, N, Y, Y...
  2. PaulSc

    Powershell: SQLCMD, substituting variable for -serverinstance parameter

    Hi you seem to be using WPF forms so this may work.. function BuildDropDown1 { $YearFolders = Get-ChildItem -path $GalleryFolder.Text -Filter 2* $combobox0.Items.Clear() foreach ($SubFolder in $YearFolders) { $WhatYear = "{0}" -f $SubFolder.Name...
  3. PaulSc

    PowerShell Task Scheduler Not Working

    Confirm cdogg suggestion though we've "got away" with just powershell.exe -executionpolicy bypass -file "j:.........\script.ps1" Script parameters can also be passed in via the Add Arguments option. Also make sure any account passwords are correct as it doesnt seem to advise if incorrect
  4. PaulSc

    Powershell work with files created with previous Date after midnight..

    Hello I'm after a bit of help please in regards to the best way to handle a issue i have with a small "app" Ive inherited... this is a small PowerShell GUI/code which controls a handover document for a 3 shift rota system (i.e days, eves, nights). Each day we create 3 text files into a dated...
  5. PaulSc

    Help needed please: Assign variable to left hand side of an object definition

    Hello everybody, Im after a bit of guidance/pointers please on how to do something in PowerShell.... I have a function which displays the status of system services using a traffic light graphic... What I'm trying to do is to call the function with a number of parameters most of which are then...
  6. PaulSc

    Find and Replace Regex question please

    Thanks for your help... I work for a "bank" meaning that everythings controlled/locked down etc etc so no additional software whether its free or not....so have to make do with the tools available and notepad++ is the tool of choice..
  7. PaulSc

    Find and Replace Regex question please

    ...(in its basic install form i.e no xmltools plugin etc) so can anyone suggest please how we can maybe use regex to remove any /'s (or -'s or *'s etc) that appear between <Ref></Ref> tags whilst still maintaining the standard xml tags and keeping the rest of the data? i.e...
  8. PaulSc

    Find and Replace Regex question please

    ...been able to do using a find for "<Ref>[0-9]{4}/" and I then manually correct the data - fine if you find 3 or 4..but finding 100 + its a bit of a b****r..... knowing that's its always inside the <Ref> tags what I need too be able to do is to Remove the in-between tag /'s leaving just the...
    • PaulSc
    • Thread
    • Replies: 6
    • Forum: Perl
  9. PaulSc

    Couple of Win 10 (and its tools) questions please

    *Found a script to help with 2. Used RoboCopy with the /XL switch which only copies files if a newer copy exists and doesn't copy "Lonely" files... PaulSc
  10. PaulSc

    Couple of Win 10 (and its tools) questions please

    Hi Have a couple of Windows 10 related (and a RoboCopy one sneaked in...) questions please.. Running 64 Bit Home CU version 1/ Windows Explorer not updating Extra Large icons on image change/edit I have loads of images on disk, collected off the web, from cameras etc etc and mainly...
  11. PaulSc

    relative/absolute paths....

    Thanks for the suggestion(s)..I've got it working now... I ended up using a "plugin" javascript (from http://www.cryer.co.uk/resources/javascript/script17_include_js_from_js.htm) and the 1st of xwb's examples to set some vars to pass in... Chris, your way worked too, but only if site was run...
  12. PaulSc

    relative/absolute paths....

    Hi (as usual :-) ) I'm after a bit of guidance/help please.... I have a local html/javascript based image gallery "website" used to display my digital pictures. it uses a javascript menu/navigation bar which I have on all pages but with the "site" spread across multiple folder levels I'm...
  13. PaulSc

    T-SQL question - add a &quot;number of record&quot; field to groups of data

    Olaf, Thanks for this, it helps a lot.. To provide a bit more context I'm not too worried about maintaining the values as this is part of a process to rename image files (name) stored inside folders (ptName) and its for an ad-hoc process to re-sequence them i.e LEMansCars\Porsche.jpg would...
  14. PaulSc

    T-SQL question - add a &quot;number of record&quot; field to groups of data

    ...I can see that the Row_Number() OVER does something similar to what I want but I'd like it to be "reset" as each group is processed.. *EDIT Ok I've looked further into ROW_NUMBER and by using "ROW_Number() OVER (PARTITION by PtName Order By Name)" it gives me the expected results, but...
  15. PaulSc

    Office 2010/Win 10 Right click functions/menus not working?

    Thanks for the suggestions kjv1611 Ive tried the full uninstall/clean (using ccleaner/ms cleanup)/reboot/reinstall but the same thing happens.... Set up two new profiles (an admin/non admin) and both show the same issue (Though they did work the first time I accessed Excel/Word etc but as soon...
  16. PaulSc

    Office 2010/Win 10 Right click functions/menus not working?

    Hi, after a bit of help again please... I have a Win 10 (Home) setup with Office 2010 professional on it and have started to see a strange issue and wonder if anybodies seen/fixed it please... It seems to occur in all parts of office (i.e Excel, Access, Word..) and it's that the right click...
  17. PaulSc

    Some help/advice please - search/edit multiple strings on same line

    Hi I wonder if I can as some advice/get some assistance please... i have a script which runs through a folder of 1000's of static html pages, looks for a specific piece of data and then changes it (after some subsequent work) to another value.. its actually a <a or <src link to a graphic file...
  18. PaulSc

    Access 2010 Report Print Preview problem from Switchboard

    Not sure if it helps but I found that there's numerous print options available (look at All commands), so make sure you've added the Print Preview one to the toolbar..
  19. PaulSc

    Access 201:Print Preview Missing report navigation..

    Cheers.. This happens just with this one database so far on anything with > 1 page...... and yes we are using the {page] of [Pages} to display in the footers... Weve checked things like the code, references etc...weve even exported the report/query to another database and it works ok there...
  20. PaulSc

    Access 201:Print Preview Missing report navigation..

    Hi, been searching for this for ages but no luck so after a bit of help/advice please...... Fairly standard Access report opened from a form with Openreport,repname,AcViewPreview it creates a nice 238 page report however the Pages navigation bar at the bottom of the report is "missing"...

Part and Inventory Search

Back
Top