Help in find and replace tool.
- 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
Hi
I am working on a requirement finding and replacing a field for that attached workflow i tried, the data getting truncated in output and for Null its not returning value.
In 1 find and replace tool can we use multiple.
Thanks.
Solved! Go to Solution.
- Labels:
- Best Practices
- Join
- Preparation
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your replacement is truncating because the field isn't large enough to contain the replacement. This is very common with text tool inputs. If you insert a select tool you can see the PO Indicator field size = 2. Increase the size to handle all replacements. (above 5 should be good, maybe above 1,000 to be safe for any text)
Field Size
- 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
tried using select and changed the size to 10000 still its truncating.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
your workflow results are showing the Ye for yes , i used auto field tool also still same Ye.
Thanks.
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks A lot Josh, it worked.
Regards
Shankar
