Script how to remove extension and put in separate column

Does the reply I posted in the other thread answer your question?