Search Results

Thanks buddy ., its working ...this is what i was looking for...

INput file attached in thread : Column widths at 24,73,82,87,121 characters (sed 's/./,/24;s/./,/73;s/./,/81;s/./,/87;s/./,/121;s/ *, */,/g' fixedinputfile >output.csv
). The client wants instead of...

input file attached

INput file is already in this thread provided firstly ., again iam providingthe input file..request your help on this

Input file (each line is separaed by spaces )given below:



Code:...

Thanks buddy...it works ..One more question is Since you have hard-coded the column widths at 24,73,82,87,121 characters (sed 's/./,/24;s/./,/73;s/./,/81;s/./,/87;s/./,/121;s/ *, */,/g'...

thanks it works ...

is it possible to do a error check if more than 5 commas in every line then throw a .err (example) or some error.

Thanks ..

i also need a shell script if to get "CSV separated Input file" from output file (spaces separated) as given ...I mean reverse one..including 5 comma's in every line as given in CSV...

Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location...

Input file pasted above :

First field (Name)=23 characters
second field(Domain) =60
Third field(contatc) =0
fourth field (Phone)=0
fifth field (Email)= 36
Sixth field =not needed as it is...

its not working ..The input file is pasted with sapces and i need output file in CSV format.
egrep -v '^$|^#' inputfile.txt | tr ' ' ',' >outputfile.csv is working but all spaces are replaced by...

Output file in CSV format below(each line should have 5 commas ., if more than 5 commas then shell script should thrown error..please help wit the code):

Name,Domain,Contact,Phone,Email,Location...

Input file (each line is separaed by spaces )given below:

Name Domain Contact Phone Email Location...

Hi

Thanks for your reply ...Its working But Client also needs



{It also might be worth running an error check for the number of "commas" in each line of the created csv file.
There...

The File is spaces separated :Example for first three rows.,

Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------...

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given

Name Domain Contact Phone Email Location
-----------------------...

Hi

The above code is working., could you please help with code for above "output file" conversion to CSV Format..

Request you to please add other columns in above awk script as when iam...

My Mgr wants below input text file to give output as CSV file using shell script :input file ( Comma is the...