Name Split

Comments

• kapamarou Member Posts: 1,152

  2010-03-12

  You could try using STRPOS and COPYSTR.
  
  Where do you get the text from? Is there any way to get three different strings instead of one to avoid problems?

  0
• matttrax Member Posts: 2,309

  2010-03-12

  Yep, just do some basic string parsing with STRPOS and COPYSTR.
  
  You'll need to account for special cases where you only have two names instead of three, possible prefixes or suffixes like Mr. or Jr., two middle names, etc. But the same principles apply.

  Matt Traxinger - ArcherPoint

  0
• PeterD Member Posts: 66

  2010-03-12

  Have a look at SELECTSTR and use CONVERTSTR to convert the spaces into the needed commas.

  0
• matttrax Member Posts: 2,309

  2010-03-12

  PeterD wrote:

  Have a look at SELECTSTR and use CONVERTSTR to convert the spaces into the needed commas.

  
  Excellent alternative, although it could have some issues. If a name was entered as "First Middle Last, Jr." for example.

  Matt Traxinger - ArcherPoint

  0
• ssingla Member Posts: 2,973

  2010-03-13

  Check how contact card manages the same.

  CA Sandeep Singla
  http://ssdynamics.co.in

  0