Can I use a formula in EDT?

Question
1

Hi, I use to use formula

=MID(C2,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},C2&“0123456789”,1)),LEN(C2)+1)),LOOKUP(1,0*MID(C2,ROW(INDIRECT(“1:”&LEN(C2))),1),ROW(INDIRECT(“1:”&LEN(C2)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},C2&“0123456789”,1)),LEN(C2)+1)))

Can it be used in EDT or only in excel?
Just wondering
Kim

2

Hi,

No, you cannot use Excel Formulas in EDT. Take for example the formula you have pasted, the functions which are used in the formula is only available in Excel, so EDT will not know how to proceed.

Transforms are the EDT formulas, by which you modify data as per your need.

If you put some example data and what that formula is producing, we might try to see if that is possible using the transforms in EDT.

2 Likes
3

I didn’t think I could and honestly, I use EDT on a daily now I have all my projects saved as EDT. This is just a one off I have to use a formula in excel. It’s not that important to me to get it working in EDT.

Thanks

1 Like
4

MIght be a case for Javascript.

1 Like
5

Easy Data Transform doesn’t support Excel formula. The closest you can get is the Javascript transform. We think Easy Data Transform transforms are much easier to understand than Excel formula.