Can you help me to find logic like this, traverse through the row and find 'Break' key word and record left instance to 'Break' as Out_Time and right instance as In_Time. It will be helpful for me because our previous logic won't work for below data.
Thats getting pretty complex. You could use index() to search for the position of Break...but maybe even this is not enough for all your data. Maybe you should split the string in several fields or store them as several values in one field underneath each other...just some idea. Please post this again in a new thread - I think this needs some time and ideas of other users