Assistance in Using ROQL to bulk edit agent email domain suffix in Connect Object Explorer

@old

Summary

Using ROQL to bulk edit agent email domain suffix

Content

ROQL Statement 

SELECT Account FROM Account WHERE Emails.Address LIKE '%@old.net.invalid')->next(); while($account = $res->next()) {printf("Found Account ID: %d <br />", $account->ID);$arr = explode("@", $account->Emails[0]->Address);
$first = $arr[0];$account->Emails[0]->Address = $first."@new.com.invalid";$account->save();

 

Error×

near ")": syntax error

Version

19C