Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


mpnieland
2013-10-16T19:31:31Z
I'm wondering if the Variable screen could be expanded to allow for custom functions (say in .NET) to be created.

This would be truly powerful as I could write snippets of code that do useful operations then access them from the variable editor.

The main function I want to make is a parse string function. That would allow me to easily take the standard output of a SQL query (for example), and do something like so:

{STRING(Parse|1111,222,33|,|2)}

To return the 2nd value in the source string separated by the , character. Or another example:

{STRING(Parse|1111 222 33|\t|3)}

Return 3 where the string is tab delimited.

Parse would be an extremely useful string tool in itself, but I'm requesting something even more powerful in custom functions. If you could figure out a way to add snippets of .net code (or another language) and turn those into functions that can be re-usable, that'd be great.

I'm aware I can use the .NET code execute task to perform some of this, but that's not as useful as having it directly accessible in the variable functions.

Please consider this feature to be added to VisualCron in the near future. If custom is dreaming too big, I'd settle for just parse!
Sponsor
Forum information
Support
2013-10-16T19:45:36Z
A nice idea. I am not sure if that is what you are looking for but the latest beta have this function:

{STRING(GetColumn|2|2|,|1,A
2,B
3,C)}

It allows you to pick a certain column in a rowset based on rowNumber, colNumber and column separator (in this case comma).
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top