community Alteryx IO MyAlteryx
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.

DELIMITING TXT FILE

dunkindonut7777
8 - Asteroid
‎02-12-2022 09:31 AM

Hi how can I delimit properly this text file I have. I want to fix it and aligned accordingly.

 

Expected output

 

CODESSCRRRPATERMDTAAARYOKDO
300D000100 
300D000200 

Attached file for your reference. Hope you could help me with this one pls

Preview file
1 KB
Labels:
Reply
0 Likes
2 REPLIES 2
Luke_C
17 - Castor
17 - Castor
‎02-12-2022 09:41 AM

Hi @dunkindonut7777 

 

Here's one way you could do this:

 

  1. Read the data in with no delimiters/column names
  2. Skip the header records
  3. Parse the fields based on the | delimiter
  4. Select/rename the fields
  5. Trim the extra spaces

Luke_C_0-1644687656680.png

 

New Workflow5.yxmd
Reply
ArtApa
Alteryx
Alteryx
‎02-12-2022 08:22 PM

Hi @dunkindonut7777 - Here is a more dynamic solution in case your actual dataset structure is different to the sample:

 

ArtApa_0-1644726095384.png

 

txtFileAA.yxmd
Reply
inspire session catalog
view community live events
Labels
Top Solution Authors
View All