Please help me if you can.....
In below example, I am hard coding numbers for subfield map substring. Is it possible to create a variable in dashboard and allow user to select his own number? By that user can take a look number of characters before and after based on his/her input.
In below, I am asking to show 10 characters before and 10 characters after key word. The goal is user can pass that value from dashboard.
===========================================================================================
Terms:
LOAD
subfield(MapSubString('KeywordMap', upper(Review)), '|') as Keyword
,mid(Review,index( Review, subfield(MapSubString('KeywordMap', upper(Review)), '|')),10 ) as Mid_Example_Plus
,mid(Review,index( Review, subfield(MapSubString('KeywordMap', upper(Review)), '|')) -10,10 ) as Mid_Example_Minus
,index( Review, subfield(MapSubString('KeywordMap', upper(Review)), '|')) as index_example
RESIDENT Reviews
;
============================================================================================