identifying left leading digits and symbols for removal (required for example for cleaning units of measure)

^([A-Z]{4})\-([A-Z]{3})\-([A-Z]{1,7})\-([A-Z]{4})\-(\d{3})$ ^([A-Z]{4})\-([A-Z]{3})\-([A-Z]{1,7})\-([A-Z]{4})\-(\d{3})\([A-Z]{1})\([[:alnum:]])([[:alnum:]]{3})\_([[:alnum:]])([[:alnum:]]{3})$

in this example the substring is Crude Oil

Get filename, version number, extension

0 = not an authorized dealership for the respective brand 1 = authorized dealership for the respective brand

Encontre o primeiro nome em um arquivo CSV com múltiplas colunas

Datetime for a different formats

Validate and capture different dates without words for example: dd/mm/yyyy, d/m/yy, yyyy-mm-dd, yy-mm-dd