none
REPLACE LEADING NUMBERS IN DERIVED COLUMN

    Question

  • HI ALL,

    i have column which brings 561;#fullname from sharepoint list.

    i've wrote a derived column expression to display it as fullname (after elminating leading numbers and characters)

    here is the expression does the trick for me

    LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(ManagerName,"0",""),"1",""),"2",""),"3",""),"4",""),"5",""),"6",""),";",""),"#","")))

    but, i was just wondering is there a better expression to eliminate all the numbers, characters and special characters?

    please let me know if you know

    thanks

    Monday, October 14, 2013 8:58 PM

Answers

All replies