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


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)?




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


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