Blogs tagged regex

ABAP CDS views provide a set of string functions and also support regular expressions from release 7.55. But sometimes your string manipulation requirements go beyond aforesaid capabilities. In this case my blog is for you. Below is a perfect... Read More »

tl;dr : regexes are hard. My half-solution: search for \R and either click “find next” or “replace (with space)”. I can’t remember exactly (do help me out in the comments!), but someone said something along the lines... Read More »

In this blog post, I would like to share the latest news and changes made to Regular Expressions in modern ABAP, mainly from OP release 7.55 & 7.56. Previously, POSIX style regular expressions or “Portable Operating System Interface for... Read More »

Hello Everyone! I am a SAP HANA Senior Consultant working closely with Enterprise HANA and Business Objects Reporting Solutions. Today I would like to share an approach which one might take to identify patterns in each text using HANA Database... Read More »

This blog post is the third and last in a series of blog posts introducing recent changes and enhancement made to regular expressions in the ABAP language. A basic understanding of regular expressions and their syntax is assumed, some experience on... Read More »

This blog post is the second in a series of three blog posts introducing recent changes and enhancement made to regular expressions in the ABAP language. A basic understanding of regular expressions and their syntax is assumed, some experience on... Read More »

Regular expressions have been part of the ABAP programming language for quite some time now. From the beginning, more than a decade ago, there has been only one regular expression flavor, defined by POSIX standard 1003.2 and implemented by the Boost... Read More »

Dear bot builders, I’m happy to share with you our newest features released in SAP Conversational AI in November: Feature of the month ⭐ Regular Expression Entities (Regexp) Train your chatbots faster with regexp entities! Besides free and... Read More »

Have you been using the ISNUMERIC() function of MySQL, MS SQL Server or PostgreSQL and wondered what to use in SAP HANA instead? If so, this is the blog for you. Just recently I’ve seen a customer using my old workaround (first published here)... Read More »

     Sometimes data in Source System is not checked for quality. For example, input data is not checked for non printable characters e.g. tabulation, carriage return, linne feed etc. If user copy and paste data into input fields from email or... Read More »