sachinviki
New Member
- Joined
- Jul 21, 2017
- Messages
- 3
Dear Experts,
Really first of all i would like to appreciate all the experts here, whenever the question is been raised the response will be immediate or max to max within a day solution will be given.
Here i have come up with an query too..
[TABLE="class: grid, width: 415, align: left"]
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]No[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]Attd. Type[/TD]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]19-07-2017[/TD]
[TD]19-07-2017[/TD]
[TD]A/B[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]20-07-2017[/TD]
[TD]20-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]21-07-2017[/TD]
[TD]21-07-2017[/TD]
[TD]B/A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]22-07-2017[/TD]
[TD]22-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]23-07-2017[/TD]
[TD]23-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]24-07-2017[/TD]
[TD]24-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
This is my existing data.
i want the format like below..
1. if A/B which ever comes before / it will be 09:30 to 13:30
2. if A/B which ever comes after / it will be 13:30 to 18:30 (actually there are more than two variables here i have given only two)
3. if there is an "A" continuously from 1-30th or 1-31st then it should be grouped as
100278 01-07-2017 to 31-07-2017 A
this is my requirement. can anybody help me out?
Really first of all i would like to appreciate all the experts here, whenever the question is been raised the response will be immediate or max to max within a day solution will be given.
Here i have come up with an query too..
[TABLE="class: grid, width: 415, align: left"]
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]No[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]Attd. Type[/TD]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]19-07-2017[/TD]
[TD]19-07-2017[/TD]
[TD]A/B[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]20-07-2017[/TD]
[TD]20-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]21-07-2017[/TD]
[TD]21-07-2017[/TD]
[TD]B/A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]22-07-2017[/TD]
[TD]22-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]23-07-2017[/TD]
[TD]23-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]100278[/TD]
[TD]24-07-2017[/TD]
[TD]24-07-2017[/TD]
[TD]A[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
This is my existing data.
i want the format like below..
1. if A/B which ever comes before / it will be 09:30 to 13:30
2. if A/B which ever comes after / it will be 13:30 to 18:30 (actually there are more than two variables here i have given only two)
3. if there is an "A" continuously from 1-30th or 1-31st then it should be grouped as
100278 01-07-2017 to 31-07-2017 A
this is my requirement. can anybody help me out?