Find Text separeted by blank

[hd94]

Hello, 

I have field with long text separeted by blank and i want to keep text with value 'SS'

Exemple : 'TOTO TUTU TITI_SS TOTI TUTI_SS TYTY' 

I want to keep the first text with "SS" , in my example, i want to keep TITI_SS in other field and not TUTI_SS. 

Thank you a lot. 

ps : sorry for my english

HD

[Yousef_Amarneh]

If the length of the word is always fixed (length=7 which is 4 chars and underscore and SS) then you can use the below

Right(SubField(YourColumnName,'SS',1),7) as Column1

[MindaugasBacius · Accepted solution]

The solution:
=Right(Left('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', Index('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', 'SS') + 1),
Len(Left('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', Index('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', 'SS') + 1)) - Index(Left('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', Index('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', 'SS') + 1), ' ', -1))

[hd94]

Thank you very much