Tuesday, March 15, 2016

Smartconnect - Export to a Pipe delimited file

http://www.eonesolutions.com/blog-post/creating-fixed-length-output-file-smartconnect/



  • Use a calculated field to combine all of the values into a large string delimited by pipes
    • return _ITEMNMBR + "|" + _ITEMDESC + "|" + _ABCCODE + "|" + _USCATVLS_1 + "|" + _UOMSCHDL + "|" + _ITEMCODE

    • Export only that calculated field to your file as the first column
    • Disable headers

    No comments:

    Post a Comment