RegEx Dictionary for Fund ID :

How can we help you today?

Start a new topic

RegEx Dictionary for Fund ID

Sarah Fox

started a topic over 3 years ago

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

John Shephard

said over 3 years ago

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