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.
Solved! Go to Solution.
Hi @aehrenwo
Try this
REGEX_CountMatches([Risk Category Description],".*0x0b.*")
Hope this helps : )
Hi @aehrenwo
Can you provide some sample input and expected output it will help us get a better understanding.
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's reputation & business performance.
The character is right before "A conflict".
I want to count if that character appears at least once in the field.
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]')
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
Ok got it.... this worked:
REGEX_CountMatches([Risk Category Description],'\x{00b}')