Array, List or String?

HCL Domino Domino Forum
1

I have a field on a form that is populated from a selection of databases. The value in the doc prop looks like this:

Field Name: Filename

Data Type: Text

Data Length: 75 bytes

Seq Num: 1

Dup Item ID: 0

Field Flags: SUMMARY

““App\Dev\ACTION.NSF” “App\Dev\CONFIG.NSF” “App\Dev\LEADS.NSF””

Since this appears to be a text string, I used @Explode to get this:

Field Name: FilenameExplode

Data Type: Text List

Data Length: 75 bytes

Seq Num: 1

Dup Item ID: 0

Field Flags: SUMMARY

“App\Dev\ACTION.NSF”

“App\Dev\CONFIG.NSF”

“App\Dev\LEADS.NSF”

I am lead to believe this is a list or an array. So when I use this last field as a variant in my agent in LS, it pops up as a string. See below:

Dim item As NotesItem

Dim varList As Variant

varlist = currdoc.GetItemValue(“FilenameExplode”)

varlist in debugger actually says String as the datatype and shows this as a text string:

[0] - “App\Dev\ACTION.NSF; App\Dev\CONFIG.NSF; App\Dev\LEADS.NSF” - String

I am really confused…

2

Subject: Array, List or String?

If you define the field as ‘text’, then it’s a single string.If you define the field as ‘text’ and ‘allow multiple values’, then it’s an array.

3

Subject: RE: Array, List or String?

This was exactly what I was missing! Many thanks! Such a little thing can make such a big difference.

4

Subject: Array, List or String?

yes - it is a string:[0] - “App\Dev\ACTION.NSF; App\Dev\CONFIG.NSF; App\Dev\LEADS.NSF”

you may want to try including a delimiter in the @Explode.

@Explode(fieldname; “;”)

list version:

“App\Dev\ACTION.NSF”

“App\Dev\CONFIG.NSF”

“App\Dev\LEADS.NSF”

array version:

[0] - App\Dev\ACTION.NSF;

[1] - App\Dev\CONFIG.NSF;

[2] - App\Dev\LEADS.NSF";

lists are easily translated to arrays, because each item in the list can be assigned an “index”.

5

Subject: RE: Array, List or String?

Thank you for your response but I already had the delimiter but I was missing the multi-value checkbox as noted in Doug Finner’s post.