Search Results

Adding to Zaxxon's reply, you may want to check your Admin Panel and see if there is already a front end for MySQL database management.

What are the constants of the file?

Will it always be line 2, field 2?

Thanks everyone! jp's does exactly what I want!

Thanks again!

tail -n 100
head -n 1000

Hope that helps!

EDIT: or use the number you want with the -n switch

jp2542a: Thanks, I will give that a try this morning and see what results I get. I'm not familiar with awk, but plan to learn it so this may be an opportunity.


edidataguy: Thanks for pointing...

Thanks for the reply vgersh99, here is what I am looking for as the output:

UR|007815,TI|Vintage Motorsport : 1995 Jan/Feb,PR|17.50,,,BD|Soft Cover,NT| 82 pgs; magazine format,CO|1,,,SD|2009-08-06...

I am trying to process inventory addition files for insertion into a MySQL database. The format convention is book UIEE. If the field for the add file has no data, the field is NOT included in the...