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?
