Question

Replace function in an export scenario

  • 24 December 2020
  • 4 replies
  • 264 views
shmaryarichler
Rank
Userlevel 2
Badge

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

shmaryarichler
Rank
Userlevel 2
Badge

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

Shmarya Richler
V
Rank
Userlevel 7
Badge +11

Hi @shmaryarichler 

Please use this 

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

Hope this helps, 


Regards,

VijayKumarU
shmaryarichler
Rank
Userlevel 2
Badge

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

 

 

Shmarya Richler
Irina
Rank
Userlevel 7
Badge +8

Helo @shmaryarichler, sorry for the long reply.

Try the following:

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

Best regards, Irina

Reply


Terms & ConditionsCookie 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