Skip to main content
Question

Replace function in an export scenario

  • December 23, 2020
  • 4 replies
  • 355 views
shmaryarichler
Freshman II
Forum|alt.badge.img

Hi,

I want to use the replace function in an export scenario to replace the hex character 0A from the middle of a string with a blank. How would I code that in the replace statement? The field name is: Transaction Descr

 

Thanks

Shmarya Richler

    4 replies

    Irina
    Community Manager
    Forum|alt.badge.img+8
    • Irina
    • Acumatica Platform Analyst
    • February 9, 2021

    Helo @shmaryarichler, sorry for the long reply.

    Try the following:

    =Replace([TransactionDescr], ‘0A’, ‘’

    Best regards, Irina
    shmaryarichler
    Freshman II
    Forum|alt.badge.img
    • shmaryarichler
    • Author
    • Freshman II
    • February 10, 2021

    Thanks but it didn’t work. Here is what I did:

     

     

    Shmarya Richler
    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • February 10, 2021

    Hi @shmaryarichler 

    Please use this 

    =Replace([TransactionDescr], ‘0A’, ‘’)

    Hope this helps, 


    Regards,

    VijayKumarU
    shmaryarichler
    Freshman II
    Forum|alt.badge.img
    • shmaryarichler
    • Author
    • Freshman II
    • February 10, 2021

    Thanks. I tried that and it is still not working.

    Shmarya Richler
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved