Question

Replace function in an export scenario

  • 24 December 2020
  • 4 replies
  • 152 views
S
Rank

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
Userlevel 7
Badge +7

Helo @shmaryarichler, sorry for the long reply.

Try the following:

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

Best regards, Irina
S
Rank

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

 

 

V
Rank
Userlevel 7
Badge +8

Hi @shmaryarichler 

Please use this 

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

Hope this helps, 


Regards,

VijayKumarU
S
Rank

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

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 — 2022  Acumatica, Inc. All rights reserved