Hi. Is there a function that can take the string below, and extract EITHER everything to the left OR the right of the " | " separator? I have many string fields with the same format and need to split them apart. They all contain the same separator but I haven't come across anything that works.
Thanks.
"Communication | 6. Invites feedback, discussion and/or suggestions about his/her own ideas and assumptions"