Method findInCell

src/csvtable.cpp:385–435

* Find in cell r,c */

 *	Find in cell r,c
 */
bool CsvTable::findInCell(std::string search, table_index_t r, table_index_t c, bool caseSensitive, bool useRegex) {
	std::string lowerSearch;
	std::tuple<int, std::string> executeReturn;				// for JS search
	
	if( useRegex ) {
		std::string js = "";
		js += "var R = " + std::to_string(r) + "; var C = " + std::to_string(c) + ";";
		js += "var pattern = /" + search + "/";
		if( !caseSensitive ) {
			js += "i";
		}
		js += ";";
		js += R"(
			var found = 0;
			var cell = getString(R,C);
			if( m = cell.match(pattern) ) {
				found = 1;
			}
			__storeInts(found);
		)";
		executeReturn = macro.execute(this, {-1,-1,-1,-1}, js);
		if( std::get<0>(executeReturn) == -1 ) {
			printf("ERROR: %s\n", std::get<1>(executeReturn).c_str());
		}
		std::vector<int> found = Macro::getLastResultInts();
		if( found.size() == 1 && found.at(0) == 1 ) {
			return true;
		}
		return false;
	}
	
	if( !caseSensitive ) {
		lowerSearch = Utf8CppUtils::utf8::casefold(search);
	}
	if( caseSensitive ) {
		if(
			storage.getRow(r).find(search) != std::string::npos &&
			getCell(r,c).find(search) != std::string::npos
		) {
			return true;
		}
	} else {
		if(
			Utf8CppUtils::utf8::casefold(storage.getRow(r)).find(lowerSearch) != std::string::npos &&
			Utf8CppUtils::utf8::casefold(getCell(r,c)).find(lowerSearch) != std::string::npos
		) {
			return true;
		}
	}
	return false;
}