Re^3: Sequential data read in MySQL/Perl

I am also confused about what you are doing. If these 9 values "go together" somehow, then perhaps a table like what I show below is what you need? Each row is a "group" and each column contains "like data". Without some descriptive story re: post from Grandfather, its hard to say what you really need (which may be different than what you are asking for).

1  DATAX DATA2 DATA3 DATA4 DATA5 DATA6 DATA7 DATA8 
2  DATAY DATA2 DATA3 DATA4 DATA5 DATA6 DATA7 DATA8
[download]

Comment on Re^3: Sequential data read in MySQL/Perl Download Code

Replies are listed 'Best First'.
Re^4: Sequential data read in MySQL/Perl by justin423 (Scribe) on Jul 07, 2016 at 01:12 UTC
That is just about what I am asking for. A script to convert each group I encounter on the source file to be stored in a single row like you have done.	[reply]
Re^5: Sequential data read in MySQL/Perl by Marshall (Canon) on Jul 07, 2016 at 01:41 UTC
Ok, does this work for you? Row number would be an auto increment field, so doesn't need to be a field in the SQL INSERT statement. #!/usr/bin/perl use strict; use warnings; my @row; # SQL prepare statement goes here. while (my $line = <DATA>) { next if $line =~ /^\s$/; #skip blank lines if ($line =~ /^\sRECZ/) #end of record { print "@row\n"; #would be DB row insert @row = (); #start new row } else { my @data = (split(' ',$line))[1,2]; push @row,@data; } } =prints DATAX DATA2 DATA3 DATA4 DATA5 DATA6 DATA7 DATA8 DATAY DATA2 DATA3 DATA4 DATA5 DATA6 DATA7 DATA8 =cut __DATA__ REC1 DATAX DATA2 1 REC2 DATA3 DATA4 2 REC3 DATA5 DATA6 3 REC4 DATA7 DATA8 4 RECZ 5 REC1 DATAY DATA2 6 REC2 DATA3 DATA4 7 REC3 DATA5 DATA6 8 REC4 DATA7 DATA8 9 RECZ 10 [download] Update: be careful with that submit button (labeled "stumbit") You made a duplicate post that just causes "noise" that a Janitor has to clean up.	[reply] [d/l]
Re^6: Sequential data read in MySQL/Perl by justin423 (Scribe) on Jul 07, 2016 at 02:12 UTC
Can this be converted into SQL so that it writes out the data to a table instead of a print file?	[reply]
Re^7: Sequential data read in MySQL/Perl by Marshall (Canon) on Jul 07, 2016 at 15:39 UTC
Re^7: Sequential data read in MySQL/Perl by Marshall (Canon) on Jul 07, 2016 at 02:47 UTC
Re^8: Sequential data read in MySQL/Perl by chacham (Prior) on Jul 07, 2016 at 12:58 UTC
Some notes below your chosen depth have not been shown here
Re^4: Sequential data read in MySQL/Perl by justin423 (Scribe) on Jul 07, 2016 at 01:12 UTC
That is just about what I am asking for. A script to convert each group I encounter on the source file to be stored in a single row like you have done.	[reply]