0

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?

cheriemilk
  • 149
  • 8

0 Answers0