Removing Unicode characters

Help Activities
, ,
1

Good day all, I have the bellow data that I am trying to pass on the API field:

The image displays a portion of text describing the details of a funeral claim case requiring additional information for resolution, including document clarity issues and deferred status. (Captioned by AI)
The image displays a portion of text describing the details of a funeral claim case requiring additional information for resolution, including document clarity issues and deferred status. (Captioned by AI)1285×143 16.3 KB

It keeps on failing because it has some Unicode characters (\u0007), so the API keeps on failing because of that. Anyone who can please help on removing these using regex maybe not just this one but any unicode characters which might likely also appear in the future and not only this one.

2

Error :

The image shows the source code of an HTML file detailing layout and style properties with a 'Request Error' title. (Captioned by AI)
The image shows the source code of an HTML file detailing layout and style properties with a 'Request Error' title. (Captioned by AI)1802×176 23.5 KB

3

Hi,

If you want to remove \u0000 style string, the following expression may help you.

System.Text.RegularExpressions.Regex.Replace(varStr,"\\u\d{4}","")

Regards,

1 Like
4

This is strange, the results on the output I don’t see any \u0007:

The image shows a detailed log of communication and billing history related to insurance coverage adjustments for a client's cellphone. (Captioned by AI)
The image shows a detailed log of communication and billing history related to insurance coverage adjustments for a client's cellphone. (Captioned by AI)1805×287 53.9 KB

But when I double cllick to show message details I see it:

The image shows a text snippet discussing a cellphone insurance policy adjustment and payment record. (Captioned by AI)
The image shows a text snippet discussing a cellphone insurance policy adjustment and payment record. (Captioned by AI)482×238 14.1 KB

5

Hi,

It seems actual data is \u0007 character.
For now, can you try the following expression?

System.Text.RegularExpressions.Regex.Replace(varStr,"\u0007","")

Regards,

1 Like
6

This is the flow:

image
image682×129 3.45 KB

The image shows a code segment using .NET's Regex.Replace function to perform text processing within a software workflow diagram. (Captioned by AI)
The image shows a code segment using .NET's Regex.Replace function to perform text processing within a software workflow diagram. (Captioned by AI)768×144 4.3 KB

then i output that Outcome2

7

it’s solved, thank you so much @Yoichi
I really appreciate your help

1 Like
8

FYI,

The following expression will also work.

varStr.Replace(ChrW(7),"")

Or if you need to remove character from \u0000 to \u0007, for example, the following works.

System.Text.RegularExpressions.Regex.Replace(varStr,"[\u0000-\u0007]","")

Regards,