Hi all,
I thought this would be straightforward but its proved anything but (probably its just me). I have hundreds of .csv files currently all named by a specific code. However each file also contains the name of the dataset in cell A1. Simply (i thought) I want to expose cell A1 so I can write it as the filename and bulk rename all files in the folder.
Any thoughts and thanks in advance
Chris
@chrisa You can use the File Copy writer to rename your files. But you'll have to read the CSVs to dig out the file name from your first row. So add the CSV reader: for the Dataset use the Select Multiple Folders and Files Browser. Once you've added the reader (you should only have one) in the Navigator, under the CSV reader parameters open Feature to Read and select Max Features to Read = 1. so you'll only read the first row of each feature and you can pass the new file name to the Copy Writer.