IrritableTech

Amazing. That has done the trick. Thank you very much, to you both. If I can ever return the favour, please ask.

Thanks for your reply. It does seem that the quotation marks are causing an issue. I am 99.999% sure that we will never need to import any data with commas within a field. Is it an easy function to add? Cheers

Thanks Los0jos thats fantastic. The only issue was that it stripped my commas from the resulting csv file. I've tweaked the script so that it orders the columns for my needs, and added in commas. Is this a really bad way to do it? I'm really no good at this... it does work though! Set objFSO = CreateObject("Scripting.FileSystemObject") Const ForReading = 1 Const ForWriting = 2 Set objFileA = objFSO.OpenTextFile ("c:\locationA\fileA.csv", ForReading) Set objFileB = objFSO.OpenTextFile ("c:\locationB\fileB.csv", ForWriting) i = 0 Do Until objFileA.AtEndOfStream strNextLine = objFileA.Readline If strNextLine <> "" Then strNextLine = "add,student," & strNextLine strSplit=Split(strNextLine,",") objFileB.WriteLine strSplit(0) & "," & strSplit(1) & "," & strSplit(3) & "," & strSplit(2) End If i = i + 1 Loop objFileA.Close objFileB.Close Can anyone advise me on how to get rid of speech marks (") in the resulting file? Thanks again both.

Superb! Thanks again apeo. Now I just need to work out how to change the order of my columns in my original csv file, and I'll have it cracked!

Thanks you very much apeo that is almost perfect! It is creating a empty line after each data line, however it doesn't seem to worry the system to which I am importing. I just need to play around with a bit of formatting with "file A" and I think i'll have it cracked. Where do I send the beer tokens?

Thanks cromertech, I will take a look... Thanks also apeo. To clarify, location a and b are fixed... ie. I wish to open file A (which will be regenerated every hour) make the adjustments and overwrite file b in it's fixed location.

I hope someone can help or point me in the right direction after a frustrating couple of hours trying to find a script to complete this task. I need to run a process probably hourly (hence the script) to complete the following task... Open a csv file in location A Add two extra fields of data (eg data1,data2,) to the beginning of every single line Save the resulting csv file in location B I've been looking around at vbs scripts and found the following, but I'm really not very good at vbs to get to the next stage. Thanks in advance. Sub ConvertFile(strFileName As String) Dim InFileID As Integer, OutFileID As Integer Dim strData As String InFileID = FreeFile Open strFileName For Input As #InFileID OutFileID = FreeFile Open strFileName & ".tmp" For Output As #OutFileID Do Until EOF(InFileID) Line Input #InFileID, strData Print #OutFileID, "data1,data2" & strData Loop Close #InFileID Close #OutFileID Kill strFileName Name strFileName & ".tmp" As strFileName End Sub

I've got a BMW F650GS on an 02 plate. Serves me well all year round, but as a result, it looks a bit untidy!

I've got TV(HD), calls and broadband all with sky. The broadband (LLU) is excellent for the money. Never taken the leap to hand over my line rental to them but perhaps I should. Haven't a single complaint except the regular price increases!

I had the same trouble when I started here. I made sure I had a good backup and used PMagic to resize the partitions on two servers. One worked perfectly, the other didn't and I had to restore my dc.

With two workstations attached to your problematic switches, can they ping each other reliably?

That must be why they are advertising!

If you lot are still after the dos drivers... I downloaded them a few weeks ago. Can't remember where from but they worked for my pxe boot image. Attached AR813x_AR815x.zip

Fair enough I suppose, leave the leading to the leaders.

I would suggest that you really shouldn't have full names of students in your bulletin, even if it only goes out to parents. Even if little johnny is in the same class as little jacob, doesn't mean little johnnys dad should be able to identify little jacob. We only ever publish first names in general mailings.

Me too, never had an issue with using other smtps. I use googles and my own servers on o2 without any issue. How odd.

I can echo what mark says. We have two samsung screens which I bought with a view to pop xibo on. Took a ten minute look at MagicInfo and was reassured I'd made the right decision. We have had a couple of teething issues with xibo. Mainly due to user error, or my terrible training! Xibo is a fantastic product. If you do opt for just powerpoint though, grab this; PresentationPoint | ShowPoint control remotely It checks the centrally hosted powerpoint file every so often for an updated version. Saves having to remote in to each screen to update.

We get this on some soundcard drivers. You need to change the recording properties in either the soundcard software, or windows sound properties. Audacity can't seem to do it.

Kudlian Software Limited This company were pushing their software at bett. It's about £400 for a site licence of their weather studio software. Which I believe includes live chroma key. Try the fre trial.

It sounds to me like these user accounts get used by different people each session? You could try to hide the my pics and my vids, and deny the user access? Might cause log on issues though.

I had an issue where the lenses didn't fit the frames correctly from Glasses Direct. After a second go, and them having the same issue they were happy to let me have my money back. I think the problem was mainly the thickness of my lenses, and the thin frame (although I did pay an extra £100+ for thinner lenses). I wouldn't buy glasses from specsavers again after the rubbish they tried to send me home with last time. Four attempts they had at ensuring the strap was tight, and the lenses were cut to the right size. Also tried to fob me off with cheaper lenses than I had paid for. I use lenses all the time now, far less hassle.

I got a pair of those, but they seem to distort unless all dials are set to what I perceive to be full!

Fair enough I take the point on the accuracy of figures. Works out at £8.50 of the licence fee per listener though based on 700,000 listeners. The BBC have a obligation to supply BBC Cymru. It is protected by the licence as a public service broadcaster - as are the local stations. Which all have their own new music shows funnily enough.

Half the people who will have joined a 'save 6music' facebook campaign which doubtless was set up a few days ago won’t have listened to the station in the last six months. The listener numbers are low, which is why the trust is looking to get rid. I believe the beeb are there to represent everyone, but there has to be a limit - we can't all have our own personal stations. I think a number of bbc stations have failed because of the pitiful uptake of DAB. If I’m in front of my computer, I'll spotify or play some of my gigs of mp3s. If I'm in the front room I have about 200 radio stations on sky and CDs to entertain. If I'm in the car, I have CDs, FM, AM and my mp3 player. If DAB worked better, and was more cost effective in the car, I'm not sure we would be debating the closure of 6music. I'm not suggesting DAB was a bad technology, it was just superseded within about a day by other digital platforms.

I'm currently also using R1softs CDP server. Found a couple of flaws but generally very good (just renewed support for another year at about £70 for three servers). We use a retired server with a raid5 array in another separate building. I would have bought new, but we will be virtualising before long, and we needed a solution quickly that wasn’t going to break the bank. It's still my intension to then archive the backups to a third building. Tapes are too much trouble these days imho.