I need to pull a text string position from an array field.
In our "resolution" field, I need to pull only records which contain the text string "Document ID." Some records contain this text, some don't.
I also need to pull subsequent text based on this. For instance, whenever "Document ID" is in the array, it is always followed by a space, then an ID number. That number is what I really need to pull, and to use as a group.
When I add the table to my report, and then attempt to create an "IsIn" calculation, the array field does not show up as a usable field.
Why not?
How do I use this array field?
Any/all help would be GREATLY appreciated.
In our "resolution" field, I need to pull only records which contain the text string "Document ID." Some records contain this text, some don't.
I also need to pull subsequent text based on this. For instance, whenever "Document ID" is in the array, it is always followed by a space, then an ID number. That number is what I really need to pull, and to use as a group.
When I add the table to my report, and then attempt to create an "IsIn" calculation, the array field does not show up as a usable field.
Why not?
How do I use this array field?
Any/all help would be GREATLY appreciated.