Trying to remove a middle initial from a full name

Epicor ERP 10
1

As the subject says, I have a field “=Fields!Calc_Buyer.Value” That displays first name, middle initial, and last name. My customer wants the middle initial stripped out. I am new to this and could use some help!

Thanks,
Max

2

BuyerID is tied to a Person/Contact (PerCon) record. You should be able to modify the name in Person/Contact Entry. Note that PerCon records can also be tied to employee, payroll, workforce and more. So changing the middle name may flow down to those other modules depending on your sync settings.

You can also just grab the FirstName and LastName from the PerCon for your customization.

1 Like
3

I haven’t had this use case but it’s substring command

Something like this can get you started:

4

I resolved this by encouraging the customer to address the way they enter their data. Reason being, what is someone has two first names… such as Mary Ann. If the customer preferred to have both first names displayed and then I was trying to look through for a space, I could end up omitting the second first name and leaving the middle initial. Thank you all for your input!