Determine or Assign
Microplate Well Names to Positions
When multi-position
data sets are opened the
Multi-Dimensional Open dialog will attempt to identify a
well name or position number within the position name, if such is
provided by the data sets or the metadata within. Well names and
position numbers are essential for ordering results in microplate
format in the
Excel Data Window.
This is controlled by the
Plate
tab of the dialog. By default (
Determine
from Position Name and
Use the best matching pattern are checked), the
dialog will attempt to successively match the position names as well
names, position numbers or position letters, and take the first
pattern that matches all positions. Well names, position numbers or
position letters are defined as parts of the position name with no
neighboring alphanumeric characters.
To automatically detect well names in position names (default):
- Click Determine from Position Name
- Checkmark Use the best matching pattern
for full automatic detection
- Optionally select from the list the best matching item
To manually set up well names along a grid:
- Click Reassign
- Set the numbers of columns and rows
- Optionally set the well name of the top left corner (Start
at)
To manually set up well names one by one:
- Go to the Open tab
- For each position press the pencil button at the top of the
dialog end enter a well name
- In the Plate tab checkmark
Determine from Position Name
and Use the best matching pattern
To customize the well name / position number detection (for advanced
use only, needs regex knowledge):
- In the Auto detect well names box
of the Plate tab select the most
similar pattern and check Show as Regex
- Define named capturing groups using the field names provided
below:
- (?<row>[a-zA-Z]{1,2}) : use this for row letters
- (?<col>\d{1,4}): use this for column numbers or position
numbers
- (?<letter>[a-zA-Z]{1,2}): use this if positions are
letter coded.
- Get help here to build your regex: e.g.:
www.regex101.com (use
pcre)