[SOLVED] CB Auto Action - Field substitution based on REGEX

Hello,

I would like to create an action after Profile Update.
Is it possible to put a REGEX in the field action value ?

If yes ... what is the syntax (delimiter) ?

Thanks !

Hello,

Suppose I have a multicheckbox [cb_variable] that contains Value1|*|Value2|*|Value3
Is it possible to replace field by Value1|*|Value2 ?

If yes how can I fill the value ? [cb_variable(1)] + [cb_variable(2)] ?

Thanks !

You can't use REGEX in a value. You can combine substitutions though. Example as follows.

Field: Text Field
Operator: Set
Value: [cb_fieldname1] [cb_fieldname2]

It does not do math either so don't try to use a + expecting it to add the 2 values as it'll just add the + as part of the value. If you need complex calculations either pre-calculate the new value with a CB Query Field and set the field to that query fields value or use a Query action and directly change the value via database queries.

Hi Krileon,

Thanks for your answer. Query action seems to work.
I only need now to substring my [cb_field] before updating my table (REGEX or each other substring solution).

--> Example input before update cb_field = Value1|*|Value2|*|Value3|*|Value4

I do my REGEX to only kept the 2 first value --> Value1|*|Value2

--> Example input before update cb_field = Value1|*|Value2|*|Value3|*|Value4|*|Value5

I do my REGEX to only kept the 2 first value --> Value1|*|Value2

Suggestion to do that ?

It doesn't do that. It doesn't apply logic to substitutions. You'll need to use CB Query Field to format the field value using database functions then substitute the query field in as its value or just use a Query action to adjust the field value using database queries and using database functions to format it.

Hi Krileon,

I have exactly what I want !

For your info I create a function in mysql :

CREATE FUNCTION SPLIT_STR(
x VARCHAR(255),
delim VARCHAR(12),
pos INT
)
RETURNS VARCHAR(255)
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),
delim, '');

After that in CB Auto Action I have the following Query to only keep the 2 first selected items of a Mutliple Check Box :

UPDATE `vksup_comprofiler` SET `cb_languesparlees` = CONCAT(SPLIT_STR(`cb_languesparlees` , '|', 1),'|*|',SPLIT_STR(`cb_languesparlees` , '|', 3));

It seems to work perfectly !

You can close this issue and many thanks for the time you spend to answer to our topic !