Extract Text

[BRRLL99]

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

Consolidation of Shares

Reduction of Capital

Dividend - Rs. - 6.0000

EXPECTED OUTPUT

Purpose	Dividend
Interim Dividend - Rs. - 25.0000	Interim Dividend - Rs. - 25.0000
Scheme of Arrangement
Interim Dividend - Rs. - 6.2500	Interim Dividend - Rs. - 6.2500
Final Dividend - Rs. - 10.0000
Consolidation of Shares
Consolidation of Shares
Reduction of Capital
Dividend - Rs. - 6.0000

[Amol_Telore]

@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. 

[Adrian_T · Accepted solution]

Hi @BRRLL99,

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. 🙂

[binuacs]

@BRRLL99 You can also use the StartsWith string function

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