Removing text from webhook

I am VERY green to all of this. I am using a webhook that is taking scans from CodeReadr and adding them to a google sheet.

When a scan is “invalid” it returns a result of “Invalid barcode. Value not in database.”

I would like to set it up to leave that cell blank, or replace all of that text simply with “Invalid”.

I’m not even sure which function to use. Any help would be appreciated.

Screen shots please. Hard to visualIze what you are trying to accomplish.