Hi @arkiboys ,
you can specify the characters in the second option of ltrim() function. you can try something like:
ltrim(rtrim(companyRef), ': ')
Thanks!
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
in ADF dataflow, I am ingesting several columns...
One of them is called, compantRef which may or may not have leading or trailing spaces...
Using a derived column transformation, I remove any spaces before or after the companyRef column.
expression currently used --> ltrim(rtrim(companyRef))
Question:
some of the records may have values such as :
companyRef
----------
companyxyz
companyURT
company54RTR
: companyEE21
...
I would like to remove the colon if it is present infront of the companyRef and remove the space too.
How can I achieve this?
Thank you
Hi @arkiboys ,
you can specify the characters in the second option of ltrim() function. you can try something like:
ltrim(rtrim(companyRef), ': ')
Thanks!
Hi @arkiboys ,
Thanks for the ask.
You can use trim() instead of ltrim() and rtrim().
For your scenario, you can try something like below as @Nasreen Akter mentioned.
Trim(Trim(companyRef),':')
Inner trim will remove leading and trailing spaces and outer trim will remove colon. Try out and let us know please.
Thank you.