Questions

There has to be an easy way to do this....

Tags:
+
0 Votes
Locked

There has to be an easy way to do this....

AnswerMan
I have a column with first name, space, middle initial, period, space, last name. When I try and use the "RIGHT" function to look for the first "space" it's returning some of the last name..... I posted this question a minute ago, but might not have explained it enough. I want to delete the middle initial, and period from the column, leaving just the last name. Is that something that can be done?
  • +
    0 Votes
    AnswerMan

    Never mind I knew I have done this before... it's really only
    =RIGHT(K14,LEN(K14)-3)

    ** Providing you have a known fixed number from the left you want to get rid of. Which still leaves the question, what if you wanted to go from the right, to the first space, and extract that... I've been getting errors on that formula as well...

    +
    0 Votes
    ghislain.levesque

    cat file_in|awk '{print $1,$3}' > file_out

    +
    0 Votes
    ghislain.levesque

    cat file_in|awk '{print $1,$3}' > file_out

  • +
    0 Votes
    AnswerMan

    Never mind I knew I have done this before... it's really only
    =RIGHT(K14,LEN(K14)-3)

    ** Providing you have a known fixed number from the left you want to get rid of. Which still leaves the question, what if you wanted to go from the right, to the first space, and extract that... I've been getting errors on that formula as well...

    +
    0 Votes
    ghislain.levesque

    cat file_in|awk '{print $1,$3}' > file_out

    +
    0 Votes
    ghislain.levesque

    cat file_in|awk '{print $1,$3}' > file_out