Stack Overflow
Stack Overflow

Questions tagged [emptydatatext]

29 questions
213
votes
17 answers

How do I check if a SQL Server text column is empty?

I am using SQL Server 2005. I have a table with a text column and I have many rows in the table where the value of this column is not null, but it is empty. Trying to compare against '' yields this response: The data types text and varchar are…
atoumey
  • 2,536
  • 2
  • 20
  • 16
9
votes
2 answers

Client WCF DataContract has empty/null values from service

I have a simple WCF service that returns the time from the server. I've confirmed that data is being sent by checking with Fiddler. Here's the result object xml that my service sends.
Matt
  • 6,264
  • 10
  • 54
  • 82
7
votes
3 answers

Sorting (alphabetical order) to ignore empty cells : dataTables

So the question has already been asked here, but the solution doesn't work for me (I might do something wrong). I want to sort my tables by alphabetical order ("type" : "natural"), but I want the empty cells to be at the bottom (for desc and asc). I…
Fanch
  • 3,274
  • 3
  • 20
  • 51
5
votes
5 answers

EmptyDataTemplate and EmptyDataText not working in GridView

I can't seem to get either EmptyDataTemplate or EmptyDataText of a GridView to work. I'm fetching the GridView contents in de codebehind and attaching them with using DataBind(). I've tried having them as null and as an empty List, and in both cases…
Farinha
  • 17,636
  • 21
  • 64
  • 80
5
votes
3 answers

Gridview EmptyDataText="No data" - how to add style to the text 'No data'

I have a gridview control in my C# program and have just added an 'EmptyDataText' control that (as you know) displays a message if no records were found. When I view this page in design, the 'No data found' text is in times new roman and no style.…
Mike
  • 179
  • 1
  • 5
  • 11
2
votes
1 answer

Excel - How to leave cell blank instead of 0?

I'm not using a numerical formula. All I have is a simple reference to another cell. =(Sheet1!D8) If that cell is blank, I want to have the cell on this page blank too, not a 0. How do I do that? I want it to appear empty to anyone, not just me, so…
windbrand222
  • 31
  • 2
  • 2
  • 3
1
vote
3 answers

How to remove empty separators from read files in Python?

Here is my input file sample (z.txt) >qrst ABCDE-- 6 6 35 25 10 >qqqq ABBDE-- 7 7 28 29 2 I store the alpha and numeric in separate lists. Here is the output of numerics list #Output : ['', '6', '', '6', '35', '25', '10'] …
Rspacer
  • 2,369
  • 1
  • 14
  • 40
1
vote
2 answers

Text boxes inside EmptyDataTemplate not accessible

I have an ASP.NET GridView that uses an EmptyDataTemplate. Inside EmptyDataTemplate i am having some text boxes and a submit button for the insertion of records. When I try to access the ID's in the code behind file they are not showing up. My…
waris kantroo
  • 83
  • 3
  • 21
0
votes
2 answers

Cypress| How to count the number of non-empty rows in a table?

Please help me find a way to count only non-empty table rows. I tried to use it: cy.get("#TableId") .find("tr") .then((rows) => { rows.toArray().forEach((element) => { if (element.innerHTML.should('be.not.empty')) { …
Corica Vento
  • 1
  • 2
0
votes
1 answer

I have a CSV generated from CICFLOWMETER and I'm unable generate a correlation matrix It either generates a empty data frame

This is the code I'm using and I have also tried converting my datatype of my columns which is object to float but I got this error df = pd.read_csv('DDOSping.csv') pearsoncorr = df.corr(method='pearson') ValueError: could not convert string to…
Joveria
  • 1
0
votes
0 answers

Deleting empty columns with a few columns between data

I'm fetching data from a Google sheet: values1 = pd.DataFrame(values) aux = values1.head(1) values1.drop(index={0}, inplace=True) senal1 = (values1[2] == "SEÑAL") senal = values1[senal1] senal.dropna(axis=1, inplace=True) print(senal) This is my…
Iván David Rodríguez Amézquita
  • 1
0
votes
1 answer

calculate the number of rows in a column that meet certain criteria (specific word and empty rows) by using Panda

From data in a csv file, I try to obtain using Panda, the sum of the rows of a specific column ("Status_Issue") of the csv file that are: empty rows and rows containing the word "Pending". Here is the code I used but unfortunately it doesn't work,…
mollieda
  • 69
  • 6
0
votes
1 answer

Remove empty spaces created by null values in Chart.js

I have the following data in the following chart (with undesired empty spaces marked with blue arrows): const dataone = [1, 2, 5, 4, 2]; const datatwo = [2, 2, 3, 4, 5]; const datathree = [2, 3, 3, 2, 4]; const datafour = [null, null, 4, null,…
Pedro Relvas
  • 678
  • 7
  • 19
0
votes
0 answers

Empty multi files Notepad++

I have several types of files in the same folder. How do I edit all files then empty files, then save, then close all, with one click in Notepad++ ?
Mosaad Aljobair
  • 21
  • 1
0
votes
2 answers

How to make pandas read empty data file as an empty dataframe?

We can assign an empty dataframe with pandas. import pandas as pd zero = pd.DataFrame() zero Empty DataFrame Columns: [] Index: [] The zero dataframe is empty containing nothing in it,create a empty data file containing nothing in it. fh =…
showkey
  • 482
  • 42
  • 140
  • 295
1
2