How to read .dat file with strange delimiter

Question

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.

jaswindertaank · Answer

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?

rbarco · Answer

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!

Problem dat file (excel).yxzp

Daniel_hdq · Answer

Thanks,

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

sample.xlsx