Hi @HarutaNguyen1 :
Could you tell me:
- Is the function you need like this——
If this is the case, there are several key points to achieve it：
- Find all characters in the string that meet the format of "##/##/####".
- Identify the characters found (use the code you provided).
- Replace the original string with keywords.
I've made a test for your reference(If you are not interested in problem-solving ideas, you can directly look at the final solution at the bottom):
Step1:Find all characters in the string that meet the format of "##/##/####".
I used the following code:
MatchAll("on 12/12/2012, I have a cat and on 14/12/2012, I have a dog","\S\S\/\S\S\/\S\S\S\S")
Step2:Identify the characters found (use the code you provided).
I used the following code:
AddColumns(
MatchAll("on 12/12/2012, I have a cat and on 14/12/2012, I have a dog","\S\S\/\S\S\/\S\S\S\S"),
"Input",
If(
IsMatch("12/12/2012", "^(((0[1-9]|[12]\d|3[01])\/(0[13578]|1[02])\/((19|[2-9]\d)\d{2}))|((0[1-9]|[12]\d|30)\/(0[13456789]|1[012])\/((19|[2-9]\d)\d{2}))|((0[1-9]|1\d|2[0-8])\/02\/((19|[2-9]\d)\d{2}))|(29\/02\/((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))))$"),
"Input OK",
"Input must contain letters and numbers"
))
I added a new field "Input" to store the replacement value
Step3:Replace the original string with keywords.
If you need to implement all replacements, you must traverse the table created in the Step2 stage. However, the ForAll function has great limitations and cannot be used here. In the end, I chose to use the timer control to traverse the entire table.
The final solution
Add a timer control:
OnSelect
Set(
var,
"on 12/12/2012, I have a cat and on 14/12/2012, I have a dog"
);/*Store the string to be processed in the variable var*/
ClearCollect(
mycollection,
AddColumns(
MatchAll(
var,
"\S\S\/\S\S\/\S\S\S\S"
),
"Input",
If(
IsMatch(
"12/12/2012",
"^(((0[1-9]|[12]\d|3[01])\/(0[13578]|1[02])\/((19|[2-9]\d)\d{2}))|((0[1-9]|[12]\d|30)\/(0[13456789]|1[012])\/((19|[2-9]\d)\d{2}))|((0[1-9]|1\d|2[0-8])\/02\/((19|[2-9]\d)\d{2}))|(29\/02\/((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))))$"
),
"Input OK",
"Input must contain letters and numbers"
)
)
);/*Store the found target value and replacement value in the collection mycollection*/
Set(
Count,
1
)/*Count is a custom variable*/
Duration
500 /*loop in 0.5s*/
OnTimerEnd
Set(
var,
Substitute(
var,
Last(
FirstN(
mycollection,
Count
)
).FullMatch,
Last(
FirstN(
mycollection,
Count
)
).Input
)
);
Set(
Count,
Count + 1
)
Repeat
Count<CountRows(mycollection) /*End the loop when Count>CountRows(mycollection)*/
Finally, the processed string will be stored in the variable var
Best Regards,
Bof
