Details
-
Type:
Story
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: Data Loader 1.0
-
Fix Version/s: Data Loader 1.0
-
Component/s: Data Loader
-
Labels:None
Description
Google rejects the keyword otherwise.
This is how the current script checks for BA's that have keywords with an apostrophe not proceeded by an s:
select kwl.businessFunctionID businessArea,kw.* from biz_function_location.keywordLists kwl join biz_function_location.keywords kw on (kwl.id=kw.keywordListID) where (kw.keyword REGEXP '\'[^s]')=1;
