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].
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].
Writing to CSV or Flat File without Rowset
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 Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Writing to CSV or Flat File without Rowset
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!
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696