adventofcode.com is an annual challenge to do various programming problems, in any language. I tried the first one and it was pretty easy to do in Easy Data Transform.
Can anyone do it in less transforms (without using the Javascript transform)?
Easy Data Transform is not intended to be a full fledged programming language, so it may not be possible to do all the questions. But we would be curious to know how many it can do, if anyone feels like trying it.
As for Day 3, I had a look at it, and to solve it, I need to know which transform, can I use to get the starting position of a string with in a string? As I could not find one or you can tell which transforms could be used to achieve this?
I don’t think that is at possible at present, without using the Javascript transform. However it shouldn’t be hard to add to Calculate 2 extra operations:
indexOf - Returns the index position of the first occurrence of the string2 in string1. Returns -1 if string2 is not found.
lastIndexOf - Returns the index position of the last occurrence of the string2 in string1. Returns -1 if string2 is not found.
nasty suggestion to get the position of a string in a string:
use split column and use the searched string as delimiter. Then you can calculate the length of the first resulting column. This plus 1 is the start position of the string within the longer string.