Parsing a name column from first middle last

Hi2023

Hi,

I am working on taking over someones workflow but I havent had much practice with name parsing. The change is that the middle name should be in its own column not with the first name column anymore. The formula is listed below. I am trying to research this but its last minute urgent item so any help wpuld be appreciated and maybe help solve this faster,

thanks

if [ID CODES] != 'FTH'
then
Left([PAYEE NAME],FindString([PAYEE NAME], [OWNER-LAST-NAME])-1)
else null()
endif

I think after this formula is what is seperating this .

Reporting

Accepted answers

All comments

binu_acs

@Hi2023 Can you provide some sample names?

Hi2023

AARON J SMITH

A MALIK

AARON JAY SMITH

AARON JAYA HATH SMITH

AARON SMITH

A G SMITH

binu_acs

@Hi2023 One way of doing this

Screenshot 2023-07-21 061749.png

Split_Name_210723.yxmd

Hi2023

I dont know why but it is not working on each one-it is working on some but not all ????

the names like :

AARON J SMITH

A W SMITH

A SMITH

the initial is gone / blank

Hi2023

I think I just saw the problem -what if I cam just trying to fix it after the formula where it is outputting the first name with middle intial and the last name has already been moved,

like the output are :

AARON J

A W

AARON BI

AARON JAY

in the first name column only I dont have to worry bout the last name part at this moment

thanks

binu_acs

@Hi2023 What are the expected output for the below names

Hi2023

middle initial seperated from first name, but if its more than 10 characters(middle name), then to move over to last name

Input

A J Smith

output

first name A middle name J last name Smith

A LOGNMIDDLE NAME SMITH

first name

Middle

blank

last name

LONGMIDDLENAME

binu_acs

@Hi2023 how would you split the name AARON JAYA HATH SMITH?

Hi2023

hmmm I just checked and I dont have an example like that but its more than 10 characters move all to last name and middle would be blank

binu_acs

@Hi2023 the above example was provided by you

AARON J SMITH

A MALIK

AARON JAY SMITH

AARON JAYA HATH SMITH

AARON SMITH

A G SMITH

Do you want JAYA HATH SMITH should be in last name?

Hi2023

Yes, it was but it an error. If you can just omit that name completely.

Hi2023

So, would the formula be the same?

Hi2023

Hi,

so it is somewhat working but its omiting parts of the name.

One name is BETTY B IGUIRRE BANCHEZ VE LETON

the output is

first name BETTY

middle B IGUIRRE

last name VE

its missing BANCHEZ and LETON

I also changed the middle name to 10 characters bc that is the character limit for middle name only. where is the BANCHEZ and LETON going? I want it all pushed out after it reaches 10 characters in middle name section to go to LAST NAME.

thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703