If I have a CSV file..

[SimonCHere]

So, I turned up and found out they were running Macs. Woops

The batch file worked a treat @SimonCHere I'll file that! How easy would it be for it to add a first line as 'File Name'?

Sooo, for Macs then what can I use? How do you use those Python scripts @Hades ?

no checking, error handling or anything but it prompts for file name and extension and then creates a new file.

@echo off
set /P fname="Enter filename: "
set /P ext="Enter extension: "
setlocal enabledelayedexpansion
for /f "tokens=*" %%a in ('type %fname%') do (
set line=%%a
echo !line!.%ext% >> modified_%fname%
)

Interestingly if you have Notepad++ you can do a search/replace of the new line character to get the same result.
If you use
"Extended" in the "Search Mode" you can use
"Find what: " \r\n
"Replace with: " .mov\r\n

@Hades You might want to tell him how to stop your python running as well!

 

[Hades]

@Hades You might want to tell him how to stop your python running as well!

Just kill the terminal session (can't remember how on MacOS) or close the terminal.

 

[ChroniC]

This can be done in about 2 seconds Sublime text. Open the csv... Select every single one and the just Shift End... All files will be selected with a type flashing line and you can type the same thing on every line in one go. Done...

 

[builder22]

a related question...

when I download a bank statement and open in excel...say the description is in B2 and the amount in C2. How would you find out how much you'd spent in Tesco (or whatever!) within all the cells in the file?

just now I do a 'find all'...highlight the cells with 'Tesco' then just manually go through them...fairly sure there's a simple solution

 

[Illusion]

This is one line in a shell on Linux or MacOS. Surely you can do something similar in power shell on windows these days?

[root@nuc ~]# cat file.csv
name1
name2
[root@nuc ~]# cat file.csv | while read line; do echo $line.mov; done
name1.mov
name2.mov
[root@nuc ~]#

 

[ChroniC]

a related question...

when I download a bank statement and open in excel...say the description is in B2 and the amount in C2. How would you find out how much you'd spent in Tesco (or whatever!) within all the cells in the file?

just now I do a 'find all'...highlight the cells with 'Tesco' then just manually go through them...fairly sure there's a simple solution

There's a filter option, you can filter the row based on a cell. So if the cell contains tesco only those rows will be visible.

 

[Django x2]

20 seconds in Excel and you're off.

 

[builder22]

There's a filter option, you can filter the row based on a cell. So if the cell contains tesco only those rows will be visible.

cheers