how to differentiate columns of a file in perl with no specific delimiter

Amiya Rath · #1 (**permalink**) 07-12-2008

Hi everybody,
This time I am having one issue in perl.
I have to create comma separated file using the following type of information. The problem is the columns do not have any specific delimiter. So while using split I am getting different value. Some where it is space(S) and some where it is tab(s). in some cases I do not have values under some specific column and these are also filled with tab(s) and /or space(s).
Revsn: Date Who SID Description of Modification
09-Jul-01 Amiya 01-04Jul01 add setdescriptor shortcuts
02-Aug-99 RathA chk include 1st line
remove per VandJ
06-Jan-98 DasP data obsolete...
02-Jul-97 Gupts add DDMM for completeness

I want my output as
09-Jul-01, Amiya,01-04Jul01, add setdescriptor shortcuts
02-Aug-99,RathA,----, chk include 1st line remove VandJ (If line has only description, add to prev line)
06-Jan-98, DasP,----,data obsolete...
02-Jul-97, Gupts,----, add DDMM for completeness
Thanks in advance….

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to remove the specific lines from file using perl	dipakg	Shell Programming and Scripting	4	06-11-2008 02:45 AM
Perl: adding columns in CSV file with information in each	dolo21taf	Shell Programming and Scripting	1	03-05-2008 02:52 AM
replace space with delimiter in whole file -perl	meghana	Shell Programming and Scripting	11	02-19-2008 09:35 PM
cutting columns if delimiter has more than one charecter	mahabunta	UNIX for Dummies Questions & Answers	9	09-14-2006 08:23 AM
Deleting specific columns from a file	premar	Shell Programming and Scripting	11	02-14-2006 07:02 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by