How to use sum() for the $ values?

[kiran331]

Hi I have a csv file with $6.00, $6.11,etc as values. How can user sum() for these values?

[somesoni2 · Accepted solution]

You would've to process the fields that contains values with dollar sign to remove $ so that Splunk can treat them as number and then you can apply sum aggregation. See this runanywhere sample search on one of the method to replace $ sign.

| gentimes start=-1 | eval field1="$6.00 $1.11" | table field1 | makemv field1 | mvexpand field1 | eval field2=replace(field1,"\$","") | stats sum(field2)