Split columns fixed width
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AlteryxDummy01
5 - Atom
‎02-22-2022
04:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I have been trying to use a PDF input converter which works quite well. Although, all the text in the PDF gets converted into one column of Alteryx. I was trying to use different delimiters by using split text to column, but none of them work. Therefore, I think it has to do with the Fixed Width. I am not sure how to use this function if I don't have an .txt input.
Does anyone have a good solution for this?
Labels:
- Labels:
- Custom Tools
- Datasets
- Help
- Tips and Tricks
- Workflow
1 REPLY 1
gabrielvilella
14 - Magnetar
‎02-22-2022
05:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can save it as a text file and then read it using dynamic input. Or you can use RegEx. Another option is the one from this post https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Fixed-Width-Delimiter/td-p/772173
