The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 delete empty cells/empty rows

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
iggboert Posted - 04/02/2009 : 10:08:00 AM
Origin Ver.: v8 SR4
Operating System: WinXP

Hi guys,

I programmed a filter that deletes the content of specific cells. Now i want to delete these empty cells/rows. Is there any possibility to quickly delete all empty cells/rows of a worksheet?

i tried a lot with the 'mark'-function, but did not get it to work.

thx in advance
Christoph
4   L A T E S T    R E P L I E S    (Newest First)
g.sebastian74@yahoo.fr Posted - 01/15/2025 : 08:49:50 AM
quote:
For more details, you can refer to this page


Please can you resend the link? It cannot be found.
I have a similar issue with data in columns A, B, and C. Some cells in C are missing and I want to copy the data in a new table, skipping all rows with empty C cells.

Thank you for your support!

guembou
g.sebastian74@yahoo.fr Posted - 01/15/2025 : 08:22:11 AM
quote:
For more details, you can refer to this page


Please can you resend the link? It cannot be found.
I have a similar issue with data in columns A, B, and C. Some cells in C are missing and I want to copy the data in a new table, skipping all rows with empty C cells.

Thank you for your support!

guembou
iggboert Posted - 04/03/2009 : 08:53:17 AM
Hi Shirley,

thx for your help. Worked right like i wanted it to work.

Regards
Christoph
Shirley_GZ Posted - 04/02/2009 : 11:11:11 PM
Hi Iggboert,

Let's assume that both two columns col(A) and col(B) in your worksheet have missing values, then you are try script as below
wxt "col(A)[i]==0/0||col(B)[i]==0/0" sel:=1; //Select the missing row.
menu -e 36442;  //Delete the select data range. It is equal to the Delete item in menu.


where wxt is an x-fucntion, which can be used in Labtalk script, and is used to extract the data, also can be used to select the data from worksheet. For more details, you can refer to this page.

Shirley

Originlab Technical Service Team

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000