How to remove specific text from a field to create a new variable in globiflow

Follow

Daniel Horne

• February 15, 2017 07:31

I'm wondering how to remove "////DRIVING////" from a text field that has a person's name in it. Don't know too much about coding.

0

• 

  Rainer Grabowski

  • February 15, 2017 09:50

  Hi Daniel,

  with calculation fields you can do awesome things - but you can't remove something from another field. You would need the extension Globiflow.. With calculations you can show something from other fields like from your text field. If you enter:  

  @text field.replace("////DRIVING////","")

  in a calculation it shows the text w/o ////DRIVING//// - but the text in the text field doesn't change.

  Rainer

  1

  Comment actions Permalink
• 

  Bill Carovano

  • February 15, 2017 12:58
  • Edited

  in Globiflow, you would use str_replace("////DRIVING////","",[name of variable])

  1

  Comment actions Permalink
• 

  Daniel Horne

  • February 15, 2017 18:43

  Thanks

  0

  Comment actions Permalink
• 

  Daniel Horne

  • February 18, 2017 03:57

  I have a follow up question. How would I take the spaces from an address token in globiflow and turn them into "+"

  i.e. 123 Main St --> 123+Main+St

  Also, would it be possible to split one text field containing the name into first name, last name and middle name variables in globiflow?

  Thanks so much,
  Daniel

  0

  Comment actions Permalink
• 

  Daniel Horne

  • February 18, 2017 04:17

  Additionally,

  I've tried 

  str_replace(" ","+","[var]") 

  but it comes back with: illegal call: North, illegal call: nd, illegal call: Avenue

  0

  Comment actions Permalink
• 

  Daniel Horne

  • February 18, 2017 04:28

  Nevermind, I figured it out:

  str_replace(" ","+",[var]) 

   

  Although my follow up question stands

  0

  Comment actions Permalink
• 

  Bill Carovano

  • February 19, 2017 13:52

  Splitting a full name into First, Middle, and Last is tough to do with 100% accuracy given the differences across cultures about what first names, middle names, and last names (surnames) actually are.

  You could do this in a crude way by looking for spaces in a full name field and making some assumptions--e.g. anything from position 0 in the full name string to the first space is first name.  If there is only 1 space in a full name, then you might assume that the substring after the first space is the last name.

  But there are a whole lot of reasons where this won't be accurate.  And the source of your data needs to be consistent.

  Examples:  imagine a person named Juan Carlos Smith-Sanchez.  This person probably considers their first name to be "Juan Carlos" -- and they may prefer to be addressed as "Juan Carlos" and not "Juan."

  "George Herbert Walker Bush" is another example.   This person probably prefers to be addressed as "George" and not "George Herbert."

  So the difference here is cultural.

  There are free web services like nameapi.org that you could call from Remote Get actions in Globiflow that would be more accurate overall.

  It all depends on how precise you want to be.

  0

  Comment actions Permalink

Please sign in to leave a comment.