BLANK TEXT FILE
- 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
If the text is not having any data then that text file need to be skipped and rest of the text files need to be parsed. Please help me on this
- Labels:
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In these cases, you have to think like the bot -- You want it skipped but the way the bot can "skip" it is by pulling it in and then excluding the blank lines from the data via a filtering tool or something else. I hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
f you give some example will be greatly appreciated
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you have multiple .txt files, input data by using wild card * to read all text data.
Once data is read, use filter tool to filter empty data. *Empty means "Null" or "Empty string". See attached yxzp.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Yuvaraj85 .I think that this is the issue you might be running into.
If so, switch to directory and dynamic input. You can then filter the directory to remove size 0 files:
The remainder of the text files can then flow through the process. You could also set up a run command tool to read in the files from the directory to move or delete size zero files before running your normal workflow. Either method should eliminate the blank text files. If you have headers but no data, use the method shared by @gawa
 
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is not working as we have separate layout file to delimit the text file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Even this is also not working since I have separate layout to delimit it. Once I use filter in the basic filter when I tried to select column it show as no records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Yuvaraj85 Can you please share your workflow so we can help? The directory method I shared will happen before any layouts as the layout will occur in the dynamic input, but I cannot understand what you are describing.
- 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
I see that in the dynamic input you need to change the Action to "Change Entire File Path". Also, the false anchor for the filter would not have any data and would error. You can change to a Browse tool to see which files fail. See attached. Let me know if this is working or if you have any other issues.