How to read .dat file with strange delimiter

[Daniel_hdq]

Hi I have a .dat file and tried to use Alteryx to read it. But I could not find a way to get this kind of delimiter in Alteryx. 

Could you help me on this?

When I open the file in notepad, it shows "EM" as delimiter. 

[rbarco]

Looks like the character that are appearing is due to encoding format.

If you could, post a sample file data to check it.

[Daniel_hdq]

Thanks, 

I could not attach .dat file here. I transferred it to excel file.

[rbarco]

Hi @Daniel_hdq 

Using the excel file I see another character (_x0019_)

So, using this file I've created a possible solution.

Please see attached file.

Hope this helps you!

[jaswindertaank]

This solution seems to focus on a different file vs. what OP posted.

OP posted a file that had small rectangles showing up in the data, whereas this solution splits data with the "x0019" string in it.

Do we have a solution that splits the file that OP is using?