Using Word() or Words() function to parse string in a column
Hello all, I have a table where one of the columns had data that is in the form of an alphanumeric string (e.g. 1bc5ef-gh7) and I would like to parse the string using the hyphen as the delimiter and they return the first part of the string (1bc5ef) as data in a new column. So far, I have the code below. If I use the Words() function, it only returns the second part of the of the string (e.g. gh7)....