I was wondering if there was software for Linux or Windows (preferably Win), that would allow you to take a line from a CSV or spreadsheet file and replace it inside of a seperate text file?
Example:
The CSV/Excel file of movies:
Line 1: title, description, year, rating
Line 2: title2, description2, year2, rating2
Line 3: title3, description3, year3, rating3
Each line would correspond to a text file:
line 1 would replace the information in textfile1
line 2 in textfile2... etc.
I’m finding it hard to google, as I’m not sure of the correct term for this stuff. Searching for "bulk text editor" and the like brings up results that seem to only allow search and replace from inside a menu, not from an external CSV or spreadsheet.
Further example from comments for clarity (sorry, this is a new concept to me):
I have a CSV file and each line has info for a certain video. They are separated by commas but each line is formatted the same:
The Simpsons, The adventures of an average family in Springfield., 1989, TV-PG
So as you can see, each line will have the format of:
Title, Description, Year, Rating
Now, I have a TXT or HTML file and each one corresponds to a video. Let’s say I have 200 videos, so I create 200 identically formatted HTML files. These HTML files or TXT files would be named 1.txt, 2.txt, 3.txt, etc. They would all contain the dummy texts of Title, Description, Year, Rating which are replaced by the CSV data, 1 CSV line per text file.