topic Re: Replace number with generic string in DQL

Replace number with generic string

educampver — Thu, 01 Jun 2023 06:55:35 GMT

Hi,

How can I replace a numeric (or other pattern) string with a generic one? For example, my DQL query returns:

/v1/shipments/customer-picked-up /v1/shipments/containers/100000011782/hold-locations /v1/shipments/2023051723300410000038807/assigned-user

But I'd like to format them into something like this:

/v1/shipments/customer-picked-up /v1/shipments/containers/[n]/hold-locations /v1/shipments/[n]/assigned-user

Thanks!

Re: Replace number with generic string

stefan_eggersto — Thu, 01 Jun 2023 10:54:46 GMT

Hi @educampver ,

you can use the parse command to extract the part before and after the pattern, and append to join the parts, including a replacement string:

data record(a="/v1/shipments/customer-picked-up"), record(a="/v1/shipments/containers/100000011782/hold-locations"), record(a="/v1/shipments/2023051723300410000038807/assigned-user")
| parse a, "'/v1/' LD:b int LD:c"
| fields result = if(isNull(b), a, else:concat(b,"[n]",c))