How to copy only the words that match the pattern in the data of the Text file and paste it into Excel?

[Famui_Yanisa]

I have a text file Inside there is text “123CAT456789”
I want to copy only the word “CAT” into a text file automatically, what should I do?

[arjunshenoy]

Hi @Famui_Yanisa, welcome to the Community.

Please try the following expression in the Assign activity:

extractedWord = System.Text.RegularExpressions.Regex.Match(yourfileNameText, "\bCAT\b").Value

Hope this helps,
Best Regards.

[lrtetala (Lakshman Reddy)]

Hi @Famui_Yanisa

Try this

[Tushar1 (Tushar)]

Hi
Please try the following expression in the Assign activity:

extractedWord = System.Text.RegularExpressions.Regex.Match(yourfileNameText, "\d*CAT\d*").Value

[arjunshenoy]

@Famui_Yanisa

Another alternate approach:

outputText = System.Text.RegularExpressions.Regex.Match(yourFileText, "(?<=\d)CAT(?=\d)").Value

Hope this helps,
Best Regards.