Trim spaces in between the data

[ishugupta]

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 .

[somesoni2 · Accepted solution]

Try this

your base search  |  rex mode=sed "s/(\s{7})//g"

[ishugupta]

Thanks ...I will test and let you know,.