Try these
Use this if part numbers are numeric only.
cat my_flat_file | sed /"^[0-9]\{8\}[^0-9].*$"/d
Use this if part numbres are alpha-numeric, and columns are seperated by
whitespace
cat my_flat_file | sed /"^[0-9a-zA-Z]\{8\}.*$"/d
These will both simply delete(from view, not from the file) compliant
entries, displaying only non-compliant entries.
On Thu, 2002-09-19 at 10:38, Matthew Bettinger wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> I know this is off topic however I hope someone can help.
>
> I have a flat file that I need to import into a database. The first field of
> the file is a part number which cannot exceed more than 8 characters.
>
> Does anyone know how I can use sed to count the characters in the first field
> and if there are more than 8 print out a list?
>
> Thank you.
>
> Matt
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.7 (FreeBSD)
>
> iD8DBQE9ieFpXG7+MmNwciURAqRxAJsES932AbaFG0w4+1oGU+K6reogEwCgoEdx
> ZEf/Vi3j8vq8HbO4t7gSAqY=
> =taxV
> -----END PGP SIGNATURE-----
>
>
> To Unsubscribe: send mail to [EMAIL PROTECTED]
> with "unsubscribe freebsd-questions" in the body of the message
>
To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message
