Gender format looks strange

Question

Hi, I created a workflow using the sample data that comes preinstalled with Alteryx. "TutorialData.yxdb" is the sample database which contains a field named "Gender" however the format looks strange (see image of table).

Why is the data formatted that way in the Gender column?

Gender

*~~//*~~//female

*~~//*~~//male

TutorialData.yxdb

mceleavey · Accepted Answer

Hi @Coder ,

I have no idea, but you can remove it by placing a regex tool in the line after the first tool and select the Gender field:

Copy and paste the characters you want to remove into the yellow section in the regex tool.

That will then remove them for you.

M.

mceleavey · Accepted Answer

@Coder ,

sorry, wrap it in square brackets:

[*~~//*~~//]

Coder · Accepted Answer

Thanks M! I will use the regex tool to remove it.