Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extract data from a single cell

hash_89
8 - Asteroid

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?

 

 

3 REPLIES 3

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

 

christine_assaad_0-1594847161010.png

christine_assaad_1-1594847189891.png

 

DannyS
Alteryx Alumni (Retired)

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
17 - Castor
17 - Castor

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

Labels