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!
-
Congratulations gkittelson 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: *
- Users: ScottWDieterle
- Order by date
-
Combine 2 columns in .VSB
WORKED GREAT! THANKS SO MUCH YOU SAVE ME SOOOOOOO MUCH TIME!- ScottWDieterle
- Post #7
- Forum: VBScript
-
Combine 2 columns in .VSB
This worked but now the output file has no commas in it? set objFSO = CreateObject("Scripting.FileSystemObject") set objInput = objFSO.OpenTextFile("C:\reports\classdataFile.csv", 1, true, 0) set objOutput = objFSO.OpenTextFile("C:\reports\classdatfile1.csv", 2, true, 0) do while not...- ScottWDieterle
- Post #5
- Forum: VBScript
-
Combine 2 columns in .VSB
it is a .csv file that looks like this Scott,Dieterle,219,N,Hale,Ave The file comes out of a program that I run, I have to strip the first comma manually in excel Need a script to just strip off the first comma I will create a .bat to move the file to an FTP site- ScottWDieterle
- Post #3
- Forum: VBScript
-
Combine 2 columns in .VSB
I have a .CSV file and I am trying to combine the first 2 columns. IE input Scott,Dieterle,219,N,Hale,Ave Output ScottDieterle,219,H,Hale,Ave Any help would be appreciated. I am new to .bat and .vbs and trying to learn as I go!- ScottWDieterle
- Thread
- Replies: 6
- Forum: VBScript
