Findstring startpoint

[Renjie]

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 solution]

@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 solution]

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

[Renjie]

Thanks！

[MarqueeCrew]

@AdamR_AYX,

If I were using a STRING function, I might use this:

Getword(ReplaceChar([Field1], ".", ' '),1)

By replacing the "." with a space, you can find the second word (1 is zero based and results in the 2nd word).

Cheers,

Mark