Date: 19 Sep 2002 10:53:47 -0400 From: Matt Smith <matt@forsetti.com> To: mbettinger@championelevators.com Cc: freebsd-questions@FreeBSD.ORG Subject: Re: OT sed help Message-ID: <1032447228.18054.2.camel@localhost> In-Reply-To: <200209190938.35632.matt@championelevators.com> References: <200209190938.35632.matt@championelevators.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message
>
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1032447228.18054.2.camel>