Automate CSV File using VBScript

Question

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.