Showing posts with label delimiter. Show all posts
Showing posts with label delimiter. Show all posts

Friday, March 9, 2012

How to delimit in Derived Column Component

If there are two columns in a Derived Column Component, Is there a way we can put a delimiter between them say a '||' symbol or so and build an expression. All I was able to do was concatenate them.

[Col1]+[Col2]

thanks in advance.

You can specify a literal value, and concatenate, as shown below. Any help?

[Col1] + "||" + [Col2]

|||

Thx for the quick reply :) That was exactly I was looking for...