LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Hi Team,

In my source file,in few of the columns, need to eliminate starting with 123 value records.
example
12345
12378
12300
please provide what logic we need to apply in split node to reject the records starting value 123.

Regards,
Sree.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hi Sree,

you could try using a left string function
EG left([field],3) != "123" however if these records are integers then you need to turn it into a string to work
EG left([field].str(),3) != "123"

Regards,

Keith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Thanks Keith, its working fine.