AnsweredAssumed Answered

How to remove specific text from field and show in another field

Question asked by atika on Jun 13, 2018
Latest reply on Jun 13, 2018 by atika

Hiii Guys I am new to use FileMaker. Actually I have Employee table and 2 fields Emp_email (a.akmal@greencells.com) 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 

Outcomes