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

Question

Question

Issue splitting one single-value field to two multi-value fields?

asked on June 23, 2023

I have this single-value field containing document number, revision, and a carriage return:

I am using pattern matching to extract each document number and revision and place it in a multi-value field:

and

Works great! Here is my issue. When I track the data, my document number field is find, but my revision field has a undesired carriage return between each one:

Any ideas on how I can remove that field?

0 0

Answer

SELECTED ANSWER
replied on June 23, 2023 Show version history

Solve my own problem! For LRRevisionMULTI, I changed the pattern to R(\d{1,3}) and that worked!

Now I can move on.

1 0
replied on July 14, 2023

Yep, your (.+) regex was grabbing the carriage return. (\d{1,3}) prevents that. Nice work.

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.