How to remove the blank or empty cells in the channel

[Kandukuri_raghavendra]

I have few channels, which are blank or empty(0), is there a way to remove this 0 and shift the data up? PFA

[markwkiehl · Accepted solution]

Multiple solutions to your question have been posted on my website at this link:  http://www.savvydiademsolutions.com/view.php?topic=view-panel-manual-data-manipulation 

You could also approach the problem by filtering the data, using the View panel Flags (http://www.savvydiademsolutions.com/view.php?topic=view-remove-channel-spikes ), or by using the DIAdem Event Search (http://www.savvydiademsolutions.com/analysis.php?topic=postprocess-event-search-results ). 

I hope this helps.  If if does, please mark it as "Solved".  

[gsklyr]

Call DataBlDel(ChnList, ChnRow, ValNo, [ValDelOnly])

http://zone.ni.com/reference/en-XX/help/370858P-01/comoff/databldel/ 

Call DataBlDel(Channel, 1, 21)

[Kandukuri_raghavendra]

it wont be 21 empty cells every time, it would differ 

[gsklyr · Accepted solution]

Dim Channel, zeroCount, i
Set Channel = Data.Root.ChannelGroups([name]).Channels([name])
zeroCount = 0

For i = 1 To Channel.Size Step 1
  If Channel.Values(i) = 0 Then
    zeroCount = zeroCount + 1
  Else
    Exit For
  End If
Next

If zeroCount > 0 Then
  Call DataBlDel(Channel, 1, zeroCount)
End If