Snapshot release 11-Dec-2023

[Admin]

We can carry on this discussion at:

The new Calculate indexOf() and lastIndexOf() operations

Following a discussion in https://forum.easydatatransform.com/t/snapshot-release-11-dec-2023/ I have been looking into handling the edge case where one or both of the text values is empty. I looked at how C++/Qt, Javascript and Excel Find handle this. It is a bit of a mess! [image] The C++ and Javascript functions are 0-based and the Excel function is 1-based. I have decided to use 1-based indexing as it is more friendly to non-programmers. There is no built in Excel equivalent of lastIndexOf…