https://community.qlik.com/t5/App-Development/Textbetween-function/m-p/2428721#M96388 <P>In general it should be performing quite fast because mapping is very fast and also string-functions don't need much processing-power. I don't remember of using textbetween(mapsubstring()) against larger data-sets but multiple and vertically/horizontally nested subfield(applymap()) are performing well in larger datasets.</P> <P>Of course doing the loads without such transformations would be faster especially if the loads could be performed optimized. Maybe more relevant - are there any alternatives with a better performance? Rather not ... from a classical programming point of view the use of REGEX might be an alternatives but it will depend on a lot of circumstances and if an implementation would need some intermediate steps the possible faster string-preparation might not lead to a better overall run-time.</P> <P>Beside of the above if any possible you should apply incremental approaches on larger data-sets.</P> Fri, 08 Mar 2024 12:29:05 GMT marcus_sommer 2024-03-08T12:29:05Z https://community.qlik.com/t5/App-Development/Textbetween-function/m-p/2428651#M96381 <P>Hi All</P> <P>Does using &nbsp;text between and Map substring slow down the app performacne if the volume of data is High? <STRONG>TextBetween(MapSubString('MapTYpe', PRIMARY_ATTRIBUTE_VALUE), '/', '\')</STRONG></P> <P><LI-WRAPPER></LI-WRAPPER></P> Fri, 08 Mar 2024 09:40:31 GMT https://community.qlik.com/t5/App-Development/Textbetween-function/m-p/2428651#M96381 Malanagaraj 2024-03-08T09:40:31Z https://community.qlik.com/t5/App-Development/Textbetween-function/m-p/2428721#M96388 <P>In general it should be performing quite fast because mapping is very fast and also string-functions don't need much processing-power. I don't remember of using textbetween(mapsubstring()) against larger data-sets but multiple and vertically/horizontally nested subfield(applymap()) are performing well in larger datasets.</P> <P>Of course doing the loads without such transformations would be faster especially if the loads could be performed optimized. Maybe more relevant - are there any alternatives with a better performance? Rather not ... from a classical programming point of view the use of REGEX might be an alternatives but it will depend on a lot of circumstances and if an implementation would need some intermediate steps the possible faster string-preparation might not lead to a better overall run-time.</P> <P>Beside of the above if any possible you should apply incremental approaches on larger data-sets.</P> Fri, 08 Mar 2024 12:29:05 GMT https://community.qlik.com/t5/App-Development/Textbetween-function/m-p/2428721#M96388 marcus_sommer 2024-03-08T12:29:05Z