Skip to main content
Question

Replace function in an export scenario

  • December 23, 2020
  • 4 replies
  • 323 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 Support Analyst
    • 521 replies
    • 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
    • 16 replies
    • 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
    • 871 replies
    • 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
    • 16 replies
    • February 10, 2021

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

    Shmarya Richler

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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