• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Picklist - Dissecting Picklist Entries

Hi there!

In our software, The Raiser's Edge, there is a field where you can pick multiple text entries in the one field.  These entries are then exported as a whole unit.  

For example Name1; Name2; Name3; Name4

Is there a way to dissect each into their own fields?  (similar to selecting the delimiters for a csv file).

Any help is greatly appreciated!

cms
0
rporter45
Asked:
rporter45
  • 2
1 Solution
 
mlmccCommented:
Sure.

Try this

Split({YourField},";")[1]

SPlit will convert the list into an array and you can then access the individual elements.

A formula like this
Name - CreateArray

WhilePrintingRecords;
Global StringVar Array NameList;
NameList := Split({YourField},";");
""

You can then use formulas like this to get the first name

EvaluateAfter({@CreateArray});
Global StringVar Array NameList;
NameList[1]

To avoid issues with an array that has only 1 name
EvaluateAfter({@CreateArray});
Global StringVar Array NameList;
If UBound(NameList) >= 2 then
    NameList[2]
Else
    "No name2"

mlmcc
0
 
rporter45Author Commented:
Hooray!!! I will try this with my most recent request and get back to you!

Thank you,
cms
0
 
rporter45Author Commented:
Works perfectly!

Thank you very much!
cms
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now