Left, LTrim, or what

[Guest]

I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

 

[Duane Hookom]

Hopefully your field values are consistent.

Feel free to open a module and search Help on Left, Mid, Instr. You should
be able to figure out the syntax. If not, come back with "a field" name.

 

[Allen Browne]

Use:
- Instr() to locate the comma,
- Mid() to get the remainder of the field,
-Trim() to deal with the space.

So, assuming a field named FullName, the FirstName would be:
Trim(Mid([FullName], Instr([FullName], ",") + 1))

 

[Randy Harris]

I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

Perhaps:

Left([FullName], Instr([FullName], ",") + 2)

 

[Guest]

Yours did it, Randy. Thanks!

Jerry

I have a field with Lastname, Firstname (ex: "Smith, John")

I want to extract the Last name and first initial (ex: "Smith, J).

What's the code?

Thanks in advance.

Jerry

Perhaps:

Left([FullName], Instr([FullName], ",") + 2)