Skip to Content
0
Former Member
Sep 07, 2011 at 05:45 PM

Extracting part of a string with a delimiter

2360 Views

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"