Concatenating Multiple Columns with Commas and Spaces
SummaryTrying to concatenate multiple columns in OBI Recruiting Legacy
I'm trying to concatenate multiple columns with spaces and commas in OBI Recruiting Legacy. Below is my current formula that I'm trying to use as an example and the output I wish to have.
CONCAT("Candidate Location of Residence"."Candidate Country Of Residence","Candidate Personal Information"."Candidate Address Line 1","Candidate Personal Information"."Candidate Address Line 2" )
To make things more complicated I’m trying to insert a “,” and space between each column so that my output looks like:
United States, California, Corona, 1234 Apple Drive
The way we did it in BO was, we concatenated each column with a comma first and then concatenated all 4 separate formulas into one concatenation formula.