Automate CSV File using VBScript

Pamidd 21 Reputation points
2021-11-22T13:46:04.22+00:00

I do have CSV File with below data and its headers.

FileName,SourceFilePath,APP,SLA,FArrivalTime,FileSize(B)
abc.txt,\com.abc,12345,3:00,17/11/2021 04:25,100
adf.txt,\com.abc,12346,3:00,,
bbc.txt,\com.abc,12346,3:00,17/11/2021 04:25,100

Now I need to automate with following requirements.

  1. Need to get all the FileNames and FileSize(B) only when FArrivalTime is having data.
    Output should be something like this: Metrics|Folder1|Folder2|abc.txt,value=100
  2. Need to get all the FileNames and FileSize(B) only when FArrivalTime is empty.
    Output should be something like this: Metrics|Folder1|Folder2|adf.txt,value=0
  3. Need to get all Total FileNames and Total App Count when FArrivalTime is having Data.
    Output should be something like this: Metrics|Folder1|Rows|App,value=2 and
    Output should be something like this: Metrics|Folder1|Rows|FileNames,value=2
  4. Need to get all Total FileNames and Total App Count when FArrivalTime is empty.
    Output should be something like this: Metrics|Folder1|Rows|App,value=1 and
    Output should be something like this: Metrics|Folder1|Rows|FileNames,value=1

Please help me in providing the VBS Code to Automate the above scenarios.
As I'm new to VBScripting I need the code to configure in AppDynamics to get the metrics.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
24,058 questions
{count} votes