how take even shorting

[Julian_prince]

any one can help please Left hand side is original file and right hand side is  Result..

here file is also attached ...

[ChrissyC]

What exactly are you trying to accomplish? Do you want to get from the data on the left to the data on the right? Please be much more specific with your question.

Also, posting your code will help people help you!

-CC 

[ejkaiser]

Hi,

have you checked if the missing data shows up in columns 5 - 10? You can do that by making the results array indicator wider to show more columns.

To give a more specific advice we need to know what you are exactly doing with the data.

Cheers

Edgar

[Julian_prince]

i want  to take  all the colums which having  all the values and want to delet the row which having the single value and othere colums are balnk..

[johnsold]

Do you need to test the rows for zeros or do you  know that they are always the even numbered rows?

Do any of the rows with desired data have values near zero?  If so, how can you tell them apart?

Lynn

[ejkaiser]

You can use the 'Delete from Array' function inside a loop. Use the loop counter to define the row to be deleted and use a shift register or feedback node to feed back the reduced array for each cycle. Stop the loop as the counter reaches half the row number of the original array.

Cheers

Edgar

[johnsold]

Let me elaborate a bit.

In LV a 2D array cannot have blank columns in some rows and filled columns in others.  All rows must have the same length.  All columns must have identical lengths also, although they need not be the same length as the rows.  If you create an array by building it from arrays of different lengths, LV will pad the shorter rows with the default value for the data type (zeros in the case of numerics). So you do not have rows with single values and blanks.  You have rows with one non-zero value and 4 zeros.

Next, comparison to zero is tricky with floating point numbers because of the way numbers are represented in binary in the computer.  Due to round off errors in calculations, numbers which appear to be zero when viewed at a few significant figures may in fact be ~1E-15 and the =0? test will fail.

In your case the file contains "0" characters and you can probably get away with testing for zero, but it is a good practice to consider testing for "Approximately Equal to Zero."

Lynn