It has been a long time (years) since I have done any scripting like this. For integration scripting for the applications we build, developers seem to be using PowerShell these days. So I'm thinking that may be a good solution. I need a script on a user's Windows PC to create a new file with 3 columns from a pipe delimited csv file (1) header for the 3 columns is Employee, Parent, Alias: Default (2) Ignore first record of the source file (3) First column is first column of source file with prefix of E (4) Second column is the first character of column 2 of the source file (5) Third column is the second column of the source field followed by comma then space then column 3 of source then space then left parenthesis then column 1 of source then right parenthesis. Many thanks!
In reply to postanote:
In reply to dsunde: