Skip to Content
avatar image
Former Member

How to display the concatenated column value separately in each cell of Microsoft Excel

Hi There,

I am facing an issue while exporting the data (which is of concatenated columns) to Excel.

Currently I am having some data

for eg: 5/20/2016 8:46:42AM 5/20/2016 8:59:09AM 6/14/2016 11:26:02AM 6/15/2016 2:04:24PM 6/16/2016 3:58:18PM which sits in one cell of Excel while exporting.

I tried line break in my formula

whileprintingrecords; stringvar a1:=a1 + totext({IC3_ASSESSMENT.ASSESSMENT_END_DATE})+ " "

But still not working.

Note that out put should come as

cell1 cell2 cell 3 cell4 cell5

5/20/2016 5/20/2016 6/14/2016 6/15/2016 6/16/2016

8:46:42AM 8:59:09AM 11:26:02AM 2:04:24PM 3:58:18PM

Could you please suggest me any solution for getting this resolved

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 20, 2016 at 10:09 AM

    Hi Ginu,

    You'd need a formula for each cell.

    Formula for Cell 1 would be:

    Split({string field}, ' ')[1]

    Formula for Cell would be:

    Split({string field}, ' ')[2]

    And so on...

    Place each formula beside each other so that it generates a new cell when exported to Excel.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2016 at 02:08 PM

    Hi Abhilash,

    That didn't worked out.I have placed the new formulas adjacent to this formulae

    whileprintingrecords; stringvar a1:=a1 + totext({IC3_ASSESSMENT.ASSESSMENT_END_DATE})+ " " in Group footer section.

    --GS

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 02:12 PM

    What is the formula you used?

    Does it display blank?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2016 at 05:16 PM

    I have used the formulae1

    split(totext({IC3_ASSESSMENT.ASSESSMENT_END_DATE},","))[1].

    It was the same way dispalyed all together in one cell.

    But if we have so many records(concatenated data) do we need to write that much formulaes for sitting data in separate cell.Dont we have any dynamic ways to handle it?

    Add comment
    10|10000 characters needed characters exceeded