Is there a way to Split Cells with a Delimiter from the Right position in a cell? For example, the cell contains the value "1-800-Endoscope-29869". I need to segregate the data into separate columns with the values "1-800-Endoscope" and "29869" respectively.
Hi @JWelch and welcome to the Community!
You can use the keepafter() function with a negative position, for instance:
keepafter("1-800-Endoscope-29869", "-", -1) // returns 29869
1 Like
Thanks. What Action do I select in order to enter the function?
Use the "Calculate column(s)" action to create a new column, or "Modify column(s)" to replace an existing column.
Check out also these tutorial articles:
Thank you for all of your help while we explore the capabilities. In the previous example, what function would I use to remove "-29869" from the name? Is there a way to segregate the values into 2 columns or a substitute function that removes "-29869" from the cell?
The keepbefore() function would remove the last part:
keepbefore("1-800-Endoscope-29869", "-", -1) // returns "1-800-Endoscope"
You can combine keepafter() and keepbefore() to extract only the parts you need. For instance,
keepafter(keepbefore([A],'-', -1), '-', -1)
The full reference for EasyMorph functions is available here: syntax:functions [EasyMorph Help]
That worked. Thanks.