Jump to content
Sign in to follow this  
ann_bas

Manipulating field data

Recommended Posts

Hi,

I have a field where I have first name and last combined but a comma in between them like Smith,John. I have over 70,000 names. So I can't manually separate these first name & last name. Is there a way I can separate these first name & last name? Any help would be greatly appreciated!

Edited by Guest
The Topic: <a href="http://fmforums.com/forum/showtopic.php?tid/202928">Manipulating field data</a> was moved from <a href="http://fmforums.com/forum/showforum.php?fid/34">Value Lists</a> to <a href="http://fmforums.com/forum/showforum.php?fid/31">Calcul

Share this post


Link to post
Share on other sites

Create two field name_last and name_first.

Then do the following:

Show All Records

Click into field name_last

Replace field contents [ name_last; GetValue ( Substitute ( YourCurrentNameField; ","; ¶ ); 1 ) ]

Click into field name_first

Replace field contents [ name_first; GetValue ( Substitute ( YourCurrentNameField; ","; ¶ ); 2 ) ]

Share this post


Link to post
Share on other sites

Hi John,

I'm I misreading this need?

Why use the Replace, these would be new calculation fields, and you would be leaving the FullName field intact..

Lee

Share this post


Link to post
Share on other sites

Perhaps I misunderstood the needs here. Yes she can create a calc but under normal circumstances, the first and last names should really be broken out to their own separate fields anyway. Just my cents of course. :o

Share this post


Link to post
Share on other sites

Here are two calculations that I got from comment.

Calc for First Name

Right ( FullName ; Length ( FullName ) - Position ( FullName ; "," ; 1 ; 1 ) )

Calc for Last Name

Left ( FullName ; Position ( FullName ; "," ; 1 ; 1 ) - 1 )

Note, the FullName field is your name where the data is now.

HTH

Lee

Share this post


Link to post
Share on other sites

Oops, I posted the same formula John did.

Edited by Guest
It should work - make sure result is of type text, not number.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.