https://community.splunk.com/t5/Splunk-Search/extract-with-quoted-values/m-p/96229#M24870 <P>In our logs we have keyvalue pairs that looks like this</P> <P>key1='valuex'<BR /> key2='value value val'<BR /> keyx=''<BR /> keyxx='lksajdf lajsdf'</P> <P>just the default |extract does a good job but all the values still have the single quotes around them. One thing to remember is that we dont know how many keys and what keys there will be, so i cant hard code them, they are volatile.</P> <P>i would like to apply this regexp to all the values of my extractions ^'(.*)'$</P> <P>can i configure this somewhere in my transforms.conf ? </P> Fri, 06 May 2011 09:01:03 GMT bowa 2011-05-06T09:01:03Z https://community.splunk.com/t5/Splunk-Search/extract-with-quoted-values/m-p/96229#M24870 <P>In our logs we have keyvalue pairs that looks like this</P> <P>key1='valuex'<BR /> key2='value value val'<BR /> keyx=''<BR /> keyxx='lksajdf lajsdf'</P> <P>just the default |extract does a good job but all the values still have the single quotes around them. One thing to remember is that we dont know how many keys and what keys there will be, so i cant hard code them, they are volatile.</P> <P>i would like to apply this regexp to all the values of my extractions ^'(.*)'$</P> <P>can i configure this somewhere in my transforms.conf ? </P> Fri, 06 May 2011 09:01:03 GMT https://community.splunk.com/t5/Splunk-Search/extract-with-quoted-values/m-p/96229#M24870 bowa 2011-05-06T09:01:03Z https://community.splunk.com/t5/Splunk-Search/extract-with-quoted-values/m-p/96230#M24871 <P>Something like this should work:</P> <P>props.conf:</P> <PRE><CODE>[mysourcetype] REPORT-ex = myreport </CODE></PRE> <P>transforms.conf:</P> <PRE><CODE>[myreport] REGEX = ([^=]+)='([^']+)'\s FORMAT = $1::$2 REPEAT_MATCH = true </CODE></PRE> <P>This should automatically extract all values and populate keyX fields with them, no matter how many there are.</P> Sun, 08 May 2011 19:51:03 GMT https://community.splunk.com/t5/Splunk-Search/extract-with-quoted-values/m-p/96230#M24871 bojanz 2011-05-08T19:51:03Z https://community.splunk.com/t5/Splunk-Search/extract-with-quoted-values/m-p/96231#M24872 <P>doesn't work for me ... just using |extract works but all values are still with the single quotes around them .</P> Mon, 16 May 2011 13:37:33 GMT https://community.splunk.com/t5/Splunk-Search/extract-with-quoted-values/m-p/96231#M24872 bowa 2011-05-16T13:37:33Z