Hiii Guys I am new to use FileMaker. Actually I have Employee table and 2 fields Emp_email (firstname.lastname@example.org) and Emp_short(a.akmal). In Emp_Short i just want to show name part of email (a.akmal) and remove domain part(@greencells.com). I try number of function i.e. Position, Left, Right, replace Field Contect, Replace, Fliter Trim etc but didn't get required result. I will be very thankfull to you if someone resolve this query.
Profuse of Thanks