I have for example AB2 and A11 as value in a column. I need to now the ASCII code of the second character, B in this case. If this ASCII value is above 65 then I need to split the value in AB and 2 otherwise in A and 11.
Has anyone a solution for this. I can’t use substring, because this will always be the same number of characters
To compare it like @izaychik63 suggested you first need to extract second character. Using substring() function in String Manipulation node for example. Then in Rule Engine node you can have this comparison. Result can be number which you would then use in a substring() function. Or again alternative for whole logic is to use Column Expressions node
The solution @armingrudd provided for this with regex is much better in my opinion.