How to get part of a string from a column in Database and put in another column of same database

datatable
robot
activities

#1

How to get part of a string from a column in Database and put in another column of same database.
I need abc from “abc/def/hijk”


#2

@subashini You can do by using split function after spliting store in one variable than pass that variable in new column name