<html>
<!-- BEGIN WEBMAIL STATIONERY -->
<head></head>
<body>
<!-- WEBMAIL STATIONERY noneset -->
<DIV></DIV>
<P>It looks like the last field is just a string with spaces at every 7th character. It should be easy to split such a string into an array. Will that fix it?</P>
<P> </P>
<P>If you actually have empty fields, then you could do the reverse with the non-empty fields and combine them into an array.</P>
<P> </P>
<P>I don't know what programming languages you use, but this should be easy in PHP, Java, C#, or JavaScript. I haven't used PERL for so long, I can remember anything about it, but I suspect it is just as easy to do in PERL or any other programming language.</P>
<P> </P>
<P>Carl Olsen</P>
<P><A href="http://www.carl-olsen.com/">http://www.carl-olsen.com/</A></P>
<P><BR> </P>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">-------------- Original message from Dave Weis <djweis@internetsolver.com>: -------------- <BR><BR><BR>> <BR>> I have a small file processing problem. I have a file consisting of rows <BR>> like this: <BR>> DESMIAAW RT 6650 ASHWORTH RD WDMNIAAQ 410701 410702 <BR>> 410704 410801 <BR>> 410803 411101 <BR>> <BR>> DESMIAAW DSLAM 7410 ASPEN DR WDMNIAIA ADSL 410801 <BR>> The first row has a variable number of 6 digit numbers at the end, the <BR>> row after doesn't have that. I need to end up with the row "normalized" <BR>> so if it gets in a row with 6 numbers at the end, I want six rows out <BR>> with each number in the sequence at the end. There can be up to 9 of the <BR>> numbers at the end. <BR>> <BR>> I can do something similar in perl or awk but never bothered to learn <BR>> how to do the variable number of repeating numbers bit. <BR>> ____
___________________________________________ <BR>> Cialug mailing list <BR>> Cialug@cialug.org <BR>> http://cialug.org/mailman/listinfo/cialug </BLOCKQUOTE>
<!-- END WEBMAIL STATIONERY -->
</body>
</html>