Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

filtering rows for invisible special character 0x0b

aehrenwo
11 - Bolide

We are trying to identify when end users are pasting text into a field in SharePoint that is messing up our XML pulls. 

 

I can see that the characters look like this in one of my text editors <0x0b> but it essentially appears as a blank or box in SharePoint. 

 

is there a way to filter for any rows where this character appears in the field?  I have tried this

 

REGEX_CountMatches([Risk Category Description],'[\{0x0b}]')

 

and it is not working to isolate that row--- it is ONLY one where that value exists. 

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @aehrenwo 

 

Try this

 

REGEX_CountMatches([Risk Category Description],".*0x0b.*")

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @aehrenwo 

 

Can you provide some sample input and expected output it will help us get a better understanding.

aehrenwo
11 - Bolide

Yeah that REGEX didn't return any matches --- this is the field/row that has the character. 

 

Tester 8/6/2021 8:22 AM | test2 |

A conflict of interest create a risk that a decision may be unduly influenced by other /for personal benefit but negatively impact the company&#39;s reputation &amp; business performance.

 

The character is right before "A conflict".  

 

I want to count if that character appears at least once in the field. 

aehrenwo
11 - Bolide

This REGEX appears to partially work --- it finds some false positives as far as I can tell for some other rows but for the row in question the match count is much higher. Not sure why that is happening. As far as I can tell this character is ONLY in the field for one of the rows. 

 

REGEX_CountMatches([Risk Category Description], '[\0xb]') 

danilang
18 - Pollux
18 - Pollux

Hi @aehrenwo 

 

You can try this 

 

replace([Field1],CharFromInt(11),"")

 

CharFromInt() returns the character represented by the integer argument.  11 is the base 10 equivalent of x0B.  This should remove all the offending characters from your string.

 

Dan

aehrenwo
11 - Bolide

Ok got it.... this worked:

 

REGEX_CountMatches([Risk Category Description],'\x{00b}')

atcodedog05
22 - Nova
22 - Nova

Hi @aehrenwo 

 

Thats good to hear🙂. You can definitely give @danilang suggestion a try.

Cheers and have a nice day!

Labels