?
Solved

Seperate a FIELD VALUE

Posted on 2018-02-14
2
Medium Priority
?
14 Views
Last Modified: 2018-02-15
I have a field which has first and second names (OR the field may only contain the first name)
How can I create a formula which only show the first name
0
Comment
Question by:GiaHughes
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 42468893
Assuming there is always a first name you can use

Split({YourNameField})[1]

Split will create an array of strings splitting on the blanks.

You can also use this format to specify the split character(s)
Split({YourNameField}, ' ')[1]

mlmcc
0
 

Author Closing Comment

by:GiaHughes
ID: 42469905
Spot on as usual
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question