locked
condition split RRS feed

  • Question

  • hi

    in my conditional split i would liek to know if the field has first letter and length of field is 9

    hwo to do that

    for example in field1 ,the first letter should be between a to z

    Friday, January 18, 2013 4:04 PM

Answers

  • Hi,

     try this expression in conditional split,

              LEN(Column) == 9 && CODEPOINT(UPPER(Column)) >= 65 && CODEPOINT(UPPER(Column)) <= 90


    Thanks & Regards, sathya


    Friday, January 18, 2013 5:32 PM

All replies