Extract data from a single cell

Question

I have some set of data all in a single cell.

# Report

# Data(time stamp=2020-05-20 1524)

ABC.ABCDE DEF.DEFHJ 123.12345 TERT.TERTIAR AA2.AA2AA ABJ.ABJKA RED.REDFE TTY.TTYKE TERT.TERIAR1 DFR.DFRT LMN.LMNHT

ABC DEF 123 TERT AA2 ABJ RED TTY DFR LMN

I would need to extract the highlighted set of data. I would need to pull all the data before and after '.' The number of these values are not fixed and can go more than 1000.

My O/P should look like this

OutputABC.ABCDEDEF.DEFHJ123.12345TERT.TERTIAR AA2.AA2AA ABJ.ABJKA RED.REDFE TTY.TTYKE TERT.TERIAR1 DFR.DFRT LMN.LMNHT

Can someone please help me?

Christine_Assaad · Accepted Answer

Hi @hash_89

You can use the Parse Text to Column building blog, based on space (\s) and output the data in rows. Hope this helps

DannyS · Accepted Answer

Hi @hash_89 ,

Since there is a space delimiter for that text data, you could go ahead and use the TextToColumns tool (Parse category) and split your data to rows. See attached workflow for an example with your highlighted data.

JosephSerpis · Accepted Answer

Hi @hash_89 I mocked up a workflow using Regex let me know what you think?