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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 delete empty cells/empty rows		  New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

iggboert

Germany
7 Posts
Posted - 04/02/2009 :  10:08:00 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

Shirley_GZ

China
Posts
Posted - 04/02/2009 :  11:11:11 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Edited by - Shirley_GZ on 04/06/2009 10:58:41 PM
Go to Top of Page

iggboert

Germany
7 Posts
Posted - 04/03/2009 :  08:53:17 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Shirley,

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

Regards
Christoph
Go to Top of Page

g.sebastian74@yahoo.fr

Japan
8 Posts
Posted - 01/15/2025 :  08:22:11 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

g.sebastian74@yahoo.fr

Japan
8 Posts
Posted - 01/15/2025 :  08:49:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page
   Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000