jonnyrobert
New Member
- Joined
- Feb 12, 2015
- Messages
- 4
Hi, had a good look but could not find an exact answer...
I am looking to categorise each text description into 1 of say 10 categories. I need to assign multiple words to equal each particular category, if 1 or more of those words occur then the category that they correspond to will be displayed in the final column.
I have found several posts relating to text search resulting in true/false result but how do I get a result where it shows which category the description falls into?
Key example:
Text Category
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>
Thanks!!!
Raw data comes in as below
<COLGROUP><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 218pt; mso-width-source: userset; mso-width-alt: 10642" width=291><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1499" width=41><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><TBODY>
</TBODY>
I am looking to categorise each text description into 1 of say 10 categories. I need to assign multiple words to equal each particular category, if 1 or more of those words occur then the category that they correspond to will be displayed in the final column.
I have found several posts relating to text search resulting in true/false result but how do I get a result where it shows which category the description falls into?
Key example:
Text Category
spreader | spreader |
twin | spreader |
frame | spreader |
control | control |
panel | control |
power | control |
gantry | gantry |
(A) | Assist |
Assist | Assist |
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>
Thanks!!!
Raw data comes in as below
Work Order | Description | Haslog | Engineer | Location | Asset | Status | Reported Date | Priority | Owner Group | Parent WO | Out of Service | Known Cost |
2364905 | QC17 TTY LOST spreader | Y | 8952 | TTYQC17 | J3900 | CLOSE | 30/11/14 05:01 | PFLFSQUD | N | 8.71 | ||
2364210 | QC17 TTY NO UNDERCAB FLOODLIGHTS spreader | Y | 7183 | TTYQC17 | J3900 | CLOSE | 30/11/14 02:26 | PFLFSQUD | N | 279.37 | ||
2364101 | Liebherr Remedials - PLC Mounts broken (A) | N | 8972 | TTYQC17 | J3900 | CLOSE | 29/11/14 10:34 | PFLFSQUD | N | 0 | ||
2364100 | Liebherr Remedials - Hoist Drive Fans U/S ~ Replace (A) | N | 8972 | TTYQC17 | J3900 | CLOSE | 29/11/14 10:33 | PFLFSQUD | N | 0 | ||
2364099 | Liebherr Remedials - Hoist Drive Fans U/S ~ Replace gantry | Y | 8972 | TTYQC17 | J3900 | CLOSE | 29/11/14 10:32 | PFLFSQUD | N | 0 | ||
2364098 | Liebherr Remedials - PLC Mounts broken | Y | 7979 | TTYQC17 | J3900 | CLOSE | 29/11/14 10:31 | PFLFSQUD | N | 10.32 |
<COLGROUP><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 218pt; mso-width-source: userset; mso-width-alt: 10642" width=291><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1499" width=41><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><TBODY>
</TBODY>