Hi! I have a column called [Name/Date/Comment]. In this, users will write…
Nick B. - 12/02/2021
blah blah blah
Is there a way to only get the “blah blah blah” with an expression? Sometimes, the date is written differently, like these possibilities
Dec 12, 2020
Dec 12,2020
Dec 11/12 2020
Dec 12 2020
Dec 11&12, 2020
When I used the extract dates function with an index of “1” to get the first date in the [Name/Date/Comment] column, it was able to pick a date out of all of those possibilities above.
Is there a way to only get the blah blah blah? I tried…
Index(Split([Name/Date/Comment],Year(today())),2) in an email template, but it told me that I was using the split function incorrectly. Should I be using a different function, maybe substitute() ? Thanks!