I’m attempting to make a scenario like this:
- Retrieve a CSV file with 13 columns from an FTP server
- Parse the CSV out
- In one of these fields, replace strings with other, corresponding strings. For example, 123=abc, 456=def, 789=ghi, etc.
- Create the new CSV with the value updated
- Upload the CSV file to another FTP site
I can’t figure out a good way to replace each string in that one column with a corresponding string. There’s clearly a replace function that can be used, but how would you do it with about 10 different possibilities and replacements?