How can I parse data that has the Escape square character in it?

Hi all,

I'm working with a dataset I am trying to parse out, but I'm not sure how to parse out this symbol. I've attached a screenshot of it below. There's the square Escape character and the number 3 I am trying to parse my columns by. Any ideas on how to do this?

Annotation 2019-04-12 133336.png

Datasets

Developer

Input

Reporting

Regex

Preparation

Data Investigation

Accepted answers

Sorry:

(.*?)\x{0003}3(.*?)\x{0003}3(.*?)\x{0003}3(.*)

Change the expression, the last "?" character in RegEX is unnecessary.

Cheers,

All comments

Hi @hydrogurl01

Could you please post a sample of your data? At least one line containing the square character.

We could extract the ASCII or Unicode Character of this square to remove it with regex or even regular replace function.

Cheers,

Hi @Thableaus ,

I've attached some sample data here. I've never used ASCII or Unicode before so any detail on that would be helpful!

Sample Data Alteryx.xlsx

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703