Match a specific CSV field.

Published on Tue Mar 01 2022

Fields terminated by ';' even if the fields are surrounded by " does not accept newlines. Change the central qualifier to get the column. if you want the Xth field write X-1 and use the 3° mathing group OR write X and use the 2° match.

Additional matching regexes for
Match a specific CSV field.

Match a specific CSV field.

Fields terminated by ';' even if the fields are surrounded by " does not accept newlines. Change the central qualifier to get the column. if you want the Xth field write X-1 and use the 3° mathing group OR write X and use the 2° match.

CSV parsing

matches the exact fields of CSV files supports: qouted fields quoted fields containing commas, doubble quoutes, and newlines empty fields empty records arbitrary white space in, and outside quoted fields

CSV line parsing

Captures all fields from a CSV file's line. Can be customized with user-defined field separator and protecting character.

log4j log parsing

This pulls out all the fields in a log4j field. Suitable for use in a Logstash Grok pattern or similar

Match at least 2-letters (international)

RegExp to match that user has entered at least 2-letters (including international letters) in a field

create or change one optional part to another

Skip match process when S exist, or remove optional left most target T, capture left and right part of T. Use case: if N is not exist, modify/change T to N, or create N. If any create or modify write operated, appending output N to right using subsitution "$1$2N".

Numeric values greater than zero with decimal

Pattern that only accept numeric value and greater than zero with up to decimal places( you can change the decimal places just replace {1,2} depend on how many decimal places you like

phone number

accept number , space, . and -

order by field and direction

order by field and direction

Find Chapter (eBook)

Find an specific TAG and return his content