Multi-character column delimiter not supported in ADF connection

Question

My text file has a delimiter with 2 characters (~*).

However ADF supports column delimiters with only one chararacter. Any help or workaround?

It is a text file present in Azure blob storage which needs to be imported to SQL database.

Answer 1

As of Dec 4th 2021, ADF now has the option for a multiple character delimiter on a copy data activity:

See below example for where delimiter goes: