Skip to main content
Question

Replace function in an export scenario

  • Dec 23, 2020 11:04 PM UTC
  • 4 replies
  • 404 views
  • Translate All

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

4 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • Feb 9, 2021 4:58 PM UTC

Helo @shmaryarichler, sorry for the long reply.

Try the following:

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

Translate

shmaryarichler
Freshman II
Forum|alt.badge.img

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

 

 

Translate

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Feb 10, 2021 12:58 PM UTC

Hi @shmaryarichler 

Please use this 

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

Hope this helps, 


Regards,

Translate

shmaryarichler
Freshman II
Forum|alt.badge.img

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

Translate