We are using the Olympus Scan^R for high content screening of 96 well and 384 well plates, and I’d like to import the images into CellProfiler for analysis. The acquisition log produced by the Olympus software doesn’t seem to be compatible for deriving well position information from. For the sake of flexibility I would like to parse out the metadata from the file name, but am having trouble with the correct regular expression. Here is an example of the file names:
The most important features are the well (A1), the image position within the well (P00001), and the Channel (Alexa 488). The channel is an alphanumeric variable, typically one of four for each position in each well, but is always at the end of the file name. Any help would be greatly appreciated.