Export Pipe Delimited file
Garrick Fischer asked 8 years ago
I only see csv and comma delimited. is there a way to change the schemi for the export file?
Thanks
Patrick Roth Staff answered 8 years ago
http://www.eonesolutions.com/blog-post/creating-fixed-length-output-file-smartconnect/
it is fixed length but the same principle applies in that you would just add the delimiter you want in between the fields and you don’t need to do the padding stuff.
but otherwise pretty much the same principle.
Patrick
eone
Garrick Fischer replied 8 years ago Thanks Patrick. That works. Only other thing would to be able to add column headers pipe delimited.
Terry Angel replied 5 years ago Garrick – I’m know I’m 3 years late to your party, but here’s how I did the same thing. I needed to sub the default comma delimited output file to be semicolon delimited (VB script task code). This reads the original file (skipping the header line), then writes the new header to new file, then loops through writing the original file lines to new file as-is.
dim HeaderInfo as string = “Company code;Vendor number;Invoice number;Payment date;Payment method;Payment reference”
dim objReader as New System.IO.StreamReader(inFileWithPath)
Dim objWriter as New System.IO.StreamWriter(outFileWithPath)
objWriter.WriteLine(HeaderInfo)
Do While objReader.Peek() <> -1
If x = 0 Then
line = objReader.ReadLine()
Else
line = objReader.ReadLine()
objWriter.WriteLine(line)
End If
x = x + 1
Loop
objReader.Close
objWriter.Close