Forum Discussion

Brass Contributor

Jan 28, 2021

Solved

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 ...

SLalwani
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

Brass Contributor

Feb 01, 2021

SLalwani

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

Copper Contributor

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