How to search for a special character in a excel file using alteryx

I am looking understand, if there is a way , once excel file is imported to alteryx i can check if lets say "#" is available within any of the cells thats imported. based on that check i am looking to create a column with appropriate comment such as "special character found"/"special character not found"

Data Investigation

Accepted answers

DavidP

Hi @hegdepavithra10

I would look to transpose all fields, then use a filter tool on [value] to find the special character and do a record count. If record count > 0 then you have found the special character.

find special character in dataset.yxmd

All comments

wdavis

Hi @hegdepavithra10

Yes, this is definitely possible. Just so I understand correctly, would the new field be based on any of the fields for a record containing that character, or would all fields need to contain the character?

If this is the case, please check the sample workflow attached to see if this would work in your instance!

Kind Regards

Will

Character Check.yxmd

hegdepavithra10

Lets say i have an excel file called abc.xlsx and Sheet 1 from it is what i have imported on to Alteryx. Lets say it data across 10 columns and 10 rows. I want to know whether "#" is there within this data.

PS: I do not want the range where the search is made to be static.

smoskowitz

Hi @hegdepavithra10 --

Yes, you can do this. Either using a Formula tool or a multi-field Formula tool. Formula if you want to check one column and multi-field formula if you wish to check multiple columns.

Thanks,

Seth

DavidP

Hi @hegdepavithra10

I would look to transpose all fields, then use a filter tool on [value] to find the special character and do a record count. If record count > 0 then you have found the special character.

find special character in dataset.yxmd

hegdepavithra10

Hi, would it possible for you to attach snippets of the workflow with the formula you have attached. I am out of free trial and I am not able to view the workflow. Thanks in advance

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703