Extract from Text Box in Excel
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
nadiahghzli
6 - Meteoroid
‎06-24-2024
12:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi community, anyone know how to extract text from shape in excel?
For example, here is the text box in Excel:
I would like Alteryx to read it as two rows:
placeholder
alteryx
I am planning to use macro because I am running for a few excel files with similar format, which one of the tabs that I need Alteryx to read consists of text box. Here is the example data and workflow. Thank you in advanced for your help !
Labels:
- Labels:
- Input
1 REPLY 1
erickyaparevalo
7 - Meteor
‎06-27-2024
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
it was interesting solving this topic. Here you can fin attached the macro you have shared but with some modifications. Instead of reading the xml, I read as csv (plain text). This way we can parsing using "XML Parse" tool (twice). You can set up properly inside your workflow.
Let me know if this works for you!