Re: REGEXP Issue

[Phillip Ward]

Quote

The data in each row is a mix of numbers, letters and some special symbols

... and that "format" is called JSON. See https://www.w3schools.com/whatis/whatis_json.asp
JSON a structured data format (a bit like XML but with less "noise" characters). it is entirely possible for the same Key-Value pair to appear in multiple places and, by doing so, mean completely different things.

As a Rule, do not parse JSON data using Text tools.
Use a JSON-aware technology to extract the data properly and insert it into your tables.

Regards, Phill W.