Is there a way to manipulate the output values on dt.select?

Help Studio
, ,
1

Is there a way to manipulate the output values on this? like string manipulation replace

image
image1836×152 9.11 KB

1 Like
2

Hi @joscares

If you mean to make those columns dynamic, then of course you can, if not please provide more context or expected output

Regards

3

Yes, you can manipulate the values in your filter expression using string manipulation functions. Here’s an example of how you can use the Replace function to replace a substring in your filter expression:

lessCopy code

dtSearchResult.Select("[Source) = " + "090691 53133".Replace(" ", "") + " AND [Target] = " + "09391297555" + " AND [Amount) = " + "P700.00" + " AND [Transaction Date] LIKE '%" + "2023-03-10".Replace("-", "") + "96%'").Length > 0

In this example, the Replace function is used to remove any spaces in the “Source” value and to remove any hyphens in the “Transaction Date” value. You can modify this example to perform other types of string manipulation as needed.