Link to home
Start Free TrialLog in
Avatar of Nick Collins
Nick Collins

asked on

Working with CSV Files

I have a folder of csv files with a random filename and I want to rename the filename with some text within the csv file which is relevant. Any help?
Avatar of Learn
Learn
Flag of India image

Answer is, Yes possible, if advise which field  name you exactly want from the CSV data as a file name.

Thanks
Learn excel in Tamil
Happy learing
Avatar of Nick Collins
Nick Collins

ASKER

Each CSV file is quite large but I am only interested in a small section of the file.
I'll attached an example for you. I would like to extract some of data under column C titled Response.

Row 3 Named Client Site Job Number
Row 4 Order Number
Row 5 Completed On

I would like three above to be the filename

Thanks
Avatar of Qlemo
How to identify which CSV files have already be changed to the new file name? Is there a pattern for the random part versus the new name?
The CSV files old name all begin with template_
waiting for you to post a sample csv file
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial