Search results for query: *

Thanks jges, that's worked. Thank you very much. cssql

Thanks for all the help. Will give that script a try. No I wanting it to look at the content and not the filename. Sorry new to VB.

Hi this is what I used Dim sName Dim fso Dim fol ' create the filesystem object Set fso = WScript.CreateObject("Scripting.FileSystemObject") ' get current folder Set fol = fso.GetFolder("C:\test1") ' go thru each files in the folder For Each fil In fol.Files ' check if the file name...

Hello all I need to remove some spaces from a csv and possbily a footer at the bottom. I've tried using some vbs script but none are working. Can anyone help. This is the example of how the csv file looks:- 50229020 ,0000033139 43760028 ,0000039153 and this is how I want it to look...

Apologies. I've put this on the worng forum.

Thanks. sorry the output actuall looked looked like 50229020 ,0000033139 and I wanted it to look like 50229020,0000033139 and also remove the (11305 rows affected)

Hello all I need to remove some spaces from a csv and possbily a footer at the bottom. I've tried using some vbs script but none are working. Can anyone help. This is the example of the vbs script:- 50229020 ,0000033139 43760028 ,0000039153 51582016 ,0000056292...