The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Thursday, April 27 • 1:30pm - 2:30pm
228: String Manipulation and Regular Expressions with SQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Today data get more and more exchanged between multiple platforms and interfaces, in JSON or XML or other text formats. SQL includes methods for consuming XML and JSON. But quite often the data is not in the format, so we can consume it directly. For example, the first and last name is returned as a single value separated with a comma and must be split.  On the other hand, data must sometimes be prepared in a specific way, for example a numeric value must be right adjusted padded with asterics and edited with group and decimal separators. And finally, it is necessary to check the passed data or to search character data if they match a specific format or include a specific sequence. For example, to find all column values that consist not only of digits. Did you know, you can do this directly with SQL? SQL includes a lot of scalar functions for string manipulation including regular expressions for scanning, preparing and converting

Learning Objectives:
Learn what scalar functions for string manipulation are available and how they can be used for concatenating, converting, splitting strings.
For more complex searches learn which regular expression functions are available and how they can be used.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Thursday April 27, 2023 1:30pm - 2:30pm MDT
Governors Square 16
  • Session Level Intermediate
  • Award BRONZE
  • Audience Programmers and SQL users who need to convert or split strings or just want to use what is possible with SQL.