Special Characters X PHP Code - SOLVED

[HyperOsmar]

Dear Colleagues,
I'm migrating (in testing phase) from Joomla 3.X to 4.X...
In the previous version there was a plugin for validating Special Characters of elements and, which worked perfectly, this plugin is no longer present in the current version.
I'm trying to replace it with the PHP Code plugin, inserting the following rule:

$value = "{cad_municipios___observations:value}";
if (strpos($value, ';') !== false) {
$value = str_replace(';', '|', $value);
JFactory::getApplication()->enqueueMessage("The character ';' has been replaced by '|'.", 'warning');
"{cad_municipios___observacoes} = '$value'";
}​

But unfortunately, without success...
Can someone help me???...

 

[troester]

In the previous version there was a plugin for validating Special Characters of elements

Which one?

 

[HyperOsmar]

Joomla - 3.9.28
Fabrik - 3.9.2
MySQL - 5.7.23
PHP - 7.4.16

Agora estou migrando para um servidor de teste:
Joomla - 4.3.1
Fabrik - 4.0gamma3
MariaDB - 10.4.25
PHP - 8.1.10

In version 3.X, the plugin worked perfectly... as shown in the image below:

 

[troester]

Ok.
You should be able to use the regex validation or php validation (but with valid php code)
http://fabrikar.com/forums/index.php?wiki/regular-expression-validation/
http://fabrikar.com/forums/index.php?wiki/php-validation/
Something like (I didn't test)
php with replace=yes

if (strpos($data, ';') !== false) {
$value = str_replace(';', '|', $value);
Joomla\CMS\Factory::getApplication()->enqueueMessage("The character ';' has been replaced by '|'.", 'warning');
return $value;
}

Maybe the specialchars validation will make it into the next release.

 

[HyperOsmar]

Where am I going wrong???...

Anything I type validation fails...

In MySQL it does not save...

 

[HyperOsmar]

Maybe the specialchars validation will make it into the next release.

Is there any prediction of when it will be available???

 

[troester]

I missed to replace $data in str_replace. So

if (strpos($data, ';') !== false) {
$value = str_replace(';', '|', $data);
Joomla\CMS\Factory::getApplication()->enqueueMessage("The character ';' has been replaced by '|'.", 'warning');
return $value;
}
else return $data;

should do.

 

[HyperOsmar]

I missed to replace $data in str_replace. So

I apologize a lot... In the rush I ended up not paying attention.