Hi All,
I am planning to automate one of the task.I have a comma separated file with some error message populated.I need to remove the error message and load the csv file into a excel columns and save the result with the date prefixed.
the csv file will be found in a particular directory with the date valu appended like test2303.txt where 2303 is the date in ddmm format
i will have a template which need to have the macros to convert to excel columns i.e. do a text to column transformation and save it into another directory with date appended.
Kindly help me in getting this done.
I am planning to automate one of the task.I have a comma separated file with some error message populated.I need to remove the error message and load the csv file into a excel columns and save the result with the date prefixed.
the csv file will be found in a particular directory with the date valu appended like test2303.txt where 2303 is the date in ddmm format
i will have a template which need to have the macros to convert to excel columns i.e. do a text to column transformation and save it into another directory with date appended.
Kindly help me in getting this done.