topic Re: RegEx for splitting data in Dashboards & Visualizations

RegEx for splitting data

Kaushaas — Thu, 13 Jun 2024 09:31:04 GMT

Hi All,

I have a raw message which contains Action name like below :

CommBank.Api.PricingExtractor.Controllers.EventPublishController.PublishEventsToKafkaTopics (CommBank.Api.PricingExtractor)

which I have extracted using below regular expression

rex field=message "ActionName\\\":\\\"(?<ActionName>[^\\\"]+)"

Is there a way to extract only last part after "." and before "(" i.e "PublishEventsToKafkaTopics" just this I tried few ways but was getting error.

Any help will be appreciated
Thanks in advance

Re: RegEx for splitting data

glc_slash_it — Thu, 13 Jun 2024 06:52:38 GMT

Hi,

try this after your rex.

| rex field=ActionName "\.([^\.]+)\s*\("

Re: RegEx for splitting data

bowesmana — Thu, 13 Jun 2024 06:58:46 GMT

You can try this

| rex field=message "ActionName\\\":\\\"(\w+\.)*(?<ActionName>\w+)"

which will look for all package names up to the last . and then extract the class name based on \w+ rather than everything up to the final quote

If your package or class names contain chars other than \w then adjust accordingly.

Re: RegEx for splitting data

Kaushaas — Thu, 13 Jun 2024 10:31:38 GMT

This worked thanks a lot

Re: RegEx for splitting data

Kaushaas — Thu, 13 Jun 2024 11:19:17 GMT

@bowesmana
Thanks for the solution

| rex field=message "ActionName\\\":\\\"(\w+\.)*(?<ActionName>\w+)"

this worked tried similar thing to extract name from below url using below reg ex what did I miss it didnot work i replaced . to /? If you could ecplain to it will be helpful

URL --- /api/v1/Publish value expected ---- Publish

| rex field=message "reqPath\\\":\\\"(\w+\/)*(?<reqPath>\w+)"

Thanks a ton in advance

Re: RegEx for splitting data

mitcheljohns — Thu, 13 Jun 2024 11:52:07 GMT

Regular expressions (RegEx) are powerful tools for splitting data based on patterns. dish tv billing issues Use split() with a RegEx pattern to segment text into manageable components, such as dividing a string by commas or spaces. For instance, split(/[,\s]+/). Customize patterns to match specific delimiters or structures in data, ensuring accurate segmentation for tasks like parsing CSV files or extracting structured information from unformatted text.

Re: RegEx for splitting data

bowesmana — Fri, 14 Jun 2024 01:30:43 GMT

Try this

| rex field=message "reqPath\\\":\\\".*/(?<reqPath>\w+)"

where the .* is a greedy capture up to the final / character