If fullpath is: "Asset\Current Assets\Bank & Cash\Bank\HSBC" Output required: "Asset Current Assets Bank & Cash Bank HSBC" If fullpath is: "Asset\Current Assets\Bank & Cash\Bank" Output required: "Asset Current Assets Bank & Cash Bank" and so on...........Please help.