Windows script to parse CSV, process some items and write to a new file.
$30-250 USD
Færdiggjort
Slået op over 11 år siden
$30-250 USD
Betales ved levering
I need a script (vbs, batch or anything else that will run on a windows 7 machine without any dependencies) that will do the following:
The script will be ran by multiple people on a windows 2008 R2 network. All clients are using Windows 7 professional.
1) Take the attached [login to view URL] file as input. The [login to view URL] file will be read from a UNC path on the network.
2) Parse the CSV. The first column is a sku and it may be listed several times. We are only interested in the last occurrence of each sku.
3) Output the last occurrence of each sku to a new file to the client machine ("c:\[login to view URL]"). In addition, multiply each value that appears after the sku by 1000, remove the decimal points and output that as well on the same line (see attached [login to view URL] to see what I mean).
4) Make a copy of the original [login to view URL] file, rename it to the current timestamp and place it in a backup folder (again UNC path on the network).
5) Delete the original [login to view URL] file.
The UNC path will not require any authentication.