Hello Guys, From the given Data-set I'm trying extract only Interim Dividend Interim Dividend - Rs. - 25.0000Scheme of ArrangementInterim Dividend - Rs. - 6.2500Final Dividend - Rs. - 10.0000Consolidation of SharesConsolidation of SharesReduction of CapitalDividend - Rs. - 6.0000 EXPECTED OUTPUT Purpose DividendInterim Dividend - Rs. - 25.0000Interim Dividend - Rs. - 25.0000Scheme of Arrangement Interim Dividend - Rs. - 6.2500Interim Dividend - Rs. - 6.2500Final Dividend - Rs. - 10.0000 Consolidation of Shares Consolidation of Shares Reduction of Capital Dividend - Rs. - 6.0000

Extract Text

Hello Guys,

From the given Data-set I'm trying extract only Interim Dividend

Interim Dividend - Rs. - 25.0000

Scheme of Arrangement

Interim Dividend - Rs. - 6.2500

Final Dividend - Rs. - 10.0000

Consolidation of Shares

Reduction of Capital

Dividend - Rs. - 6.0000

EXPECTED OUTPUT

Datasets

Text Mining

This should work just fine for you. Use a formula tool to create a new column using the following formula:

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

I have also attached a sample workflow for your reference. 🙂

@BRRLL99 You can use Regex tool to parse this data. Set regex tool inn Parse mode and in the regular expression put below syntax.

(^Interim Dividend.*)

It should work.

This should work just fine for you. Use a formula tool to create a new column using the following formula:

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

I have also attached a sample workflow for your reference. 🙂

@BRRLL99 You can also use the StartsWith string function

IIF(StartsWith([Purpose ], 'Interim'), [Purpose ], '')