How to trap certain values within a txt file

[Jake5]

Hello,

For the attached txt file, I am trying to get Alteryx to isolate values where the row record begins with DPSREP001.  Taking the first record for example, I would like for a new column that extracts the last 20 characters from that value (i.e. 00024163155313876574).  The next row where this would occur is row 5, where it would extract the value 99992117261753263908.  For rows where DPSREP001 isn't the lead off value, it is ok for this new column to return a blank value.  Is there a way to accomplish this?  Thank you.

[alexnajm · Accepted solution]

Can you filter to where your field StartsWith DPSREP001? Then work from there?

[Jake5]

Thank you!  That worked.