Can't get rid of line that isn't there to begin with

[Short]

Hi all

My process is:

1. Pick up Supplier name from Supplier / Subcontractor Name on Sharepoint site
2. Enter the Supplier name into a new Sharepoint
3. Write back to Excel

This is step 1:

I’ve deleted most of the Supplier name on the screenshot but it’s all on one line, so there shouldn’t be an issue

This is step 2:

It’s missing out “(UK) Ltd”

This is step 3:

“(UK) Ltd” is on a new line, which makes me think that when it presses enter after “(B****)”, that’s why it’s missing out “(UK) Ltd” in step 2 - it’s pressed enter to move on to the next page.

This is my process for this part:

So my issue is… UiPath is putting a new line somewhere where there isn’t one, and then it isn’t let me delete the new line.

Can anyone point out what I’m doing wrong? Or how this can be fixed please?

Thanks

[yedukondaluaregala]

@Short

Can you give the details in the text type what is there in strSupplier variable
With that value what your are trying to do

just give the details what you are getting and what you are expecting

[Short]

Hello

What I’m getting (on two lines):

Excepting this value (all on one line):

[Short]

yourStringVar.Replace(vbLf,“”) solved it

[yedukondaluaregala]

Good to Hear!!

Happy Automation!!