Ahmed Fawad
Board Regular
- Joined
- Mar 1, 2011
- Messages
- 63
- Office Version
- 2016
- Platform
- Windows
Hi
here is the table
[TABLE="width: 666"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]26I337[/TD]
[TD] TAMWEEL [/TD]
[TD] ORGANIZATION [/TD]
[TD] DUBAI [/TD]
[/TR]
[TR]
[TD]26I338[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I339[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I340[/TD]
[TD] Bassam A.A. Chilmeran [/TD]
[TD] PERSON [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I341[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I342[/TD]
[TD] ZIAD OMAR ZIAD JAAFAR ALASKARI [/TD]
[TD] PERSON [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I343[/TD]
[TD] NAILA JAMAL MAJID BIN THENIYA [/TD]
[TD] PERSON [/TD]
[TD] DUBAI [/TD]
[/TR]
[TR]
[TD]26I344[/TD]
[TD] Landbanc Limited [/TD]
[TD] ORGANIZATION [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I345[/TD]
[TD] Faris Al-Azzawi [/TD]
[TD] PERSON [/TD]
[TD] Abu Dhabi [/TD]
[/TR]
[TR]
[TD]26I346[/TD]
[TD] Said Abdelhamid Kayali [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I347[/TD]
[TD] Amir Seyed Ali Lajevardi [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I348[/TD]
[TD] Muhammad Asad Iqbal [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I349[/TD]
[TD] Walid Abdulrahman Alturki [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I350[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I351[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I352[/TD]
[TD] Zaid Fadhel Abdul Rassool Ali [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
</tbody>[/TABLE]
thats the data and here I'm doing input to get the details:
[TABLE="class: cms_table, width: 921"]
<tbody>[TR]
[TD]Cluster[/TD]
[TD]Property[/TD]
[TD]Name[/TD]
[TD]Type[/TD]
[TD]City[/TD]
[TD]REMARKS[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Now from data from data LOCATION CODE will be cluster # and 12th entry
i.e. cluster 26 property 12 is the 12th Entry of series starting from digit 26.
Now i need the name of the customer from 12th entry of series starting from 26 locationcode. every series has 16 entries.
Any help ?
here is the table
[TABLE="width: 666"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]26I337[/TD]
[TD] TAMWEEL [/TD]
[TD] ORGANIZATION [/TD]
[TD] DUBAI [/TD]
[/TR]
[TR]
[TD]26I338[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I339[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I340[/TD]
[TD] Bassam A.A. Chilmeran [/TD]
[TD] PERSON [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I341[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I342[/TD]
[TD] ZIAD OMAR ZIAD JAAFAR ALASKARI [/TD]
[TD] PERSON [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I343[/TD]
[TD] NAILA JAMAL MAJID BIN THENIYA [/TD]
[TD] PERSON [/TD]
[TD] DUBAI [/TD]
[/TR]
[TR]
[TD]26I344[/TD]
[TD] Landbanc Limited [/TD]
[TD] ORGANIZATION [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I345[/TD]
[TD] Faris Al-Azzawi [/TD]
[TD] PERSON [/TD]
[TD] Abu Dhabi [/TD]
[/TR]
[TR]
[TD]26I346[/TD]
[TD] Said Abdelhamid Kayali [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I347[/TD]
[TD] Amir Seyed Ali Lajevardi [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I348[/TD]
[TD] Muhammad Asad Iqbal [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I349[/TD]
[TD] Walid Abdulrahman Alturki [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
[TR]
[TD]26I350[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I351[/TD]
[TD] Al Wathba National Insurance Co. [/TD]
[TD] ORGANIZATION [/TD]
[TD] ABU DHABI [/TD]
[/TR]
[TR]
[TD]26I352[/TD]
[TD] Zaid Fadhel Abdul Rassool Ali [/TD]
[TD] PERSON [/TD]
[TD] Dubai [/TD]
[/TR]
</tbody>[/TABLE]
thats the data and here I'm doing input to get the details:
[TABLE="class: cms_table, width: 921"]
<tbody>[TR]
[TD]Cluster[/TD]
[TD]Property[/TD]
[TD]Name[/TD]
[TD]Type[/TD]
[TD]City[/TD]
[TD]REMARKS[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Now from data from data LOCATION CODE will be cluster # and 12th entry
i.e. cluster 26 property 12 is the 12th Entry of series starting from digit 26.
Now i need the name of the customer from 12th entry of series starting from 26 locationcode. every series has 16 entries.
Any help ?