Every now and then I run into this situation where I have to create a new Java entity from a table and I have created this formula to generate the names of the fields which works really efficiently every time in MS Excel.
=CONCATENATE(LOWER(LEFT(SUBSTITUTE(PROPER((SUBSTITUTE(A1,"_"," ")))," ",""),1)),RIGHT(SUBSTITUTE(PROPER((SUBSTITUTE(A1,"_"," ")))," ",""),LEN(SUBSTITUTE(PROPER((SUBSTITUTE(A1,"_"," ")))," ",""))-1))
=CONCATENATE(LOWER(LEFT(SUBSTITUTE(PROPER((SUBSTITUTE(A1,"_"," ")))," ",""),1)),RIGHT(SUBSTITUTE(PROPER((SUBSTITUTE(A1,"_"," ")))," ",""),LEN(SUBSTITUTE(PROPER((SUBSTITUTE(A1,"_"," ")))," ",""))-1))
No comments:
Post a Comment