PSCSV
antA powershell script to help Salesforce admins and consultant to save time and do data load operations without having to rely on Excel.
Current list of stuff the script can do:
- transcode a file from one encoding or separator to another
- remap values in a column from one to another - reformat Dates from whatever format to the salesforce format
- reformat Date Times from whatever format to the salesforce format
- replace whatever you want in a column with ""
- great if someone is sending you files with
null.