Gary Brett asked 9 years ago
Hi Abu, I have a column that our users paste a value into, this on occasions leaves a whitespace at the beginning of the value, is ther any method to trim the field on insert?
Example
normal
normal
3whitespace
1whitepsace
normal
normal
Thank you
1 Answers
Abu Ghufran answered 9 years ago
You can do it via PHP using on_insert / on_update events.
$e["on_insert"] = array("trim_input", null, true);
$e["on_update"] = array("trim_input", null, true);
function trim_input($data)
{
$data["params"]["fieldname"] = trim($data["params"]["fieldname"]);
}
Your Answer
