Log Pipeline Management - how to convert comma decimal to dot?

[fongpen]

Hi,

May i know how to convert raw data (cookedvalue) from comma to dot using regex? 

Raw Data in Log Observer

"instanceName","cookedvalue"

"services","87,8477154366277"

Result

"instanceName","cookedvalue"

"services","87.8477154366277"

[scelikok]

Hi @fongpen,

You can use rex command with sed mode;

| rex mode=sed field=cookedvalue "s/,/./g"

[PickleRick]

I'm wondering how does this compare performancewise to

| eval cookedvalue=replace(cookedvalue,",",".")