Replacing Field Value

[beepbop]

Hello, I have some field values which I am unable to replace with the 'replace' command in the csv file. I have Power States of servers which are Powered On and Powered Off and there are some fields which have both powered on and powered off status like:

server name	PoweredOn
server name	PoweredOff
server name	poweredOn poweredOff
server name	poweredOn poweredOff suspended
server name	poweredOff PoweredOn poweredOff

I was able to change the field value of "poweredOn poweredOff suspended" with
|replace  "*poweredOff poweredOn suspended*" with "*Suspended*"
but when I change the command with
|replace  "*poweredOn poweredOff*" with "*PoweredOn*"
it doenst reflect. Can anyone tell me how to replace these?

[ITWhisperer]

| rex mode=sed "s/poweredOn poweredOff suspended/Suspended/g"