| number of visible rows into macro saving variable [message #2271] |
Tue, 06 August 2024 14:12  |
juliocoll
Messages: 35
Registered: January 2023
Location: Madrid SPAIN
|
Member |
|
|
dear Thomas,
When working with many different and long dwar files, it will be very helpful to automatically include the visible or total number of rows into their saving name files. I am doing it manually now and often run into some confusions.
For instance: In one XXX experiment, a file of 3356_XXX rows is filtered to 2459_XXX rows and then with another filter to 1567_XXX rows, etc, etc. All nth files require independently saving n names maintaining the same XXX label to differentiate those from other experiments.
Perhaps their corresponding visible number or total number are included into some variables (as they show up at the bottom of the DW) that could be added to saving into the macros either at the fileName=#ask# command, or at the following fileType=dwar command.
Perhaps something like:
fileName=Visible + #ask# or
prefileName=Visible or
something else............?
Thank you for your help and attention,
sincerly
julio
Julio Coll
Profesor de Investigación. Emérito
Dpt.Biotecnología
CSIC-centro Nacional INIA, Madrid, SPAIN
Dr. Biologia Univ.Comp(UCM). Madrid, Spain
PHD. Biology Mass.Inst,Technol (MIT). Massachusetts, USA
orcid: 0000-0001-8496-3493
|
|
|
|
| Re: number of visible rows into macro saving variable [message #2360 is a reply to message #2271] |
Fri, 20 December 2024 09:56  |
juliocoll
Messages: 35
Registered: January 2023
Location: Madrid SPAIN
|
Member |
|
|
In numerous attempts to automatically get a row number to be included into the dwar file name (to be saved inside a DW macro), I got the following "best behaviour":
<macro name="SaveRowCount">
<task name="defineVariable">
name=rowcount
</task>
<task name="showMessage">
message=$rowcount
</task>
<task name="saveFileAs">
fileName=E:\$rowcount.dwar
fileType=dwar
</task>
</macro>
The rowcount name was kindly provided by Norwid B as one of the defined dwar file properties. The showMessage confirms the new name of the file which is then saved on the included dir.......
However, everytime I need to type the rowcount value and give any dir address in the fileName. I would like those to be automatically included to avoid any mistakes !!!!
I tried alternatives to use getRowCount( , PROPERTY_LINE_COUNT, lastRow, etc,.. No sucess.
Any ideas?
MERRY CHRISTMAS !
julio
Julio Coll
Profesor de Investigación. Emérito
Dpt.Biotecnología
CSIC-centro Nacional INIA, Madrid, SPAIN
Dr. Biologia Univ.Comp(UCM). Madrid, Spain
PHD. Biology Mass.Inst,Technol (MIT). Massachusetts, USA
orcid: 0000-0001-8496-3493
|
|
|
|
Search
Help
Members
Register
Login
Home
