asespedal
New Member
I have a table where the "abbreviated" field (calc) represents the first and last name of the "name" field. If you export by fields and the "name" field is not selected, the "abbreviated" field will look like this: "{aaa_aainscritos___nome} {aaa_aainscritos___nome}".
calculation formula:
$name = '{aaa_aainscritos___nome}';
$name = explode(' ', $name);
$firstName = $name[0];
$lastName = (isset($name[count($name)-1])) ? $name[count($name)-1] : ' ';
return $firstName." ".$lastName;
calculation formula:
$name = '{aaa_aainscritos___nome}';
$name = explode(' ', $name);
$firstName = $name[0];
$lastName = (isset($name[count($name)-1])) ? $name[count($name)-1] : ' ';
return $firstName." ".$lastName;