Hi,
I'm still relatively new to Perl, but have managed to put together some scripts for work.
The latest one I'm making is taking a CSV file of data, and creating an XML output.
One of the fields in in all UPPERCASE, and I need to reformat it to Upper Then Lower.
For example the data coming in is like:
LONDON GATWICK
BELFAST
SHETLANd ISLAND
PRAGUE
And I need output to be:
London Gatwick
Belfast
Shetland Island
Prague
I have tried various tr statements, and have nearly got a workable solution using an if (pattern match), but I'm still failing to get the UPPERCASE on the second word.
If someone could point me in the direction I need to go I would be really greatful, I'm pulling my hair out at the moment as this is the last step in the script.
Thanks in advance!
Anthony
I'm still relatively new to Perl, but have managed to put together some scripts for work.
The latest one I'm making is taking a CSV file of data, and creating an XML output.
One of the fields in in all UPPERCASE, and I need to reformat it to Upper Then Lower.
For example the data coming in is like:
LONDON GATWICK
BELFAST
SHETLANd ISLAND
PRAGUE
And I need output to be:
London Gatwick
Belfast
Shetland Island
Prague
I have tried various tr statements, and have nearly got a workable solution using an if (pattern match), but I'm still failing to get the UPPERCASE on the second word.
If someone could point me in the direction I need to go I would be really greatful, I'm pulling my hair out at the moment as this is the last step in the script.
Thanks in advance!
Anthony