topic Re: How to use Regular expression to get characters? in Discussions

How to use Regular expression to get characters?

Sean_ShCn0 — Tue, 27 Aug 2024 18:42:29 GMT

A simple question, please find the attachment as a demo.

the requirement as following, it is required to take some information from :Label column, to two new column, details find the pic "image.png".

thanks in advance.

Sean

jthi — Tue, 27 Aug 2024 19:12:43 GMT

Just based on your example you don't need regex as Word() might be enough

For F

Word(-2, str, ",F+S"); // "18441"

for S

Word(-1, str, ",F+S"); // "18442"

Example

Names Default To Here(1);

str = "-F19,S20+F18441,S18442";

Show(Word(-2, str, ",F+S"));
Show(Word(-1, str, ",F+S"));