Sage 100

 View Only

  • 1.  SUB() command Visual Integrator

    Posted 04-20-2021 13:53
    I have lost my cheat sheet of the correct syntax for a  SUB command in a VI import job.    I want to replace the pipe | symbol with the quote mark " .  Can someone please give me the correct syntax?  

    SUB(Temp001$), |, "

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------


  • 2.  RE: SUB() command Visual Integrator

    Posted 04-20-2021 13:56

    You said quote but used the " character so below is what you would use.

    SUB(Temp001$,"|","""")

    If you needed to replace with the single quote, it would be this.

    SUB(Temp001$,"|","'")​


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: SUB() command Visual Integrator

    Posted 04-20-2021 14:01
    Here's a new cheat sheet for the substitute command copied from the pvxplus web site:



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 4.  RE: SUB() command Visual Integrator

    Posted 04-20-2021 14:20
    Thank you @David Speck II and @Doug Higgs!  

    @Robert Wood This can get moved out of urgent.​​​

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------

    Original Message


Related Content