PS v5.1: how to calculate a sum of values found in a field of CSV file RRS feed

  • Question

  • I have a file which contains numerous lines with comma-separated fields in the following format:

    09:30:01.285: BUY transId=200, item=ABC, id=158631, price=99.46, volume=98, value=12183850

    09:30:01.285: BUY transId=201, item=DEF, id=158632, price=99.46, volume=38, value=4724350

    09:30:01.285: BUY transId=202, item=GHI, id=158633, price=99.46, volume=19, value=2362175

    I want to extract the integer values from "volume" fields and calculate the sum. How could i do this?

    Thank you

    Thursday, January 23, 2020 5:59 PM

All replies

  • Start with:

    help import-csv -online


    Thursday, January 23, 2020 6:09 PM