filtering rows for invisible special character 0x0b

[aehrenwo]

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. 

[atcodedog05 · Accepted solution]

Hi @aehrenwo 

Try this

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

Hope this helps : )

[atcodedog05]

Hi @aehrenwo 

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

[aehrenwo]

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]

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]

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 · Accepted solution]

Ok got it.... this worked:

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

[atcodedog05]

Hi @aehrenwo 

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

Cheers and have a nice day!