Search found 6 matches

by UncleBen
Mon Dec 22, 2014 8:11 am
Forum: Technical / Scripting
Topic: Compilation error 1033
Replies: 1
Views: 2046

Compilation error 1033

Hello! I've got an issue. ReadFile>%find_Var_1%,vData Separate>vData,lf,vLine let>n=1 Repeat>n Let>text=vLine_%n% StringReplace>%text%,","",text StringReplace>%text%,crlf,lf,text VBEval>LCase("%text%"),text <--- after this line Macro Scheduler is showing that error. Position>%find_Var_2%,%text%,0,nP...
by UncleBen
Mon Dec 22, 2014 8:05 am
Forum: Technical / Scripting
Topic: XML to CSV convertion
Replies: 5
Views: 5117

Re: XML to CSV convertion

Thank you everyone! You helped me a lot!
by UncleBen
Wed Dec 10, 2014 10:53 am
Forum: Technical / Scripting
Topic: XML to CSV convertion
Replies: 5
Views: 5117

XML to CSV convertion

Hello everyone! At the start I've to say that I've got Macro Scheduler 11 and i can't install newer version. I've got a problem with XML files. I would like to convert them to CSV files but I haven't got any ideas how to change every phrase between < and > to , . or nothing (whatever). In example I'...
by UncleBen
Thu Oct 16, 2014 8:52 am
Forum: Technical / Scripting
Topic: Ctrl-C doesn't copy to clipboard - SOLVED!
Replies: 12
Views: 12340

Re: Ctrl-C doesn't copy to clipboard

Add a little wait between press ctrl and send>c :)

if it still not working, then try to delete the 0 parameter. I mean GetClipBoard>fretText.
by UncleBen
Fri Oct 10, 2014 9:38 am
Forum: Technical / Scripting
Topic: How to sum up CSV column without excel
Replies: 17
Views: 21758

Re: How to sum up CSV column without excel

Hello everyone! Thanks for your replies. rblack - your solution is working pretty well but after few examples I've got a little problem. There is my example: "column1";"column2";2012-08-06;2012-08-06;;320,00;"column7;"column8";column9;"column10" I need to get the sixth column - "320,00" but the RegE...
by UncleBen
Thu Oct 02, 2014 12:57 pm
Forum: Technical / Scripting
Topic: How to sum up CSV column without excel
Replies: 17
Views: 21758

Re: How to sum up CSV column without excel

Hi there, I've got a similar problem. I do not have Office installed. I would like to sum up the seventh column in my csv file. This column doesn't have any caption. The solution that you provided breaks when there is a semicolon inside the double quoted in text any column before the seventh column....
cron
Sign up to our newsletter for free automation tips, tricks & discounts