Have trouble with extracting string from column :(

dhxodud96

My purpose was using a Formula tool to write an expression that will extract the contract status from the provided string into its own column.

First i used >>  GetLeft([Info], ";")

Then i used >> Trim([Info],"ContractStatus")

Result is not i expected...

Is there any other ways to solve this problem? 

+ maybe findstring can help but i don't know how to use findstring. If somebody know where i can learn this please link url for me. 

Always thanks for helping me!

extracting string.yxmd

Christina_H

The Trim function removes all characters in the substring from the ends of the original string, which is why you're getting those results.  It doesn't just remove the whole phrase.  You might want a Replace instead, Replace([Info],"ContractStatus","")

Alternatively you can do the whole thing in one formula with Substring:

Substring([Info],14,FindString([Info],";")-14)