Bad symbols in text from word

Help Studio
1

Hi!
I get text from table in word, use table.Cell(i,j).Rang.Text and in string I get bad symbols.
How I can delete them? UiPath not see this symbols in Replace.
This is screen I get by save logs.
image

2

@Aleksey_M

You can copy entire text into a variable and use Replace Activity to replace the unwanted symbols

Also use write like below
StringVariable.Replace("Your Symbol", "")

Hope this helps you

Thanks

3

Yes, but this bad symbol not paste in Replace, I try do it.
I copy symbol from txt-log file and it not paste in Assign

Now I paste text with symbol in variable in Assign but not can save xaml, get error:
System.ArgumentException: ‘’, hexadecimal value 0x07, is an invalid character.

studio is crash))

4

@Aleksey_M

Can you share your project folder, then we can try

Thanks

5

output.txt (189 Bytes)
file with bad symbols

I put symbol in Replace, try Save xaml and get error:
image

6

@Aleksey_M
looks like the bell character

grafik
grafik729×68 10.9 KB

7

@Aleksey_M

Check as below

image
image785×514 19.3 KB

Thanks

8

Yes, it work! But how did you know the code of this symbol?

9

\a was hint enough to check out the ASCI Code for this char
Or
taking the first char from text (is it was \a) and using the ASC function return the code. see below
grafik

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.