How to search 25 digit numbers to find and compare a subset?

[walsh_david]

Hello,

we have a system that receives data from multiple sources each of these sources identifies the data being sent by a 25digit number, this number can be broken down by a combination of the positions, the number comes in the following format:

TTWWWWWSSSYYMMDDCCCCCPL

What I am trying to do is extract the CCCC portion of the number (Positions 19-23) and compare this with a lookup table to identify the sender of the information and then sort the associated data by the sender

[richgalloway]

The substr function should do it.

| eval CCCC = substr(bigNumber, 19, 4)