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 2
How do I extract the first part of the string of text that comes before " " or “(” ? Any ideas?
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.