...
DataBridge supports transformations for import and export files. Data transformations can be added to import and export jobs.
Click here to view the article on Transformations for DataBridge Export.
Note: Transformations can now be chained together so the field created by a transformation can be further transformed. More info
TIP 1: Notes can be added to transformations to make their purpose clear.
...
Exactly 7 characters between parentheses \((.{7})\)
At least 1 alphanumeric character between parentheses \(([A-Za-z0-9]+)\)
Exactly 2 uppercase letters, exactly 5 digits between parentheses \(([A-Z]{2}[0-9]{5})\)
Exactly 2 uppercase letters, exactly 5 digits [A-Z]{2}[0-9]{5}
At least 1 letter followed by a comma and a space, followed by at least one letter and a space followed by a parenthesis then capturing 2 uppercase letters and 5 digits followed by a parenthesis [A-Za-z]+, [A-Za-z]+ \(([A-Z]{2}[0-9]{5})\)
Note: We support two scenarios: (1) regex without any capturing groups and (2) regex with one capturing group
(1) Anything that match the pattern will be used as the value (my example before the last example)
(2) The value in the capturing group will be uased as the value (all other examples)
...