topic Deleting empty rows in Notepad in Product Forum

Deleting empty rows in Notepad

SIVA_TEJA_YADAV — Wed, 12 Dec 2018 15:49:00 GMT

I have few empty rows in the notepad and the rows count will be close to 5000. I need to have a notepad file removing the empty rows. Please suggest me the best approach to remove the empty rows from the Notepad file Thanks, Siva Teja

Hi Siva, Not sure if there's…

david.l.morris — Thu, 13 Dec 2018 07:53:00 GMT

Hi Siva, Not sure if there's an easier way, but the below works and it's fast. Step 1: File Management VBO - Read All Text from File Step 2: Decision stage checking this: InStr([Text],NewLine() & NewLine())>0 Step 3a: If Decision is True/Yes, replace the double NewLine characters with a single NewLine character set using this: Replace([Text],NewLine() & NewLine(),NewLine()) Step 3b: Loop back to the Decision stage Step 4: lf Decision is False/No, use File Management VBO - Write Text File to put the data back in the file without empty rows. I tested this just now with 10k rows just in case. Dave

You can also use the String…

AmiBarrett — Tue, 08 Jan 2019 02:01:00 GMT

You can also use the String.Replace method in C#, using escape characters for your blank lines. https://docs.microsoft.com/en-us/dotnet/api/system.string.replace?view=…

RE: Deleting empty rows in Notepad

Hemachanderrao — Fri, 24 May 2019 08:00:00 GMT

Hi,
If it is a csv file, I woul read it as a collection ( File Management VBO -> Get csv text as collection ) and use collection manipulation VBO to remove all blank rows.

------------------------------
HEMA CHANDRA RAO SIDDANI
RPA solution consultant
Amesto Account House
------------------------------