Separate text in column and copy to anoter column

(0) Share

Report

Posted on by JeffC

I have a column called Employee Name which has a first and last name (ex. Joe Smith) separated by a space. I Need to pull out the first name and first two letters of the last name (joesm) and then copy it to another column.

I have tried the split, replace, text and several other functions and can't get it to work. I have tried to get the data before the space and then the data after the space but it still fails.

Any help would be greatly appreciated.

Thank you!

All responses (1)

Answers (0)

Ventit 410 on at

Like (0)

Report

Re: Separate text in column and copy to anoter column

I assume you do a get items if so add 2 compose actions after the Get items

Use expression
Compose1: add(indexof(Namefield,' '),1) - This gets count to the space between names
Compose2: concat(substring(Namefield,0,Compose1),Substring(Namefield,Compose1,2)) - Adds the firstname and the gets the first two letters of surname and adds it

You may need to tweak the counts slightly but should give you a start