Hi,
May I know if there is any way to use LEFT_TRIM and RIGHT_TRIM together in an external file template?
I am trying to remove both leading and trailing spaces from the Account field in an external voucher upload.
When I apply both functions together, only the second function works.
For example, if I use LEFT_TRIM as the first function and RIGHT_TRIM as the second, only RIGHT_TRIM is applied, and LEFT_TRIM is ignored.
Thanks in advance.
Best answer by Furkan Zengin
Hello
In the second line try this way.
| Function No | Main Function | Argument |
|---|---|---|
| 1 | LEFT_TRIM | COLUMN_REF(ACCOUNT)," " |
| 2 | RIGHT_TRIM | DETAIL_REF(1)," " |
Alternatively you can use the following version
| Function No | Main Function | Argument |
|---|---|---|
| 1 | REPLACE | COLUMN_REF(ACCOUNT)," ","” |
Hope this helps
+21Hello
In the second line try this way.
| Function No | Main Function | Argument |
|---|---|---|
| 1 | LEFT_TRIM | COLUMN_REF(ACCOUNT)," " |
| 2 | RIGHT_TRIM | DETAIL_REF(1)," " |
Alternatively you can use the following version
| Function No | Main Function | Argument |
|---|---|---|
| 1 | REPLACE | COLUMN_REF(ACCOUNT)," ","” |
Hope this helps
Hello
In the second line try this way.
| Function No | Main Function | Argument |
|---|---|---|
| 1 | LEFT_TRIM | COLUMN_REF(ACCOUNT)," " |
| 2 | RIGHT_TRIM | DETAIL_REF(1)," " |
Alternatively you can use the following version
| Function No | Main Function | Argument |
|---|---|---|
| 1 | REPLACE | COLUMN_REF(ACCOUNT)," ","” |
Hope this helps
Thank you.
Both alternatives work for me.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
