Forum Discussion
John Dorrian
Jan 28, 2021Brass Contributor
Select text from split function
Hi hope someone can help, (I also hope I can explain this issue) I created a pipeline to bring in a CSV, stick it in blob storage and then modify it and stick it in a sql database. But while ...
- Feb 02, 2021
Hey John Dorrian , tried the expression builder and here you go.
Hope this is what you were looking for and I might have resolved your issue.
If so, kindly mark this reply as an answer or upvote here!
Thanks and regards,
Sunaina Lalwani
John Dorrian
Feb 01, 2021Brass Contributor
Thanks I did manage the split column part on the |, apologies I am a noob and couldn't find an index value from the list of expression elements.
I've looked at the "byitem" and "byname" functions but can't see how to get these to select the entry with @en in the string.
SLalwani
Feb 02, 2021Copper Contributor
Hey John Dorrian , tried the expression builder and here you go.
Hope this is what you were looking for and I might have resolved your issue.
If so, kindly mark this reply as an answer or upvote here!
Thanks and regards,
Sunaina Lalwani
- SLalwaniFeb 03, 2021Copper Contributor
John Dorrian, there is no such thing that I do for this, but whatever I need to do or want, I'll just figure out the possible functions and logic and then hit and try the possible functions in the mapping data flow.
You can follow https://docs.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions expression language as your reference guide.
Thanks and Regards,
Sunaina - John DorrianFeb 02, 2021Brass ContributorThanks for this I was miles of and making derived columns of derived columns.
Are there any resources you'd recommend using to get a better idea of what functions to use and when, or is it more a case of practice practice and practice with a lot of trial and error.
Kind Regards
John