Skip to content
+1-888-319-3663

COMMUNITY FORUM

Export Pipe Delimited file

Garrick Fischer asked 6 years ago
I need to setup my destination file as a pipe delimited file.
I only see csv and comma delimited.  is there a way to change the schemi for the export file?
Thanks
 
Answers
Patrick Roth Staff answered 6 years ago
Take a look at this article:
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 6 years ago

Thanks Patrick. That works. Only other thing would to be able to add column headers pipe delimited.

Terry Angel replied 3 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

Sharat answered 9 months ago
Patrick,
 
how to add the column names to the pipe delimited file.

If you would like to submit an answer or comment, please sign in to the eOne portal.