Sage 100

 View Only
  • 1.  VI Job for Ascii export file...Sage 100 premium 20

    Posted 01-07-2015 11:09
    VI Job for Ascii export file...Sage 100 premium 2013. My export job is adding extra spaces to the end of the row prior to the CR/LF. It needs to be capped at 122 characters and it is generating like 160. any ideas on how to remove the extra blank spaces after the last field?


  • 2.  RE: VI Job for Ascii export file...Sage 100 premium 20

    Posted 01-07-2015 11:42
    Is ""Pad Exported Fields with Spaces"" checked under Options? If not, try creating a calculated temp field using STP(field1,R,*"" "").


  • 3.  RE: VI Job for Ascii export file...Sage 100 premium 20

    Posted 01-07-2015 12:51
    Thanks for the tip on the options. Will look there first. then apply the STP syntax if needed.