Best way to remove line breaks and blank spaces from a string

[Rafaeloneil (Rafael Souza)]

Good afternoon people,
I would like to check with you what is the best way to remove line breaks and whitespace from a string.
I’ve tried several alternatives but I have not had success yet
I’ve exported my string to the Execution Log to see how it looks.

This is my String:
“\n---------------201900000020496\n---------------”

Hyphens “-” represent the whitespace
“\ n” represent line breaks

How UiPath Captures Element Text:

How the Element displays the text:

I tried treatments like LTRIM() and RTRIM() but it did not work

Can you give me an orientation?

[lakshman (Ganta lakshman)]

@Rafaeloneil

Try this:

String Str = "\n 201900000020496\n "

            Str.Replace("\n","").Trim

[Palaniyappan (Palaniyappan P)]

Hi buddy @Rafaeloneil
Instring = " \n 201900000020496\n"
Better one is this, the reason is it will remove all the newline in a paragraph and make them as single line…this can be used for a paragraph as well…
stringResult= Regex.Replace(instring, “\t|\n|\r”, “”)
Or
StringResult = instring.Replace(Environment.newLine,“”)

Hope this would help you buddy @Rafaeloneil
Cheers @Rafaeloneil

[Palaniyappan (Palaniyappan P)]

@Palaniyappan

Better one is this, the reason is it will remove all the newline in a paragraph and make them as single line …this can be used for a paragraph as well…
stringResult= Regex.Replace(instring, “\t|\n|\r”, “”)

or if its just a space we can use trim method of string class buddy
like this if your get text is stored in a variable of name intext
then
intext = intext.ToString.Trim

Trim is a method that would trim both the trailing and leading empty spaces of a string
where the method that were used previously like LTRIM and RTRIM mentions LEFT TRIM and RIGHT TRIM…that would trim only in the specific direction like either before or after the string buddy, thats why that didn’t work
Fine this would work for sure or
Any issues still buddy @Rafaeloneil

[lakshman (Ganta lakshman)]

@Rafaeloneil

If you want to trim

Before of the string then use: StringName.TrimStart

After the string then use: StringName.TrimEnd

Before/After or in between of the string then use: StringName.Trim

[Palaniyappan (Palaniyappan P)]

were you able to trim out the blank space buddy @Rafaeloneil

[KannanSuresh]

You can use regular expression to remove whitespace characters.

\s matches any whitespace character (equal to [\r\n\t\f\v ])

New Regex("\s").Replace(inputString, "")

Dim InputString = vbCrLf & "        201900000020496" & vbCrLf & "                  "
Dim CleanedString = New Regex("\s").Replace(InputString, "")

[anil5 (Anil Kumar Bandam)]

Hi @Rafaeloneil,

So from your string you can remove new lines or line breaks (or)
you can just take the digits from your string.

Use the below expression, which will just take the digits from the input string and remove anything other than digits.

Regex.Replace(“\n---------------201900000020496\n---------------”,“[^\d]”,“”)

[Michael_Udhaya (Udhaya Kumar P)]

@Rafaeloneil, you simply use the Assign activity with your string. strMyString = strMyString.Replace(“\n”, “”).Trim()

[Rafaeloneil (Rafael Souza)]

@Michael_Udhaya

strMyString

Hello Friend, yours and all the above suggestions worked, however besides treating the string I need to assign it to a cell of my DataTable:

When Assigning my treated string to a cell in my DataTable is a warning:
Cannot Assign from type ‘System.String’ to type ‘UiPath.Core.GerericValue’ in Assign Activity ‘Assign’

[Michael_Udhaya (Udhaya Kumar P)]

@Rafaeloneil, so you just modify the code with this
“strMyString = strMyString.tostring.Replace(”\n", “”).Trim()

When you use the Generic Value you have to change it’s type as String for string manipulations.

[Rafaeloneil (Rafael Souza)]

Hi buddy’s
I already solved the problem, my field in the table had to be changed to string instead of number, from that point the assing worked.
Many thanks to all for the help