1 Reply Latest reply: May 15, 2014 10:15 AM by Olly Bond RSS

    Capturing Variable Data

    FFFCU _

      I'm trying to capture varying data in a report.  The data contains the account number (can contain numbers only up to 999999) and then a loan (L) or share (S) type code.  Some example of the data are below.  I would like to capture the account number and product type separately.

       

                 112758S6

               128550S6.1

                 160823S6

                  98079S1

                206793L17

               149724L4.1

       

      Thanks for your suggestions!

        • Capturing Variable Data
          Olly Bond

          Hello FFFCU, and welcome,

           

          Without a bigger extract from the report, in CODE tags, it's hard to see the full picture, so this may not be the simplest answer...

           

          You can do this using Calculated Fields in the table view. I'm assuming that you don't need to add up account numbers so I've left everything here as character strings.

           

          Assuming that you've managed to trap the whole field as a character string called , then the is:

           

          extract(extract(;"";"S");"";"L")

           

          The remainder will be:

           

          extract(;[Account];"")

           

          The S or L character will be:

           

          left(;1)

           

          If you need help trapping, please do post a sample showing the complete line, and indicate if the report is fixed width or PDF...

           

          Best wishes,

           

          Olly