C_Monster221
New member
- Local time
- Yesterday, 23:11
- Joined
- Jan 23, 2009
- Messages
- 8
Hi All,
I am trying to create a function that will do the following:
Search 12 fields of a table looking for a bit of text. If the text is found then i need to display a field next to that text. Example I wish to search for CPR, from any of the 12 fields. The word CPR appears in Field3 I now need the function to return the text in field3exp. In total there are 24 fields, 12 for search and 12 for answer.
Setup is as follows:
Field1, Field1exp, Field2, Field2exp, Field3, Field3exp, ...
I need to include a null friendly function idea.
I am trying to create a function that will do the following:
Search 12 fields of a table looking for a bit of text. If the text is found then i need to display a field next to that text. Example I wish to search for CPR, from any of the 12 fields. The word CPR appears in Field3 I now need the function to return the text in field3exp. In total there are 24 fields, 12 for search and 12 for answer.
Setup is as follows:
Field1, Field1exp, Field2, Field2exp, Field3, Field3exp, ...
I need to include a null friendly function idea.
