SplitPart() equivalent in Query, not Formula Column

I have a use case where I want to be able to reference the result of a splitPart concept as part of a join, and don't want to have to have two views (1 to pull the SplitPart as a formula column, the second to make use of the value).

Is there an inline query equivalent to splitPart() that isn't just combining string functions and position() calls to identify the delimiter?

EX: splitPart("Ford/Truck/F150","/",2) = "Truck" >> I've also tried some other syntax that I've found, no luck: split_part(), split()[index], etc.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Robb Carlson , have you tried  SUBSTRING_INDEX() function. that worked for me.

Like Follow
  • 7 mths agoLast active
  • 1Replies
  • 18Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.