Range from Excel file getting copied to notepad with a blank space

[Karunamurthy (Karunamurthy Narasimhan)]

Hi,

In my project, one of the activity is to copy range from excel file to a notepad to the end of the document without space before already existing value. I am able to copy the range to notepad (see activity screenshot) but a space is created (See screenshot). How to copy the values without space (Highlighted in yellow)?

Regards,
Karunamurthy

[Anil_G (Anil Gorthi)]

@Karunamurthy

Try using name_Society.Trim

Also it is worth checking if there is a empty value already in the text file…if so just read the text file and then use str.Trim and then write text file activity with str.Trim and then perform append

cheers