CODEWITHSUNDEEP
ms-accessformula
OlaOkland
OlaOkland

Reputation: 95

How to extract words after second colon?

I have tried this one, Mid([Tom]![Subject];InStr([Tom]![Subject];":")+1)

However, this extracts only the text after the first colon.

I need to extract the text after the second colon.

Any ideas?

Upvotes: 0

Views: 191

Answers (1)

Sergey S.
Sergey S.

Reputation: 6336

Use first parameter of InStr function:

Mid([Tom]![Subject];InStr(InStr([Tom]![Subject];":")+1,[Tom]![Subject];":")+1)

Upvotes: 1

Related Questions