LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Filter Node - remove values

    Employee
    Posted 04-03-2014 05:14

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

    Originally posted by: mw9286

    I have two columns in my output file (First Letter & Number). I want to remove all the First Letter value that have ('M' or 'N') and all the Number Values ('1111' or '222'). My new out file should have no First Letter of ('M' or 'N') or Number Values ('1111' or '222')

    Thank you


  • 2.  RE: Filter Node - remove values

    Employee
    Posted 04-03-2014 06:42

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

    Originally posted by: DanRosenblatt

    You can accomplish this with a Filter node. I'm not sure if you meant that you want to remove the records completely, or if you've used M and N as some sort of marker to be removed from the record itself, so I've included a couple examples in the attached .brg file of filter nodes that might accomplish this. Let me know if this is what you had in mind.
    Attachments:
    FirstLetterNumber.brg


  • 3.  RE: Filter Node - remove values

    Employee
    Posted 04-08-2014 10:19

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

    Originally posted by: mw9286

    Dan: Thank you, this worked perfectly.