How to extract text before or after certain characters?

1

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?

2

Hi @yscias

in your case you can :

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

image
image736×346 21.6 KB

Please let me know if I misunderstood your point !

Have a nice Day

Quentin

2 Likes
3

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?

4

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

thisRow.Name.Split("(").Join("").Split(")").Join("")

image
image991×395 32 KB

1 Like
5

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