Hello,
I found several similar posts, but the documented solution didn't work for my program.
Here's my CSV file opened in Notepad:
"JF7","10192006","ARP","0.4"
The file would be good if I could drop all of the "
Here's my string values, I tried the ("""""", """") but didn't make a different (I had to use double quotes around old value and new value to avoid error about quot not being declared)
CompanyCode = "JF7"
strCurrentDate = CurrentDate.ToString("MMdyyyy").ToString
strCurrentDate.Replace("#", "")
strCurrentDate.Replace("""""", """")
RegHrs = dsADP.Tables("tblTA_ADP_Hrs").Rows(i)("Regular_Hours").ToString
Here's my file creation:
WriteLine(1, CompanyCode, strCurrentDate, Emp, RegHrs)
Please help!
Thanks,
Jon
Dim inFile As String = "c:\jb\custom programs\adp\adp.csv"
Dim outFile As String = "c:\jb\custom programs\adp\PRJ7FEPI.csv"
File.WriteAllText(outFile,