topic Re: Log Pipeline Management - how to convert comma decimal to dot in Getting Data In https://community.splunk.com/t5/Getting-Data-In/Log-Pipeline-Management-how-to-convert-comma-decimal-to-dot/m-p/612838#M106028 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/243720">@fongpen</a>,</P><P>You can use rex command with sed mode;</P><LI-CODE lang="markup">| rex mode=sed field=cookedvalue "s/,/./g"</LI-CODE> Tue, 13 Sep 2022 08:11:58 GMT scelikok 2022-09-13T08:11:58Z Log Pipeline Management - how to convert comma decimal to dot? https://community.splunk.com/t5/Getting-Data-In/Log-Pipeline-Management-how-to-convert-comma-decimal-to-dot/m-p/612834#M106026 <P><SPAN>Hi,</SPAN></P> <P><SPAN>May i know how to convert raw data (cookedvalue) from comma to dot using regex?&nbsp;</SPAN></P> <P><U>Raw Data in Log Observer</U></P> <P><SPAN>"instanceName","cookedvalue"</SPAN></P> <P><SPAN>"services","87,8477154366277"</SPAN></P> <P>&nbsp;</P> <P><U>Result</U></P> <P><SPAN>"instanceName","cookedvalue"</SPAN></P> <P><SPAN>"services","87.8477154366277"</SPAN></P> Tue, 13 Sep 2022 12:58:09 GMT https://community.splunk.com/t5/Getting-Data-In/Log-Pipeline-Management-how-to-convert-comma-decimal-to-dot/m-p/612834#M106026 fongpen 2022-09-13T12:58:09Z Re: Log Pipeline Management - how to convert comma decimal to dot https://community.splunk.com/t5/Getting-Data-In/Log-Pipeline-Management-how-to-convert-comma-decimal-to-dot/m-p/612838#M106028 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/243720">@fongpen</a>,</P><P>You can use rex command with sed mode;</P><LI-CODE lang="markup">| rex mode=sed field=cookedvalue "s/,/./g"</LI-CODE> Tue, 13 Sep 2022 08:11:58 GMT https://community.splunk.com/t5/Getting-Data-In/Log-Pipeline-Management-how-to-convert-comma-decimal-to-dot/m-p/612838#M106028 scelikok 2022-09-13T08:11:58Z Re: Log Pipeline Management - how to convert comma decimal to dot https://community.splunk.com/t5/Getting-Data-In/Log-Pipeline-Management-how-to-convert-comma-decimal-to-dot/m-p/612853#M106034 <P>I'm wondering how does this compare performancewise to</P><PRE>| eval cookedvalue=replace(cookedvalue,",",".")</PRE> Tue, 13 Sep 2022 09:43:51 GMT https://community.splunk.com/t5/Getting-Data-In/Log-Pipeline-Management-how-to-convert-comma-decimal-to-dot/m-p/612853#M106034 PickleRick 2022-09-13T09:43:51Z