Question

Concatenate multiple tokens into single line

Workflow

Updated September 25, 2023

asked on September 22, 2023

I am retrieving document text using regular expressions to create tokens, and am wanting to combine those tokens into a field in a single line with spaces between the values (this is for an address).

Our tokens are;

Address

City

State

Zip

I am trying to have them entered into a field in this format:

123 Main St. Hometown WA 98274

The format that I am getting no matter what I try is:

123 Main St.

Hometown

98274

Can anyone point out what I'm missing or need to do?

0 0

Replies

replied on September 25, 2023

In your workflow, once you've pulled the address lines with your Pattern Matching regex, use a Token Calculator to Concatenate the values together into a new string

In this case I've create a NewAddress Token

%(Address)&" "&%(City)&" "&%(State)&" " &%(Zip)

0 0

replied on September 25, 2023

Thank you for the suggestion, Steve. We ended up finding that the use of \n when creating our tokens from the document text was the cause of the problem. We changed it to \r and were able to get the format that we desired.

1 0

replied on September 25, 2023

How are you concatenating them? Just placing tokens in a single line field should achieve what you need: %(Address) %(City) %(State) %(Zip)

0 0

You are not allowed to follow up in this post.

Question

Question

Concatenate multiple tokens into single line

Replies

Sign in to reply to this post.