Removing space's from a string of text with a paragraph

TDarrell9

New Member
Hi,

I have an issues with getting rid of spaces and having the text all on one line so I can match two data items, one is from a website and the other data source is from Excel. The first data im gathering has a paragraph line break from the website in the sentence, this needs to be matched to another data item from speadsheet, here it's not showing any paragraph I presume Excel doesn't allow you to have this in a cell.

Left is the website data and right is the excel, I have used Replace([Details Read - New], " ", "")

Does anyone have any ideas on how i can get the paragraph break removed within the string within Blue Prism ?

Thanks


View attachment 1553769397029.pngView attachment 1553769413169.png
 

TDarrell9

New Member
Thanks that has worked, ive got 2 calc first its Replace([Details Read - New], NewLine(), "") then Replace([Details Read - New], " ", "") and its correctly removing the new line. :)
 
Top