Hello:
May I know how to extract data from a tabular file format as attached ?
Output Format 1 Employee No. / Work Hrs 0006677G 20 0014577Z 34 0214911C 56 Output Format 2 (Work Hrs based on 15-07-2016) Employee No. / Work Hrs 0006677G 20 0014577Z 0 0214911C 24 Always take the first match record.Have a nice day.