Does anyone have any idea on how to imitate SQL TRIM functionality in Data Request within Orchestrator ?
I have a data request based on a UDC but my input isnt working because of all the spaces within the feild which makes it impossible to get the value i'm looking for.
You can map the output of the data request to an input in a groovy script and use the trim() function. I included a screenshot of a working example below.
You can map the output of the data request to an input in a groovy script and use the trim() function. I included a screenshot of a working example below. View attachment 19020
It's the same thing. You can map the input parameter directly to the groovy script and then use the output of the groovy script in a future step or output.
Thank you , sorry for the late reply I was on vacation .
With the trim it didn't work so i had to refer to Lpad which worked fine based on your script too
It's the same thing. You can map the input parameter directly to the groovy script and then use the output of the groovy script in a future step or output.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.