Re: HELP - Extracting First, Middle and Last Name
From: Mike Walsh [MVP] (englantilainen_at_mvps.org)
Date: 04/11/04
- Next message: Mike Walsh [MVP]: "Re: Email not firing in WSS ADCM host header site"
- Previous message: Damian: "Re: Usage analysis processing stopped working"
- In reply to: Ian Morrish: "HELP - Extracting First, Middle and Last Name"
- Next in thread: John: "Re: HELP - Extracting First, Middle and Last Name"
- Reply: John: "Re: HELP - Extracting First, Middle and Last Name"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 11 Apr 2004 09:49:37 +0300
Ian, the only problem with this example is that in order to see how its
done, you need to go into Modify settings and that of course you can't do
without a name / password.
(The same problem by the way happens in your blog, where Comments are
supposedly allowed but when you've spent the time to write one, you find you
can't save it. So if you were wondering why you aren't getting any comments,
that's why.)
Mike Walsh, Helsinki, Finland
WSS FAQ at wss.collutions.com
Please reply to the newsgroup
"Ian Morrish" <anonymous@discussions.microsoft.com> wrote in message
news:1af1501c41f7e$3ab494f0$a301280a@phx.gbl...
> Given that you have a list with a column containing the
> full name:
> Create calculated columns for the First, Middle and Last
> names.
> See the help for calculated fields and formulas.
> http://your_server/_vti_bin/help/1033/sts/html/wsapusgm.ht
> m
> Here is the formula for First name
> =LEFT([Full Name],FIND(" ",[Full Name]))
>
> Example at http://www.wssdemo.com/Lists/Name/AllItems.aspx
>
> Regards,
> Ian
> >-----Original Message-----
> >In Excel I have written code to extract the First,
> Middle and Last Names
> >from a cell that contains the whole name. I wanted to do
> the same thing in
> >SharePoint. Here is the EXCEL code:
> >
> >Use the following function to extract the first name:
> >=LEFT(A1,FIND(" ",A1)-1)
> >
> >
> >Use the following function to extract the middle name:
> >=IF(ISERR(MID(A1,FIND(" ",A1)+1,IF(ISERR(FIND(" ",A1,FIND
> (" ",A1)+1)),
> >FIND(" ",A1),FIND(" ",A1,FIND("",A1)+1))-FIND(" ",A1)-
> 1)),"",MID(A1,FIND("
> >",A1)+ 1,IF(ISERR(FIND(" ",A1,FIND(" ",A1)+1)),FIND
> ("",A1),FIND("
> >",A1,FIND(" ",A1)+1))-FIND(" ",A1)-1))
> >
> >
> >Use the following function to extract the last name:
> >=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-
> LEN(SUBSTITUTE(A1,"
> >","")))))
> >
> >
> >Since there is no SUBSTITUTE function in SharePoint, How
> do I accomplish
> >extracting the last name?
> >
> >Thanks,
> >John
> >
> >
> >.
> >
- Next message: Mike Walsh [MVP]: "Re: Email not firing in WSS ADCM host header site"
- Previous message: Damian: "Re: Usage analysis processing stopped working"
- In reply to: Ian Morrish: "HELP - Extracting First, Middle and Last Name"
- Next in thread: John: "Re: HELP - Extracting First, Middle and Last Name"
- Reply: John: "Re: HELP - Extracting First, Middle and Last Name"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
