Stack Overflow
Stack Overflow

Questions tagged [blank-line]

Blank-Line refers to any existence of an empty line of data or the creation of an empty line on a form created by the *enter* or *return* keys.

Blank-Line, when referring to data, is used in the description of any record in a table/query where data does not exist. This could be in reference to creating a blank line of data, or determining where a blank line of data exists.

Blank-Line, when referring to a form, is used in the description of any line which contains nothing but white space. This could be in reference to shifting data downward or upward in a form or report, or shifting controls downward or upward in a form or report.

237 questions
1
vote
1 answer

Fill blank cells in pivot table as a reference to a value above

Messing with a pivot table and its behaviour. I have many categories describing each row, but for my own needs, I want to have every row's cell filled regarding its category. Not to have blank cells, as default, refering category name's cell. For…
Limak
  • 47
  • 1
  • 8
1
vote
2 answers

Multi-condition array formula having issue ignoring blank cells

I am trying to use an array formula to calculate a weighted average of a data in Excel set that contains blank cells but I'm confused why I am getting an error. I want to exclude two portion of the data depending the relative location to another…
WnGatRC456
  • 337
  • 1
  • 2
  • 12
1
vote
2 answers

Output Empty/Blank Line/Separation Line to Text file

I am data mining a log file and exporting information successfully. What I am looking to do is put a few blank, empty, or some kind of line separator between each export within the data mining criteria the script finds. I currently have: SET…
T-Diddy
  • 125
  • 1
  • 12
1
vote
2 answers

Python - Remove line with less than "x" number of characters while preserving blank lines

I'm opening a text file with columns and rows. Some rows have more characters than others and I am trying to delete lines that only have <# amount of characters. The file also contains some blank spacer lines that I need to keep preserved in the…
Jonathon
  • 251
  • 1
  • 7
  • 20
1
vote
1 answer

How do I completely delete a row with an empty cell in R?

I have an empty cell, but I want to delete it, even if there are cells (Even if it contains data) in the same row. As shown in the picture. textparcali$word[!apply(textparcali$word == "", 1, all),] Error in apply(textparcali$word == "", 1, all) : …
NCC1701
  • 139
  • 11
1
vote
1 answer

python: how to delete blank lines?

The input is designed to contain multiple lines of answer from the user, all the white spaces at the start need to be deleted, I have down that by using line.strip(). However, I cannot figure out a way to delete the input blank lines between each…
Weilory
  • 2,621
  • 19
  • 35
1
vote
2 answers

SSRS using vbcrlf in TextBox to Concatenate field need exclude blank return line

I've created an SSRS report to print per address. I am using vbcrlf to concatenate multiple fields in one text box. On some occurrences, one of the fields with in the concatenate might be null. If this is the case, the line returned creates a…
Abby
  • 83
  • 1
  • 10
1
vote
1 answer

How to hide blank rows from pivot-table so that the pivot-chart does not contain that row?

scenario: I have a pivot-table with years in rows and sales in values. Additionally I have sales as Difference to previous year (built-in pivot function "show as ...") in values. It works fine, but the first row in the pivot-table is blank for…
John
  • 35
  • 1
  • 7
1
vote
0 answers

Appending blank lines to paragraphs in Linux

I have a textfile that contains a story with many paragraphs and I want to print the story in the terminal, I also want to make it so when it finds a blank line in the textfile it adds another blank line to this in the whole story and print this as…
Taran Basi
  • 35
  • 2
  • 7
1
vote
1 answer

Matching blank lines in a file

1. What is the most robust way to match a blank line in a file? 2. What is the most efficient way to match a blank line in a file? 3. What are the differences between the following different ways to match a blank line? Context: I'm trying to…
mas
  • 1,155
  • 1
  • 11
  • 28
1
vote
1 answer

how to get rid of blank line in c++?

I'm trying to fill text document, but when I do - I get first line blank. My text document, I'm reading from, looks like this: 3 first fr random 5 second 9 third shazam 2 I've tried removing first value and so blank line went away. So…
Lizard Derad
  • 379
  • 1
  • 4
  • 21
1
vote
1 answer

sed delete block of lines after pattern1 to pattern2, but not the line matching pattern1 itself?

I am struggling to use sed to work through 'testfile.txt' and every time it encounters a line that starts delete_me: abc it will then: leave the line delete_me: abc intact but delete all the lines that follow until the next blank line is reached…
ClutchingatStraws
  • 39
  • 3
1
vote
1 answer

Why line != "\n" or line != "\r\n" or line !="\r" can't filte blank line?

Blank line contain only \n or \r\n or \r. tempfile = open(file,"r") for id,line in enumerate(tempfile): if(line != "\n" or line != "\r\n" or line !="\r"): print(id,line) Why blank line can be still printed?
user7988893
1
vote
0 answers

PhpStorm is leaving blank line between two PHPDoc comments, how to solve it?

PhpStorm is leaving blank line between two PHPDoc comments, I could not find it in settings.
Alisherbek Rakhimov
  • 66
  • 1
  • 8
1
vote
1 answer

Sort file numerically and preserve blank lines between entries in Bash

I am currently struggling at sorting data. I searched online and never saw any topics mentioning my issue... I have files with unordered data like: 1 blank line 3 blank line 2 Which have a blank line in between values. When I use my script, it…
spheex12
  • 29
  • 3
1 2 3
…
15 16