If I have a text field on a transaction that is written like "textA-textB" (will always have that dash in between the two distinct text sections), is there a way to split that up via workflow? I.e. the field called "memo1" has the value "textA-textB" and the field "memo2" is blank and I want to write a workflow (or script if there is no other way) so that "memo1" says "textA" and "memo2" says "textB." For context, I'm stuck with it this way because of a limited integration with a third party system. This was the only way to send info I absolutely needed to NS so now I need to figure out how to get the second part of that info into the correct field. Thank you!

I would think this could be done via workflow.

Thanks, Kevin! I've at least figured out the right formulas to split the text fields in a search and have successfully gotten one of the fields to split up in the workflow. Now to figure out the next one. I think I'm (surprisingly) on the right track!

you might use workflow fields in the middle

That's exactly what I did - it was my first time using workflow fields and I was surprised by it actually working! What I'm struggling with and didn't think about when I wrote my original question is memo2 is actually supposed to be a List/Record type of employees and not actually a text field. So I'm now trying to figure out what to do about that. But I am making progress!