on 11-19-2008 1:40 PM
Hi,
Simple question for you guys - trying to understand concatenation correctly.What is the output if 2 source fields have mulitple elements eg:
Is:
Field1
Joe Blogs
Field2
21 Normal Road
Simply concatenated to:
Target
Joe Blogs 21 Normal Road
Thanks
This is really very simple..
Yes, the output will be like that only but without any space..
Why don't you try this on your machine before posting it.
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you have got the ans, then make this thread as answered.
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
By default if you do not set any delimeter, there will not be a space between your 2 fields. Experiment and try out first before posting.
Thanks
Saiyog
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
There is an option for a delimiter in the Concat function, if you set it to the default [], the output would be Joe Blogs21 Normal Road.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.