Extract Dividend

Question

Hi guys,

From the given text i will like extract only Dividend - Rs- 6.00

Final Dividend - Rs. - 10.0000Consolidation of SharesConsolidation of SharesReduction of CapitalDividend - Rs. - 6.0000Interim Dividend - Rs. - 13.5000

EXPECTED RESULT :

Final Dividend - Rs. - 10.0000  Consolidation of Shares  Consolidation of Shares  Reduction of Capital  Dividend - Rs. - 6.0000Dividend - Rs. - 6.00006.0000Interim Dividend - Rs. - 13.5000

Adrian_T · Accepted Answer

Hi @BRRLL99,

Your approach will be similar to my reply to your previous post here. All you would have to do is to change the formula to:

IF StartsWith([Purpose],"Dividend") THEN [Purpose] ELSE "" ENDIF

Hope this helps! 🙂

Qiu · Accepted Answer

@BRRLL99 
I did not quite get your logic but if just to get the needed output.