import re
regex = re.compile(r"(?:(?:(^ *-? +)|(\d+ +cases?)|(Product\w+)|(\d{4})|(\$[\d,.]+)|(Warehouse +\w+)|(-[^-\n]+(?:-|$)))(?: +(?:of|at|in) +| +)?)+", flags=re.MULTILINE)
test_str = (" - 1 case of ProductA 2020 at $123,456.00 in Warehouse A\n"
" - 2 cases of ProductB 2025 at $123,456.00 in Warehouse B - optional remark\n"
" - ProductC - optional remark - 3 cases at $987,654.00 in 2050 in Warehouse C")
subst = "\\2\\t\\3\\t\\4\\t\\5\\t\\6\\t\\7"
result = regex.sub(subst, test_str)
if result:
print(result)
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Python, please visit: https://docs.python.org/3/library/re.html