I have below data:
SFDC,SID,MID,ACT
DC02,SID1,GOAL,['view_goal_list']
DC02,SID1,GOAL,['view_goal_card,expand_panel,view_goal_card']
DC02,SID1,GOAL,['view_goal_list,select_user,select_user']
......
and now i want to get the number of elements in ACT column for each row.
SFDC,SID,MID,ACT,stepCount
DC02,SID1,GOAL,['view_goal_list'], 1
DC02,SID1,GOAL,['view_goal_card,expand_panel,view_goal_card'], 3
DC02,SID1,GOAL,['view_goal_list,select_user,select_user'], 3
......
how to get the number here?