sed -i ‘/^$/d’ foo This tells sed to delete every line matching the regex ^$ i.e. every empty line. The -i flag edits the file in-place, if your sed doesn’t support that you can write the output to a temporary file and replace the original: sed ‘/^$/d’ foo > foo.tmp mv foo.tmp foo If you … Read more
Your pattern seems alright, you just need to include the multiline modifier m, so that ^ and $ match line beginnings and endings as well: /^\s*\n/gm Without the m, the anchors only match string-beginnings and endings. Note that you miss out on UNIX-style line endings (only \r). This would help in that case: /^\s*[\r\n]/gm Also … Read more
Use String.trim() method to get rid of whitespaces (spaces, new lines etc.) from the beginning and end of the string. String trimmedString = myString.trim();
This does exactly what you are asking, checks the rows, and inserts a blank empty row at each change in column A: sub AddBlankRows() ‘ dim iRow as integer, iCol as integer dim oRng as range set oRng=range(“a1”) irow=oRng.row icol=oRng.column do ‘ if cells(irow+1, iCol)<>cells(irow,iCol) then cells(irow+1,iCol).entirerow.insert shift:=xldown irow=irow+2 else irow=irow+1 end if ‘ loop … Read more