Name Split

shweta
Member Posts: 94
Hi All ,
I have one field of full name which hold the value ambrish pratap singh now i want to split the name in three fields which are name1,name2,name3now i want that name1 should have ambrish
name2 should have pratap
name3 should have singh
its urgent please help
thanks in advance
Regards
Shweta
I have one field of full name which hold the value ambrish pratap singh now i want to split the name in three fields which are name1,name2,name3now i want that name1 should have ambrish
name2 should have pratap
name3 should have singh
its urgent please help
thanks in advance
Regards
Shweta
0
Comments
-
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 -
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.0 -
Have a look at SELECTSTR and use CONVERTSTR to convert the spaces into the needed commas.0
-
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.0 -
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions