Writing to CSV or Flat File without Rowset

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
2 posts Page 1 of 1
Post Reply

jlee1

Posts: 12
Joined: Mon Jun 22, 2015 12:41 pm
Post by jlee1 » Mon Feb 29, 2016 11:49 am
Quote
Is it possible to create a CSV without using a rowset input variable? I have 5 variables that i want to write to a file with pipe delimiters but the only way is with a rowset variable. Is it possible to create a rowset variable using the 5 variables?
Top

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ
Post by Support_Rick » Mon Feb 29, 2016 12:04 pm
Quote
JLee,

Yes, you can loop through a Rowset and write out a CSV by utilizing the PRINT Task.

Just Print the values you want to text:

ForEach ${MyRowset} -> var
${var[1]},${var[2]},Code3,${var[4]},2332.30,${var[5]}${system.carriageReturn}
-> Append (True)
-> Print to file MyCSVFile.csv
EndForEach

Read MyCSVFile.csv

It's that simple!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Top
Post Reply
2 posts Page 1 of 1
Return to “Community Forum”