> On 24 Jun 2021, at 6:55 pm, post...@ptld.com wrote:
>
> MYSQL_TABLE
> Is there a way to get a partial part of %u in result_format?
>
> Pseudocode concept: result_format = %d/%u[2]/%u/
> So "u...@example.com" becomes "example.com/us/user/"?
Not via mysql_table(5), but if you use pipemap with a pcre_table(5)
to postprocess the mysql result, you may be able to get there.
But care is required for tables that return multiple comma-separated values,
in which case pipe_map is not a good idea, because you can't generally parse
possibly quoted comma-separated values with regexp tables.
If the map happens to be recursive, you could instead just list two tables,
with the pcre table only matching results that are not yet transformed into
the desired format.
Fortunately, virtual_mailbox_maps needs to produce a single result, so you
can use pipemap there...
--
Viktor.
