topic Re: Happy new DemandTool user - Can we find match on "last letters"? in DemandTools

Happy new DemandTool user - Can we find match on "last letters"?

CatherineL — Tue, 07 Feb 2023 21:42:52 GMT

Hi! I'm fairly new to DemandTool but I'm already a fan. I've been using the match functionality A LOT. Super happy that I don't have to play with excel sheets and lookups as much anymore..

I like being able to save my "scenarios" so I can just rerun them when needed. It took me a second to see that I could share those saved sceanrios between my different sandboxes and not have to recreate them in each of them...!

One question that I have (I don't know if it's possible), when we do a match is it possible to do a match on part of the field? let's say my match file has "04578" but I'm trying to match with a field that contains "XP-04578" I know I can add that in excel but would there be a way to just look at the last numbers ? There is comparison type for First X Letters. Is there a way of doing this for the Last X Letters maybe?

Re: Happy new DemandTool user - Can we find match on "last letters"?

ShubhC_Validity — Wed, 08 Feb 2023 06:19:08 GMT

Hi Catherine,

Welcome to Validity Community . Great to know that you are enzoying your journey with DemandTools.I am from Validity Technical Support Team and happy to help you .

Yes it is possible to Match for the last letters by using Add Selection Condition and Add Condition option.

Step 1 (Add Selection Condition )

Step 2 (Add Condition)

I hope above information is helpful.

Regards,

Shubhra

Re: Happy new DemandTool user - Can we find match on "last letters"?

DanW_Validity — Wed, 08 Feb 2023 17:22:48 GMT

Hi @CatherineL

To achieve this you can use Comparison Type "Regular Expression"

Regular Expression: Creates custom mapping types for any text field. Knowledge of regular expressions is required to use this mapping type. There are several free regex tutorial websites online that may want to reference to learn more.

Regular Expression mapping will use the first match located in the string:

Example:
Regular Expression: [0-9]+
Input data: 123 S Main St
Result: 123

Perhaps there is a fellow DemandTools Community member that is familiar with RegEx that could provide an expression that fits your use case.

Thank you for your post we really appreciate your engagement!

Dan

Re: Happy new DemandTool user - Can we find match on "last letters"?

CatherineL — Fri, 10 Feb 2023 13:24:35 GMT

Hi yes, thanks for the hint I was able to do this regex 2 ways :

finding the last 5 characters of my string XP-04578 to match with the number I have :

(.{0,5})$

matching with eveything after "-" in my string XP-04578 to match with the number :

[^-]+$

thanks

Re: Happy new DemandTool user - Can we find match on "last letters"?

AnthonyValidity — Tue, 14 Feb 2023 00:50:24 GMT

Hi @CatherineL ,

I have to say I'm impressed with your RegEx skills! 😁

Do you have any RegEx resources that you think might help other customers? I use a few different sites to navigate RegEx myself. I like to test my expressions using regexr.com.

Thanks,

Anthony
Customer Success Manager

Re: Happy new DemandTool user - Can we find match on "last letters"?

Support_0 — Mon, 25 Sep 2023 23:39:31 GMT

Yes you are greaful