I'm having trouble with something and was hoping you could help. I have a list of names that I need to format. All the names are in text fields. Some names have middle initials and others don't. What I need to do is format the list in a new field so that all the middle initials are removed. I have no idea how to do this unfortunately, and have searched and gotten nowhere. I have also asked podio support and haven't gotten too far. I was hoping someone here could help me with this.
I'm doing this because I am using a globiflow flow to match the names in the list to names in a leads app I have, and pulling mailing addresses from the item associated with the matched name to use for an automated contract I'm creating. But none of the names in the leads app have the middle initial in them. So I'm formatting the names in my list so that they'll match the names in the leads app.
I hope my question is clear and I appreciate the help tremendously. Thank you in advance!
Please sign in to leave a comment.