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
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
Helo
Try the following:
=Replace([TransactionDescr], ‘0A’, ‘’
Hi
Please use this
=Replace([TransactionDescr], ‘0A’, ‘’)
Hope this helps,
Regards,
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.