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
J
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--
Sarah Fox
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.