2 Replies Latest reply on Oct 17, 2017 4:40 PM by Cathy Bridges

    Seperating components of a combined field by a linebreak

    Andrej Schmelzer

      Hello,

       

      I have a hopefully simple question:

       

      I have created a combined field out of 2 database columns. If we would take the superstore example, it would be something like a combination of  countrycode and sales.subcategory, so the output looks like DE, furniture or SE, computers.

       

      The dialoge for creating a combined field lets me replace the "," with any other character, but I cannot put in a linebreak there. Neither /n nor char(10)  nor <char(10)> works in this context.

       

      I could get around there by instead concatenating the 2 fields in a calculated field and add the linebreak there, but my guess is that straight up combined fields should be quite a bit quicker and easier to maintain then a string concatentation.

       

      This should be really simple I hope.

       

      Cheers,

       

      Andrej