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
Output |
ABC.ABCDE |
DEF.DEFHJ |
123.12345 |
TERT.TERTIAR |
AA2.AA2AA |
ABJ.ABJKA |
RED.REDFE |
TTY.TTYKE |
TERT.TERIAR1 |
DFR.DFRT |
LMN.LMNHT |
Can someone please help me?
Solved! Go to Solution.
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
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.
Hi @hash_89 I mocked up a workflow using Regex let me know what you think?