RegEX Parse - Tokenizer

[dhakim1996]

Hi, 

I am trying to use regex tokenizer function to remove ":" from a specific column. 

Input	Desired Results
Administrative Expenses:Dues and subscriptions	Administrative Expenses Dues and subscriptions

Could someone please let me know what should be in this "Regular Expression"

Much appreciated. Thank you!

[DataNath]

Hey @dhakim1996, if you're just wanting to replace the : then you don't need to use RegEx - you can just use the replace() function like so:

Replace([Input], ':', ' ')

Edit: If you do insist on using RegEx, then you'd need the tool in the 'Replace' mode and just type in : as your target and a space as the replacement

[dhakim1996]

Hi @DataNath I would like to remove ":" and also separate it out into new columns like this. Any possible solution?

Input	Desired Results
Administrative Expenses:Dues and subscriptions	Administrative Expenses	Dues and subscriptions

[DataNath]

Oh I see @dhakim1996! In that case, I would just use the Text to Columns tool, with : as the delimiter and the number of rows as 2:

[PhilipMannering]

The tokenize expression would be `[^:]+`, but do it @DataNath's way.

[binuacs]

@dhakim1996 one way of doing this with the tokenize method