I’ve been working with macro scheduler for the last few days and have been able to almost complete my macro script. Before I purchase macro scheduler though I have a few questions regarding licensing and scripting.
Questions:
1 -How many computers can I install the software per license and how easily can I move my license from computer to computer.
2 - I have a loop in my script which allows me to get all folders within a folder.
Let>GFL_TYPE=1
GetFileList>C:\Users\temp\*.*,folder_list,;
Separate>folder_list,;,folders
If>folders_count>0
Let>fldr=0
Repeat>fldr
Let>fldr=fldr+1
Let>this_folder=folders_%fldr%
Until>fldr=folders_count
Endif
This returns the full folder path for the variable ‘this_folder’, but is there a way to return simply the folder name within this loop ? Thus putting something in the loop to simply return the folder name in a separate variable.
3 - The last issue I’m having with my macro is that I need to count the number of lines per file then append the number to the file name. is that possible?
Thank you for your time and your wonderful software.
license & Scripting Questions
Moderators: Dorian (MJT support), JRL
- Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Hi,
1. One per user (depends on how many licenses you buy)
2. Use the ExtractFileName function, or parse by "/"
3. Read a file in with ReadFile, count line numbers using RegEx or a repeat/until loop, construct filename with the result.
1. One per user (depends on how many licenses you buy)
2. Use the ExtractFileName function, or parse by "/"
3. Read a file in with ReadFile, count line numbers using RegEx or a repeat/until loop, construct filename with the result.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
can you demonstrate how to use extract file name to get a folder name?
Below is what i would do. Using stringreplace will help as you already know the starting folder path.
problem here is : Let>this_folder=tmp
the this_folder will be replace each time it go through the list, so i m assuming that theres additional code below that line.
stringreplace will replace the path c:\Users\temp\, in the folder_%fldr% with an empty value and assigned it to tmp, which you can then asssign to 'this_folder' to hold only the folder name.
Below is what i would do. Using stringreplace will help as you already know the starting folder path.
Code: Select all
Let>GFL_TYPE=1
GetFileList>C:\Users\temp\*.*,folder_list,;
Separate>folder_list,;,folders
If>folders_count>0
Let>fldr=0
Repeat>fldr
Let>fldr=fldr+1
stringreplace>folders_%fldr%,c:\Users\temp\,,tmp
Let>this_folder=tmp
//additional code???
Until>fldr=folders_count
Endif
the this_folder will be replace each time it go through the list, so i m assuming that theres additional code below that line.
stringreplace will replace the path c:\Users\temp\, in the folder_%fldr% with an empty value and assigned it to tmp, which you can then asssign to 'this_folder' to hold only the folder name.
i m not sure if this is what you are looking for for number 3 and you might have to play or google regex patterns,
Code: Select all
Let>GFL_TYPE=0
let>initFolder=c:\Users\Temp\
GetFileList>%initFolder%*.*,files,;
Separate>files,;,file
let>x=0
let>pattern=\r\n
repeat>x
add>x,1
ExtractFileName>file_%x%,fName
ExtractFileExt>file_%x%,fExt
StringReplace>fname,%fExt%,,fName
readfile>file_%x%,strFile
RegEx>pattern,strFile,0,matches,n,0,,,
let>newfile=%initFolder%%fname%%n%%fext%
RenameFile>file_%x%,%newfile%
Until>x=file_count