How do we find bad data in a file?
- Akshya Chopra
- Registered Member
- Posts: 80
- Joined: Mon May 20, 2013 11:32 pm
- enrico-sorichetti
- Global Moderator
- Posts: 843
- Joined: Wed Sep 11, 2013 3:57 pm
Re: How do we find bad data in a file?
define what you consider bad dataHow do we find bad data in a file?
without that any answer will rank from useless to wrong
note ...
x'05' is a perfectly good char for binary and packed numerics
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort

- Robert Sample
- Global Moderator
- Posts: 1903
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: How do we find bad data in a file?
It depends upon what you mean by "bad data" -- since what you consider bad may be perfectly valid. For example, consider the hex characters X'0097995D'. If they are treated as packed decimal, the value is -97995. If they are treated as binary, the value is 9,935,197. If they are treated as EBCDIC characters, they are "<nul>pr)"
So which interpretation is "correct" and which are "bad data"? That totally depends upon how you look at the value. All three interpretations are of the same data and may represent something good.
So which interpretation is "correct" and which are "bad data"? That totally depends upon how you look at the value. All three interpretations are of the same data and may represent something good.
- enrico-sorichetti
- Global Moderator
- Posts: 843
- Joined: Wed Sep 11, 2013 3:57 pm
Re: How do we find bad data in a file?
again ...
DEFINE WHAT YOU CONSIDER BAD DATA
DEFINE WHAT YOU CONSIDER BAD DATA
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort

Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute