Data joiner delimiter

More
12 years 6 months ago #1955 by Marc
Data joiner delimiter was created by Marc
Hello

I would like to join customer address fields using comma + CR+LF
so far I was able to produce using joiner
adddress1,adddress2,adddress3,adddress4

but I need something like this:
adddress1,
adddress2,
adddress3,
adddress4

I am thinking about using calculation but wandering if there any more elegant solutions?

Marc

Please Log in or Create an account to join the conversation.

More
12 years 6 months ago #1956 by Marc
Replied by Marc on topic Re: Data joiner delimiter
There is a much simpler solution for your data transformation.

use Ensure suffix for first three address lines + joiner

See the picture attached

Peter
Attachments:

Please Log in or Create an account to join the conversation.

More
12 years 6 months ago #1957 by Marc
Replied by Marc on topic Re: Data joiner delimiter
Yes, you are right it is much easier. :)

Mark

Please Log in or Create an account to join the conversation.