Sage 100

 View Only

  • 1.  VI Export remove comma from end of each line

    Posted 02-07-2024 13:42

    Hello, I have a VI export job where I need to remove the commas from the end of each line in the export file.. Usually I use this in perform logic below, but because all the fields I'm exporting are temp fields, there is no columns to choose from in perform maint. They need such a specific format that I don't think I can change it from not being a temp field for the last column. If anyone has any creative ideas it would be welcomed! Thank you.



    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------


  • 2.  RE: VI Export remove comma from end of each line

    Posted 02-07-2024 17:48

    Try this thread link

    VI Export adds extra comma at end of every line | Sage 100 (90minds.com)



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 3.  RE: VI Export remove comma from end of each line

    Posted 02-07-2024 18:39

    The "..\VI\VI_RemoveTrailingSep.M4P" perform logic worked for me when I set the "Perform Type" to the "Before Write" option.



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 4.  RE: VI Export remove comma from end of each line

    Posted 02-07-2024 18:48

    David Speck- that Before Write worked perfectly for me. I'm so grateful for reply. Thank you!!!!



    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------

    Original Message


Related Content