6 Replies Latest reply on Sep 6, 2013 8:19 PM by Shawn Wallwork

    Working with strings

    Luis Amadeo

      I thought this would be easy but I am getting stomped. I have two different connections with the same field, Patient's Name. However, in one database the name starts with the last name, coma, first name, and the other one is first name, last name. I want blend data on these fields but I need to get the first one in the same format as the second. So I need take all strings after the coma and bring all those characters to the front and then eliminate the coma. Any thoughts on how I may accomplish this? Thanks,

       

      Database 1

      Patient's Name:  "Doe, John"

       

      Database 2

      Name: "John Doe"

       

      Luis Amadeo