How to extract text before or after certain characters?

Hi, Im wondering if there is a way or formula to extract text before or after certain characters? So for example like I’ve got a list of product names:

iPhone 14 (32GB)
iPhone 14 (64GB)
iPad Air (64GB)
AirPods Pro
AirPods Pro 2

How do I extract the first part of the string of text that comes before " " or “(” ? Any ideas?

Hi @yscias

in your case you can :

  • split around the character " ("
  • take the first part of this split, which is your iphone model

Please let me know if I misunderstood your point !

Have a nice Day



Thanks a lot, this is great! I didnt know split can be used with other characters!

Follow up question, is there an easy way to remove the “)” at the end, rather than doing another split?

You can use a combination of split and join in chain to remove the caracter you dont want :slight_smile:


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.