split file data based on delimiter and assign them to different array

Hi all

Below is the data i have in a flat file

timestamp;_tmp_MIN;_tmp_MAX;_tmp_AVERAGE
1598613120;8;8;8
1598613180;8;8;8
1598613240;8;8;8
1598613300;8;8;8

Need to split the data based on ';' and store each column data into an array.

Need some idea/reference for this.

  • $data =
    @"
    timestamp;_tmp_MIN;_tmp_MAX;_tmp_AVERAGE
    1598613120;8;8;8
    1598613180;8;8;8
    1598613240;8;8;8
    1598613300;8;8;8
    "@ -split "`n" | ConvertFrom-Csv -delimiter ';'
    
    $data.timestamp
    $data._tmp_MIN
    $data._tmp_MAX
    $data._tmp_AVERAGE