I have created a script which imports data from Excel to a Notes database. It works just fine, but one of the columns in Excel contains several values seperated by ; How can I, using script, “loop through” all the values in the Excel column and then import them into a single field in Notes with new line as seperator?
Thanx
Subject: Importing multivalue column from Excel
You can use the Split function to break the value up into an array.
How to get it into Notes depends on what you’re after. If you’re adding them to a single-value text field, use the Join function to glue them back together with new lines (chr$(10) + chr$(13), or something like that). If you’re adding them to a multi-value text field, use AppendItemValue to attach the entire array to the field.
Subject: Fairly easily. Create the field on your form, Allow Multivalues.
On the third tab select Separate when user enters SemiColon or NewLine, then Display separate values with NewLine