I want to filter out the fields having the data length more than 100 and show an error.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey,
I need some help to filter out the fields having length more than 100 and show a error message reporting it.
Solved! Go to Solution.
- Labels:
- Help
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Akash01
Please find a workflow attached which looks at cells in a field which are greater than 100 characters in length.
I have used the message tool to create a dynamic error message based on the row and the number of characters in that field
Jordan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JordanB
Thanks for helping me out, but I wanted a standard workflow which would work for every input file having different field names.
It would be time consuming and tiring to put each of the field names in the "formula tool" and checking the length, if a file would be having more fields.
Regards,
Akash
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much @JordanB!
You were a great help. :)
