VisualCron is an Automation, Integration and Task Scheduling Tool for Windows.
Hi SupportSeems like with the introduction of V6.1 the Loop functionality with the Line Break character for dynamically assigning variables has stopped working.CheersAndy
Hi HenrikThe data is retrieved via SQL Query with Output defined as : Field Separator: 'Pipe' Line Break: 'Pipe' (although I have tried CRLF for Line break also).The 'Y' source is as follows (taken from STDOUT of the SQL Query task):1|1|01/02/2012 13:37:48|21/03/2012 16:52:43|1|xxINVPDF.PRF|v|andy.payne@mavensystems.co.uk|1|na|na|USERISIS\PPDE_JT.PRF|t|na|U|2||inkh8y0o|xxINV.SET||PB/006|0|COMP\PROD\|1|U:\@SPOOL\|trigger.rdy|b2p|XXPS.CFG|C:\@VC\Trigger||XX Invoice|d|*JT*.XML|COMP\PROD\OUTPUT\|0|1|COMP\PROD\|0|1|1|1|COMP\PROD\RECON\|XXINV|COMP\PROD\CTL\|U:\DATDEVThe LOOP is a FOR EACH IN Y, use Column 1, Field Separator: 'Pipe' Line Break: 'Pipe'Hope that is enough details?CheersAndy
© VisualCron