Chris Spargen from Linoma got in touch with me and he directed me towards the following : This was possible by using the modify row set only, No need to use the loop. made use of a look up by using the following <readExcel inputFile="${ThisFile}" outputRowSetVariable="csvRow" skipEmptyRows="true" da...

Based on a lookup, I am trying to change the contents of an individual column in an excel. My approach is based on using a For Each loop and running iterations against the row set. I want all the contents of this column to get replaced by particular values present in the if loop contained in the for...

thanks! that helped

Its been listed that GoAnyWhere can convert formats to & from Excel, XML, Delimited text and Flat File or Fixed Width file formats can the same logic be used while dealing with the formats listed above?

How can csv files be converted to excel format with preserving the columns?

I tried to convert a csv to excel and all the data was pushed into one column, the column structure was completely lost...

We have this requirement to move newly created files from an Archive folder that contains files from over a year. While doing so, is their a way to completely avoid the ForEachLoop ? We are working under restrictions for e.g we cannot modify the existing folder structure. I am aware that a monitor c...

thanks! that helped...

I am working on a project that takes in CSV files generated in LINUX. These files generated in LINUX have formatting where the record/row separator is a line feed, which doesn't match our requirement. Hence I am reading these files again through GoAnyWhere Director and while writing them I change th...

thanks a lot, that helped!

Rick, Thanks for the quick reply. I understood the output variables part, So far here's what I have. copy label="Copy to NW folder" sourceFile="${thisFile:name}" destDir="destination/" whenFileExists="skip" numFilesCopiedVariable="copiedFiles" destinationFilesVariable="destFiles" version="1.0" logLe...