Writing to CSV or Flat File without Rowset

If you have a new question you’d like our support staff to post a response to, please visit our customer community, GoAnywhere Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.goanywhere.com.

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
2 posts Page 1 of 1

jlee1

Posts: 12
Joined: Mon Jun 22, 2015 12:41 pm

Post by jlee1 » Mon Feb 29, 2016 11:49 am
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?

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Mon Feb 29, 2016 12:04 pm
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
2 posts Page 1 of 1