DataLoad Community Forum Index DataLoad Community

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Remarks /REM

 
Post new topic   Reply to topic    DataLoad Community Forum Index -> Macro Load Support (.dld files)
View previous topic :: View next topic  
Author Message
rexgo



Joined: 20 Sep 2014
Posts: 6
Location: Chicago

PostPosted: Tue Feb 09, 2021 4:49 pm    Post subject: Remarks /REM Reply with quote

Is there a way to add remarks, so DL will ignore that cell? TIA
_________________
Frank / Chicago
Back to top
View user's profile Send private message
DataLoad
Site Admin


Joined: 15 Nov 2005
Posts: 231
Location: Dorset, UK

PostPosted: Tue Feb 23, 2021 4:10 pm    Post subject: Reply with quote

Frank,

No, that's not currently possible but we could add this feature. Would you want to set this up to skip entire columns (i.e. the same cell in every row) or just certain inividual cells (i.e. not in the same column on every row), or both of those?

Jonathan
Back to top
View user's profile Send private message Send e-mail Visit poster's website
rexgo



Joined: 20 Sep 2014
Posts: 6
Location: Chicago

PostPosted: Fri Feb 26, 2021 12:22 pm    Post subject: Reply with quote

Hi - I just want DL to ignore the individual cell with that command and continue executing the next cell. I would use it to describe what the next group of cells is doing.
example: *REM copy the item and paste the new price
_________________
Frank / Chicago
Back to top
View user's profile Send private message
DataLoad
Site Admin


Joined: 15 Nov 2005
Posts: 231
Location: Dorset, UK

PostPosted: Sun Feb 28, 2021 2:14 pm    Post subject: Reply with quote

Hi,

We've added this to the next release. In the Options window you can specify the comment prefix, e.g. REM, and then any cell with data that starts with that comment prefix is ignored/skipped during the load. You can also convert multiple cells to/from comments by selecting the cells, right clicking the mouse and using the appropriate option under "Convert To" on the pop-up menu. Please test this and let me know if it does what you want and if you find any issues.

The current build of the next release can be downloaded via the following link:

http://www.dataload.com/dlsetupv5500.exe

That's not the final build (but it's very close), so if you do download this version then please download the release build of V5.5.0.0 when that's available.

Thanks,

Jonathan
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DataLoad
Site Admin


Joined: 15 Nov 2005
Posts: 231
Location: Dorset, UK

PostPosted: Tue Mar 09, 2021 8:52 am    Post subject: Reply with quote

DataLoad V5.5 has now been released and contains this functionality.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DataLoad Community Forum Index -> Macro Load Support (.dld files) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group