Findstring startpoint

Question

I want to create a new field contains the information between the first "." and the second "." from "123.12345.123456"? I tried findstring but there was no start point like FIND in Excel. Thanks!

MarqueeCrew · Accepted Answer

@Renjie,

I would use a RegEx expressiion like:

REGEX_Replace([Field1], ".*?\.(.*?)\..*", '$1')

This will find the stuff between the first and second "." characters.

Cheers,

Mark

AdamR_AYX · Accepted Answer

Or alternatively you can achieve this with multiple formulas in one tool