Error in Map pre task 'BUILDFILE': expression expected
Hello
i am getting 3 errors when validating a pre-map script file. I am converting a
Error in Map pre task ‘BUILDFILE’: expression expected
Error in Map pre task ‘BUILDFILE’: Type ‘StringBuilder; is not defined
what am i missing?
here is my script:
i am getting 3 errors when validating a pre-map script file. I am converting a
Error in Map pre task ‘BUILDFILE’: expression expected
Error in Map pre task ‘BUILDFILE’: Type ‘StringBuilder; is not defined
what am i missing?
here is my script:
Dim sourceFolder As String = “C:\temp\ZZ”
Dim ArchiveFolder As String = “C:\temp\ZZ\Success\”
Dim DestFile As String = “C:\temp\ZZ\SrcFile\ZebraData.csv”
‘ stringbuilder to hold the data
Dim sb As New StringBuilder()
‘ create a new header row
sb.AppendLine(“SUBSID_INV_NUMBER,AR_CLIENT,BLANK,InvDate,InvAmt,Field1,Field2,Field3,FileName”)
‘ get each sourcfile in folder
For Each fi As FileInfo In New DirectoryInfo(sourceFolder).GetFiles(“*.txt*”)
Dim prefix As String = fi.Name.Substring(0, fi.Name.IndexOf(“_”))
Dim srcFile As New Object
‘read all data in file into an object
srcFile = System.IO.File.ReadAllLines(fi.FullName)
‘read each line in file, split the comma-separated values, reassemble as quoted values
For Each line As Object In srcFile
For Each str As String In line.ToString().Split(“,”)
sb.Append(“””” & str & “””,”)
Next
sb.Append(“””” & prefix & “”””)
sb.Append(vbCrLf)
Next
‘move sourcefile to an archive
fi.MoveTo(ArchiveFolder & fi.Name, True)
Next
‘overwrite existing file with my new data – Smartconnect will read this file using odbc
System.IO.File.WriteAllText(DestFile, sb.ToString())
Return True