Skip to content

Latest commit

 

History

History
20 lines (14 loc) · 865 Bytes

README.md

File metadata and controls

20 lines (14 loc) · 865 Bytes
Raw

csvlookup

Bash + AWK script for quick Vlookups using CSV files. Ideal for large data sets The main script is lookup.sh, which will give you the list of arguments the script expects For best results, keep the data files in the same directory as the scripts

Author: Suraj Pillai Date: 5th Feb, 2016

How to run:

  • Copy the scripts to a folder on a Linux machine
  • Copy the csv files, both the data file and the lookup file to the same folder
  • Provide execute permissions to lookup.sh and processcsv.sh by running the commands:
  • chmod +x lookup.sh
  • chmod +x processcsv.sh
  • Run lookup.sh ( ./lookup.sh). This will give you the list of arguments the script expects. Run the script again with the correct arguments to do the vlookup.
  • The script will add the lookup data as the last column of the input data file, with the column name provided by the user