Export multi-value field into Excel

HCL Domino Domino Forum
1

I do a db.Search to get the collection and then write these to the excel spreadsheet, worked wonders until I noticed that about 4 fields are mult-value and it is only brining in the first value.

Is there a way to get all the values of the mult-value fields into one column?

2

Subject: Export multi-value field into Excel

One way you can do this is to use Implode on the multi-value fields before you export them to excel. HTH.

3

Subject: Export multi-value field into Excel

Here’s what I do…

You said column, but I think you meant “Cell.”

If you want to separate the values with a comma but put them all in the same cell, do this:

Delimiter = ", "

YourStringVariable = Join( NotesDoc.GetItemValue( YourMultiValueFieldName ), Delimiter )

If you want to separate the values with a new line but put them all in the same cell, do this:

Delimiter = Chr(10)

YourStringVariable = Join( NotesDoc.GetItemValue( YourMultiValueFieldName ), Delimiter )

Note: Chr(10) is a Line Feed – use that instead of a Carriage Return Chr(13) which will put a funny-looking box in your cell.

Hope this helps.

Gary