Search results for query: *

I happened to do the same testing on the command line & found that the matching is working too, so it must have been the way or where in the script I was doing the replace. I've managed to overcome this now by writing out the file & then doing the replace & outputting that using set-content. I...

I have a script that uses convertToHtml, which all works fine, except it produces multiple table headers due to the way I'm looping through a list of server names. I'm trying to tidy this up if only the replace procedure would play nicely. Instead it seems to fail matching the string that I...

Never mind. I found an alternate script that I managed to merge with this one to do what I needed to do. I had to use the System.Net.WebRequest method as the invoke-webrequest was producing a HTTP status of 0 despite the sites being accessible (it worked fine on my local machine, but had...

Hi, The script below is successfully checking a list of wsdls & was outputting to the console the correct status. However I've tried converting the output to HTML, but the output from the $body variable is blank (I'm guessing this is because it's not an object), but I don't know how to make it...

Thanks that's quite a neat little function (just need to remove the '$' from the last Trim$).

Thanks. I hadn't really noticed the seperator length issue as my maximum line length wasn't constrained, so it sort of looking right was fine for what I needed. However I do both appreciate you both taking the time to look at this & provide a fully working solution. I did correct the script...

I did notice something was a little off - & that would explain it. Anyway, corrected script below: if len(mylongstring) > maxlinelength Then mylongstring_arr = split(mylongstring,",") LineString = "" for x = 0 to ubound(mylongstring_arr) If len(LineString & "," & mylongstring_arr(x)) <=...

That's great, thanks. I think I was looking at it from the wrong perspective - I spent far too long trying to get it to work before posting on here!

Hi, I have a list of comma separated items, but only have a limited line length (aprox 50 chars) to display them. If I split them at the comma, I'll end up with a long list of items. What I'd like to to is fit as many as I can on each line. In essence I'd like to loop through the string &...

I think I've found it. (well it appears to work - will see what happens when the clocks go back)! var lm_hour = ('0' + lastmod.getHours()-(lastmod.getTimezoneOffset() /60))).slice(-2); .... //var currentDateTime = new Date(); //currentTimeIncTimezone =...

It's using (UTC) Dublin, Edinburgh, Lisbon, London & it shows DST ends on 30 October at 02:00.

Hi, I have some javascript below that reports the time since the html file was generated. This was all working fine until DST, where it started showing the Last Updated time as an hour behind the actual time. I believe I understand the concept of javascript time (i.e. milliseconds since 1...

Apologies, that was childish. I ended up opting to use an alternative script, which worked as I wanted it to. I understand the KISS principle, but was eager to learn how the original code could be corrected, even if it was the wrong & most impractical way to achieve what I was attempting.

just posting as much help as I recieved.

Thanks & that's probably the correct way of doing it, but I got it working late last night.

because it's for someone who is IT illiterate. If I can get this to work correectly they can just click on the big 'Import' button & everything is ready for them.

Thanks I never knew the dataformat was stored, but for the sake of learning, I'd like to know why the existing code doesn't work as expected. I'm sure I need to split the line input at each line break (vbcrlf), but wont this break the splitting of the values into columns? Alos I'm not sure how...

Thanks SkipVought, but i am trying to avoid using the data import as it is a very slow & tedious process to change all the columns to a text format rather than General. The code does the import & sets the field to Text, correctly. The only problem is that all of the data in the CSV is...

Hi guys, I'm trying to import a csv file to Excel & forcing the cells to be text fields so that numeric values don't loose leading zero's. Unfortunately the code I have is importing all of the lines in the csv to row 1. I would apreciate some help to show me what I am missing to split the...

Ok. I'm having difficulty producing the pivot table when using both the DOB column and the gender column. I keep getting a message saying that 'The PivotTable field name is not valid. To create a PivotTable Report, you must use data that is organised as a list with labeled columns. If you...