in reply to
Move data into AoH
JSON is a good starting point, but it requires field names and values in quotes. See the following code which does not work due to lack of quotes:
my $json = <<EOT;
my $data = decode_json( $json );
print Dumper $data;
If you can't write a simple regex to fix the quote issue, I suggest to look into Text::CSV. With the help of that module you might be able to parse your text file. It really depends on how quotes, colons and commas interact in your file.