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

Extracting part of a string with a delimiter


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.


"Communication | 6. Invites feedback, discussion and/or suggestions about his/her own ideas and assumptions"