Extracting values from Text files using RegEx

[jerry_jk]

Hi All.

I'm trying to extract a value from text file (Swift Message) & export to excel using RegEx and Parser but is not giving desired results.  Below is example of dummy data.

{

:16R:LINK

:20C::TRRF//JU41114

:16S:LINK

}

{

:16R:LINK

:20C::TRRF//5241520926595

:16S:LINK

}

{

:16R:LINK

:20C::TRRF//4111452201

:16S:LINK

}

Expected Output

TRRF

JU41114

5241520926595

4111452201

[Luke_C · Accepted solution]

Hi @jerry_jk 

Here's a regex and non-regex way to do this.

[jerry_jk]

Thanks @Luke_C .