How to use substring method for non-consistent wording?
Hi, Anyone know how to solve my issue? I want to seperate this wording into two part. For example S810-001, I want to separate it to S810 and 001, for SAX260-001, separate it to SAX260 and 001. Currently, I just use substring method. but i don’t know how to find the symbol “-” between the two parts because the wording is not consistent.