You are viewing limited content. For full access, please sign in.

Question

Question

regular expressions to remove values

asked on March 16, 2022 Show version history

I have document's that come over named: "Document Name-Name of Firm".

I need to segregate name of firm (via Assign Token Values) so that my token value is just: "Name of Firm"

Any suggestions with the token editor on how I do that?    

 

 

0 0

Replies

replied on March 16, 2022

Are the document name and name of firm always separated by a hyphen?

 

If so, you'd want to use Pattern Matching to grab the name of firm.  The pattern would look something like this:

 

[^\-]+$

 

You than then use an Assign Token Values activity to reference that token created via Pattern Matching.  You might want to use the Trim function in the Assign Token Values activity to remove any potential leading spaces in the Name of Firm (if there are spaces after the hyphen).

 

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.