Add spaces before capital letters in camel case string

Utkarsh_ — Tue, 08 Jun 2021 10:07:43 GMT

I have a field in which values are in the camel case. I want them to be in proper format with spaces between each word.

For example in the below table:

Porter

AddressUnlocatable_

RestrictedAreaAM_

CustomerShifted_

I want its values to be like:

Porter

Address Unlocatable

Restricted Area AM

Customer Shifted

I have tried this:

| rex field=Porter mode=sed "s/_//g s/A/ A/g s/B/ B/g s/C/ C/g s/D/ D/g s/E/ E/g s/F/ F/g s/G/ G/g s/H/ H/g s/I/ I/g s/J/ J/g s/K/ K/g s/L/ L/g s/M/ M/g s/N/ N/g s/O/ O/g s/P/ P/g s/Q/ Q/g s/R/ R/g s/S/ S/g s/T/ T/g s/U/ U/g s/V/ V/g s/W/ W/g s/X/ X/g s/Y/ Y/g s/Z/ Z/g s/A M/AM/g"
| eval Porter=trim(Porter)

This is working fine but it is making my queries very long. Can anyone suggest a smaller query to do the same?

Re: Add spaces before capital letters in camel case string

ITWhisperer — Tue, 08 Jun 2021 10:26:03 GMT

| rex field=Porter mode=sed "s/(?<capital>[A-Z]+)/ \1/g s/_//g" | eval Porter=trim(Porter)

topic Re: Add spaces before capital letters in camel case string in All Apps and Add-ons

Add spaces before capital letters in camel case string

Re: Add spaces before capital letters in camel case string