- Posts: 28
- Thank you received: 0
Data joiner delimiter
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
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.
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
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.
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

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