Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Data splitting help

SCK
8 - Asteroid
‎02-20-2021 05:02 AM

Hi all, need help in splitting the data i have before as input and output:- Please help

 

Input:

 

02 00 WARRANTY/CARS  I84388001
02 00 WARRANTY-43050 I84454001
02 00 712253 I84586001
02 00 4551235398 I79304001
14 00 I0957 45512045 OA20191119001 C001 
02 00 4551194900 H87 OA20200319001 C001 03/19/20
02 00 R&D CYLINDERS  I84449001
02 00 WARRANTY-43050 I84454001

02 00 WARRANTY & Cycle-43050 I84454003

 

Output:

 

0200WARRANTY/CARS  I84388001  
0200WARRANTY-43050 I84454001  
0200712253 I84586001  
02004551235398 I79304001  
1400I0957 45512045  OA20191119001C001  
02004551194900 H87 OA20200319001 C001 3/19/2020
0200R&D CYLINDERS  I84449001  
0200WARRANTY-43050 I84454001  
0200WARRANTY & Cycle-43050 I84454003  
Reply
0 Likes
1 REPLY 1
PhilipMannering
16 - Nebula
16 - Nebula
‎02-20-2021 06:19 AM

Hi @SCK 

 

Something like this might help,

 

PhilipMannering_0-1613830659205.png

 

The regex works for these specific cases. You might need to edit if the data changes considerably for other records.

 

Data splitting help.yxmd
Reply
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All