On Tue, 21 Jan 2014 15:49:16 -0800, Shane Konings wrote: > I have the following sample from a data set and I am looking to split > the address number and name into separate headings as seen below. > > FarmID Address 1 1067 Niagara Stone 2 4260 Mountainview 3 25 Hunter 4 > 1091 Hutchinson 5 5172 Green Lane 6 500 Glenridge 7 471 Foss 8 758 > Niagara Stone 9 3836 Main 10 1025 York > > > FarmID AddressNum AddressName 1 1067 Niagara Stone 2 4260 > Mountainview 3 25 Hunter 4 1091 Hutchinson 5 > 5172 Green Lane 6 500 Glenridge 7 471 Foss > 8 758 Niagara Stone 9 3836 Main 10 1025 York > > I have struggled with this for a while and know there must be a simple > method to achieve this result.
Unfortunately the vagaries of nntp, my client and the google nntp posting host are such that I can't discern the format of your data from your post. However, if as I think you have a text field that is always: <1 or more digits><1 or more spaces><the rest> where you want to capture the initial "1 or more digits" and "the rest" as 2 data elements then this should be possible with a simple re: (\d+)\s+(.*) If you have numeric id, whitespace, numeric addr bit, whitespace, the rest, then you may need something more like: (\d+)\s+(\d+)\s+(.*) The assumption is that it's not necessary to hold your hand through the whole looping through the input and applying the re to each line, then reading the captured bits and using them process. -- Denis McMahon, denismfmcma...@gmail.com -- https://mail.python.org/mailman/listinfo/python-list