Removing a middle initial from a name field

Comments

3 comments

  • Amber Sullard

    Hi Oz! I am by no means an expert but since you said you are using globiflow, maybe you could leverage this parsing functionality?

    http://www.globiflow.com/blog/parsing-text-in-podio-with-globiflow.php

     

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Oz,

    in a calculation field you can do this:

    var text = @your text field;
    text.substring(0,text.indexOf(" ")) + " " + text.substring(text.lastIndexOf(" ")) 

    The code gets first the string before the first blank space and then the string after the last blank space. Works fine, if there's no prefix and no suffix in the name field. and if the first name doesn't be 2 strings like "Su Ann B. Miller" (result would be; "Su Miller")

    Rainer

    0
    Comment actions Permalink
  • Oz Pariser

    Thank you both for the replies. Rainer that did it for me, thank you very much!

    Oz

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk