Extracting text from a column of strings

[#1]

Hello,

I am a bit of a novice when it comes to scripting in JMP, and I am trying to write a script that would be able to extract specific numbers from a string and create new columns for each one. Each number would always follow the characters 'DX' or 'DY' For example:

D113U_NTCH_CM_MEAS_CD_SEM_{2UM_X6_NTCH_CM_IMAGE}_DX7DY11SDX11SDY15_2024-12-06_18-57-42.jpg

I would want to extract and create these columns:

Of course, I would like to repeat this process over an entire column of data. I'd appreciate any advice. Thanks!

[#2]

Do you know beforehand all the possible patterns (DX, DY, ....)? Is it always located in the same place (after }_ and before date)?

[#3]

If I had a column full of those filenames, I would do a Cols -> Recode, top-left Red Triangle -> "Replace String", and then enter "S?D[XY](\d+)" and replace with "%\1%" with "Use regular expressions" turned on.  Then you can split the column (Cols -> Utilities -> Text to Columns...") and enter "%", which will give you 6 new columns, with the prefix, DX, DY, SDX, SDY, and suffix, e.g.:

Column 1 2	Column 1 3	Column 1 4	Column 1 5	Column 1 6	Column 1 7
D113U_NTCH_CM_MEAS_CD_SEM_{2UM_X6_NTCH_CM_IMAGE}_	7	11	11	15	_2024-12-06_18-57-42.jpg

Then you can rename the columns to DX, DY, etc.

If your real data is more complicated this process might need to be a bit more complicated as well.

[#4]

Nice : )
maybe start with 

word(8, filename,"_")

such that it works as well for lot DX11A.