Formatting Clipboard Data when fields not labelled

Questions and Help
1

Hey there! I'm trying to use the Clipboard function to auto insert booking information that looks like this:
e.g. "Clio Manage Training on Friday, April 16, 2021 9:15 AM (Canada/Eastern)"

To something like:
e.g. "Your Clio Manage Training is scheduled for Friday April 16th at 9:15 AM Eastern."

What function can I use so TB knows when to start and stop each part of the clipboard sentence? The number of characters of the first part (e.g. "Clio Manage Training") can vary based on the type of call booked.

Hope this makes sense!

2

Hi!

You could try something like this. Depending on how variable your messages are, it may or may not work great.

{clip="Clio Manage Training on Friday, April 16, 2021 9:15 AM (Canada/Eastern)"}

{=replace(replace(replace("Your " & clip, " on ", " is scheduled for "), "(Canada/Eastern)", "Eastern"), ", 2021", " at")}