Post reply

compare data formats using lookup/conditional split

  • August 28, 2015 at 9:21 am

    #398958

    I have an ID which is of the format xx.xxxxxxx (10 digit). I want to separate all the ID's which are not in this format and send them to an error table. How can i do it?

  • August 28, 2015 at 9:50 am

    #1823092

    I would use a conditional split and check that the id (as a string) is 10 characters long and has its first 2 characters being numeric, the third character being a period, and the last 7 characters numeric.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply