Search found 70 matches

by deesloop
Tue Dec 05, 2023 4:08 pm
Forum: General Discussion
Topic: Email addresses with variables
Replies: 2
Views: 9598

Re: Email addresses with variables

Yes, it worked for sure. I had used {sendto}@mydomain.net and although my string manipulation was working I couldn't get it to work
I created a new task and it worked first time so can only assume I had done something daft.

Thanks for your quick response
by deesloop
Tue Dec 05, 2023 12:13 pm
Forum: General Discussion
Topic: Email addresses with variables
Replies: 2
Views: 9598

Email addresses with variables

Is it possible to use variables in email addresses?? I want to grab the first few characters (based on the position of a "-" delimiter) of a filename and assign that text to a variable sendto then send an email to {sendto}@mydomain.net It fails every time with a bad email address but the a...
by deesloop
Tue Nov 14, 2023 5:45 pm
Forum: General Discussion
Topic: Replace file content in a CSV
Replies: 4
Views: 11001

Re: Replace file content in a CSV

Surplus line breaks are any line breaks that are not at the end of a row I've sent a copy of the file I would upgrade but support for VBA is very important for me and I dont want to take the risk that something will break. It toook me ages to get the routine working and it has done so for at elast 5...
by deesloop
Tue Nov 14, 2023 5:01 pm
Forum: General Discussion
Topic: Replace file content in a CSV
Replies: 4
Views: 11001

Replace file content in a CSV

I'm having issues importing a CSV through MS VBA in excel. Turns out folk have used commas within cells & also used linebreaks too. I'd like to replace all commas in the cells and remove the line breaks With the file being a CSV I cant just replace commas so thought of Replacing "," wi...
by deesloop
Wed Aug 17, 2022 10:51 am
Forum: General Discussion
Topic: Robotask reporting incorrect path length error.
Replies: 1
Views: 1726

Re: Robotask reporting incorrect path length error.

OK. I created a robotask task which tried to just moved the files (Ren*.pdf) from server 1 to server 2 and it too failed with the same error code.
However I created a windows batch file that worked no problem.

It's definitely not a path length problem.
by deesloop
Mon Aug 15, 2022 12:02 pm
Forum: General Discussion
Topic: Robotask reporting incorrect path length error.
Replies: 1
Views: 1726

Robotask reporting incorrect path length error.

I have a folder c:\invoicesscantest It has multiple subfolders each 6 characters long. janiza ketlem lynwil stequi PDFs are sent to these folder via ftp and by end users drag & dropping, and the files are then renamed. That all works fine However I then want to move them to the corresponding sub...
by deesloop
Mon Nov 29, 2021 3:33 pm
Forum: General Discussion
Topic: Renaming files
Replies: 2
Views: 2299

Re: Renaming files

OK so the issue comes as it tries to rename all files.
I updated the loop to calculate a name and assigned to a variable and that works
by deesloop
Thu Nov 25, 2021 4:18 pm
Forum: General Discussion
Topic: Renaming files
Replies: 2
Views: 2299

Re: Renaming files

So I;ve come up with this. But its stil creating duplicate names of files and appending a (1) 8 files in the folder, 123 files created in teh destination folder. ;***************************** ;* RoboTask Task file ;* Do not edit in text editor! ;***************************** [Root] ActionAfterRun=I...
by deesloop
Thu Nov 25, 2021 1:03 pm
Forum: General Discussion
Topic: Renaming files
Replies: 2
Views: 2299

Renaming files

I have a watched folder and PDFs get dropped into the subfolders of that folder. I want to rename the files and copy to another folder using random nubmer in the filename was planning in using Move to do this It works ok but all files are the same random number. and so all files are called 1234, 123...
by deesloop
Thu Nov 25, 2021 12:41 pm
Forum: General Discussion
Topic: Error after migrating to Hyper V
Replies: 2
Views: 1681

Re: Error after migrating to Hyper V

I can confirm that Oleg once again sorted the issue.