compare data formats using lookup/conditional split

• s.kandepi3

  Mr or Mrs. 500

  Points: 581

  More actions

  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?

• Alvin Ramard

  SSC-Forever

  Points: 41190

  More actions

  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]