locked
Trim Name in MS Access RRS feed

  • Question

  • User-1888080761 posted

    Hi All,

    I am very new to MS Access. I have list of
    names like this in a column in my access and would need to trim the names like
    below.

    Names:

    Clooney, George Timothy
    Willam Pitt,
    Brad
    Wilson, Larry

    Expected Output:

    Clooney,
    George
    Willam, Brad
    Wilson, Larry

    I need to have the first word before and after the comma. Also on top of this I need to add a space after comma.

    Really appreciate suggestions.

    Thursday, September 25, 2014 9:04 AM

Answers

  • User1918509225 posted

     Hi vignesht5,

    If you want to the first word before and after the comma,

    The expected Output for your second row should be:
    Pitt

    Not

    William, Brad

     

    If I misunderstand you, please elaborate your question more exactly.

     

    Best Regards,

    Kevin Shen.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, September 25, 2014 9:59 PM