Extracting characters within certian pattern including square brackets

[#1]

Hi,
I have want to extract information from a text in a table row that includes square brackets.
Example Rows in text column:
Plate[QWE147] Reg[ABC123]
Plate[ASD258] Reg[DEF456]

Information I want to extract:
ABC123

DEF456

What is the best way to do this? I wanted to do it with regex but square brackets makes it complicated.

[#2 · Accepted solution]

You have to do some escaping

Names Default To Here(1);

str1 = "Plate[QWE147] Reg[ABC123]";
str2 = "Plate[ASD258] Reg[DEF456]";

Show(Regex(str1, "Reg\!\[(.+)]$", "\1"));
Show(Regex(str2, "Reg\!\[(.+)]$", "\1"));

[#3]

Also using Word(-1,...) might be enough if your strings are simple enough

Names Default To Here(1);

str1 = "Plate[QWE147] Reg[ABC123]";
str2 = "Plate[ASD258] Reg[DEF456]";

Show(Word(-1, str1, "[]")); // Word(-1, str1, "[]") = "ABC123";
Show(Word(-1, str2, "[]")); // Word(-1, str2, "[]") = "DEF456";

[#4]

Thank you. This works perfect. Could you please explain why "$" is in the code?

[#5]

Most likely unnecessary, but it just tries to make sure it matches at the end

[#6]

You can also use the word function:

Names Default To Here(1);
str1 = "Plate[QWE147] Reg[ABC123]";
str2 = "Plate[ASD258] Reg[DEF456]";
show(word(4, str1, "[]"));
show(word(4, str2, "[]"));