I am new in regex, i want to break the give string into 6 parts using regular expression. I am using the Pentaho data integration tool (ETL tool)
Given string: 1x 3.5 mL SST. 1x 4.0 mL gray cap cryovial.
Note: There are many more string with same format
Thanks in advance !!
Use
split
function and regex\. | mL |x
The single string datum you've given looks like it should match the regex pattern:
You can use it with
Regex Evaluation
step: