I have exactly 7 spaces randomly in each line of my data such as below and I would like to trim exactly these number of spaces (7) in the data and merge .
Input :
<ProdCD>CST</ProdCD><Pla tformID>1</PlatformID><Message>How are you</Message>
<PlatformNm>Triumph</PlatformNm><ProdType>Market Pr oduct</ProdType><Address>New York</Address>
Desired Output :
<ProdCD>CST</ProdCD><PlatformID>1</PlatformID><Message>How are you</Message>
<PlatformNm>Triumph</PlatformNm><ProdType>Market Product</ProdType><Address>New York</Address>
The data is already in splunk , so I would want to use splunk query to do it , please suggest .
Try this
your base search | rex mode=sed "s/(\s{7})//g"
Thanks ...I will test and let you know,.