Hi @harishalipaka,
Try this query:
| makemv delim="," Drive
| makemv delim="," Free_Space
| eval fields = mvzip(Drive,Free_Space)
| rex field=fields "(?<Drive1>[C]+):,(?<Free_Space1>[\d]+\sGB)"
| rex field=fields "(?<Drive2>[D]+):,(?<Free_Space2>[\d]+\sGB)"
| table Drive1, Drive2, Free_Space1, Free_Space2
Sample query:
| makeresults
| eval _raw="Drive Free_Space
C:,D: 500 GB,450 GB
E:,D: 250 GB,150 GB
C:,E: 250 GB,1 TB
S:,D:,C:,G 120 GB,450 GB,250 GB,800 GB"
| multikv forceheader=1
| makemv delim="," Drive
| makemv delim="," Free_Space
| eval fields = mvzip(Drive,Free_Space)
| rex field=fields "(?[C]+):,(?[\d]+\sGB)"
| rex field=fields "(?[D]+):,(?[\d]+\sGB)"
| table Drive1, Drive2, Free_Space1, Free_Space2
... View more