Concate Function

[mur76]

Hi,

I need to Concatenate two fields and display the result.
But in between two fields, I need to separate them with :

Here is the example what Iam looking for:


Syntax: Concatenation(Proj_title,tpr_num)

But, I want divide the two atrributes with special character as ":", How Do I get ?

 

[skrandel]

Are you trying to do this at the database level? or in a report?

Steve Krandel
VERITAS Software

 

[BrianTyler]

mur76 ?

At the report level, I tend to use & as a concatenation operator.

e.g.
Create a variable with the formula-
Proj_title&" : "&tpr_num

I am assuming that tpr_num is a character field, otherwise you will have to convert it to character using FormatNumber

Regards

Brian

 

[mur76]

Thanks Brain..works fine.

 

[vaass]

=Concatenation(Concatenation(<State> ,":") ,<Store name>)

Example of concatenating State with Storename, in this case both the columns are of same data type...in case if you are concatenating different data type columns then you have convert them to an uniform format and then do the concatenation