Web Scraping
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
AliciaN621
5 - Atom
‎08-05-2024
12:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, how do I determine the delimiter field in the "Text to Columns?"
Labels:
1 REPLY 1
perin
8 - Asteroid
‎08-06-2024
08:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Alicia,
Normally, using the text to columns tool you need to type in the delimiter.
If you have some dynamic format, where this delimiter is in another field and changes from row to row, my suggestion is to create a macro and filter by these specific delimiters and update the parameter of the text to columns tool using a control parameter.
Best,
Gustavo.