saggikarius
New Member
- Joined
- Oct 24, 2005
- Messages
- 23
Hi,
We use the csv parser exe file from DOS Command prompt to remove unwanted data.
The following commands are given at the command prompt:
C:\Cd csv correction << This is to go in the folder
C:\Cd csv correction\csv_parrser.exe "abcd.csv" "edited_abcd.csv"
Once hit enter the following appears under this command:
processing file: abcd.csv
removing duplicate word ref.......,53464990 <<<<Some other number here for ref
Output file created: edited_abcd.csv
And then it returns this status
C:\csv correction>_
FYI: The csv_parser.exe has been created with an evaluation version of Perl2Exe: http://www.indigostar.com
It may sound strange, however, what we want is to bypass the command prompt and run this commands via Excel vba dynamically where we can give the user input box to select the file and the folder in which it has to be stored. This is because we want to use this csv parser exe file via citrix where there is no direct way to access the Dos prompt
We use the csv parser exe file from DOS Command prompt to remove unwanted data.
The following commands are given at the command prompt:
C:\Cd csv correction << This is to go in the folder
C:\Cd csv correction\csv_parrser.exe "abcd.csv" "edited_abcd.csv"
Once hit enter the following appears under this command:
processing file: abcd.csv
removing duplicate word ref.......,53464990 <<<<Some other number here for ref
Output file created: edited_abcd.csv
And then it returns this status
C:\csv correction>_
FYI: The csv_parser.exe has been created with an evaluation version of Perl2Exe: http://www.indigostar.com
It may sound strange, however, what we want is to bypass the command prompt and run this commands via Excel vba dynamically where we can give the user input box to select the file and the folder in which it has to be stored. This is because we want to use this csv parser exe file via citrix where there is no direct way to access the Dos prompt