.CSV file naming by 'Sample Name' field

Question

Hello,

I'm using Report Builder for MassHunter and generating a .csv file for the unknowns analysis and the file name is the Method.csv for each file inside a new folder for each sample.

I would like the .csv file to be named the sample name from the 'Sample Name' field.

May I have some guidance on how to set that up?

Thank you.

howard_sanford · Accepted Answer

steventhornley , Report post processing utilizes batch files. There are some default shipping files in the following location D:\MassHunter\Scripts\Quant\Report While these are in the Quant folder they can be used for either Quant or UA reporting. As a test for this I modified some code I found at StackOverflow and combined it with one of the shipping .bat files as follows. (I have attached this as a .txt file. Download and rename to .bat) REM ================================================================================================ REM Program: RenameCSV_SampleName.Bat REM Description: Rename reports generated in .csv format to the text found after 'Sample Name,' entry in file. REM Requires: "$(DestinationFilePath)" Argument entered in the Post Process Editing Window, including quotes REM Note: This does not check to see if Sample Name would be a valid Windows file name or if there are duplicate sample names. REM Note: This is only intended as an exmample of what can be done with Post Processing batch files. Please modify and test appropiately. REM Log: PostReportProcess.log is generated to record the status of the process REM Scope: This is intended for use in Single Sample mode REM ================================================================================================ @setlocal enableextensions enabledelayedexpansion @echo on set dir=%~dp1 echo Current directory is: !dir! cd /d %dir% echo %date% %time% >PostReportProcess.log for %%i in (*.csv) do ( for /f "tokens=2 delims=," %%j in ('findstr /B /I "Sample Name," "%%i"') do ( ren "%%i" "%%j.temp_txt" ) ) >>PostReportProcess.log 2<&1 ren *.temp_txt *.csv endlocal REM pause This will change directory to the current reporting path and rename all .csv files in that directory to be whatever is found after the text 'Sample Name,' in the file. As noted this does no error checking, either for valid or duplicate file names, and I have only done limited testing. Modify and test accordingly. Copy or create this batch file in the default report scripting folder shown above. To utilize the Post Process in your Reporting method, first expand the window so that the entire row can be seen. The Post Process drop down is the very last column on the Templates tab. To create or edit a Post Process, click on the button in the lower right hand corner. Then choose to create a New Post Process and set it up like this After clicking OK you will have this Task name as a choice in the Post Process drop down. Now when the reporting method is run, after the files are created they will be renamed. For the demo files I was working with this is the result. You can add any other batch commands you want, such as moving or copying the resulting reports to a network drive, or whatever other tasks you may wish to perform.