Start a new topic

RegEx Dictionary for Fund ID

We are trying to create a RegEx Dictionary to translate a Luminate Desinee to a RE Fund ID. The format for the Designee is : 42.10004 - Steven & Peggy Beverly - Sri Lanka

We only need the first part for Fund ID like this 42.10004. Those are the RE Fund IDs. What RegEx would do that? Essentially we just need to make everything after 42.10004 blank.

Thank you.

1 Comment

Hi Sarah,


Is the pattern for fund always 2 numbers, then a period then 5 numbers?  If so this should work for you. Value to match on (?<=\d{2}\.\d{5}).* Replacement Value: --BLANK--


Thanks,


John

Login or Signup to post a comment