Split Line on Uppercase Letter in string

[Trancemission]

Okay I have numerous files which I have exported from my bosses crap contact management system.

The problem is the data is exported all on one line, and where there should be a line break there is nothing, an example:

Some Company;123 My RoadMy StreetCounty

As you can see I can get the company name but the address,street and county are stuck together. What I need is to split the line if a Uppercase Character is next to a lower case charactor.

Any ideas?!?

Cheers

 

[futurelet]

BEGIN { FS=";" }
{ print $1
  rest = $2
  while ( match( rest, /[a-z][A-Z]/ ) )
  { print substr( rest, 1, RSTART )
    rest = substr( rest, RSTART+1 )
  }
  if (rest) print rest
  print ""
}

 

[PHV]

You may try this sed script to create field separators:
sed 's!\([a-z]\)\([A-Z]\)!\1;\2!g' /path/to/input >output.csv

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[futurelet]

If you want ";" between each field:

{ while ( match( $0, /[a-z][A-Z]/ ) )
    $0=substr($0,1,RSTART) ";" substr($0,RSTART+1)
  print
}

 

[Trancemission]

Thanks for your replies,

I am liking the sed example - not really had much experiance with it, will read up. I assume I can turn all the lines in a file [each contact has it's own file] to one line {remove spaces, Chr returns etc] and then merge them files

Thanks again

Trancemission
=============
If it's logical, it'll work!