Every now and then we will add new accounts to our accounting software. Each account has an account code and an account description.
My CSV file (which is to be imported into the accounting software) only has the account description and this needs to be replaced with the account code instead.
It seems like using eval would result in a heinously long command... we're talking a list of 500 account codes and account descriptions...
Wondering if there is a recommended way to perform a vlookup-like function from csvfix.
Obviously you would need a separate csv file to have the lookup table, and that would be an input into csvfix.