conversion of spaces into CSV format file Post: 302520413

Sponsored Content

Top Forums Shell Programming and Scripting conversion of spaces into CSV format file Post 302520413 by sreenath1037 on Saturday 7th of May 2011 02:04:01 AM

05-07-2011

Registered User

converting spaces input file from one of the backup commands into CSV format file

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 hard coding the column widths as they are not fixed .he has given the hint stating that (
----------------------- ------------------------------------------------ ------- ----- --------------------------------- ---------------------------------------- second line in Input file attached in thread)

In second line of input file .and asked to
generate variables 1 to 6 = field 1 colunm width, field 2 column width, etc then use these to divide each row of data. could any please help on this..

could someone help with shelll script code .,

attachd inout file.txt (5.9 KB)

Last edited by sreenath1037; 05-07-2011 at 03:11 AM..

sreenath1037

View Public Profile for sreenath1037

Find all posts by sreenath1037

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Flat File Conversion Format

Hi all, I've a flat file in this format: = " Record 1 Field1 -> XXXX Field2 -> 9558 Field3 -> 55AA Record 2 Field1 -> YYYY Field2 -> 12345 Field3 -> aa23 " And i want to convert it to

2. Shell Programming and Scripting

DateTime Format Conversion in a File

Hi Pals. I have a file which is in the below format. 2007/10/15-12:04:24,'CRLift','TH-42PX75U','BestBuy','W01P0207',22,15,'User1' 2007/10/15-12:04:26,'CRLift','TH-42PX75U','BestBuy','W01P0207',22,15,'User2' 2007/10/15-12:04:29,'CRLift','TH-42PX75U','BestBuy','W01P0207',22,15,'User3'...

3. Shell Programming and Scripting

Conversion of .xls file to .csv file

Hi Folks, I've to convert manually couple of *.xls files to *.csv files everyday :( so i was just wondering if anyone could just help me with a shell script or awk script to automate the process :) PS : Problem is that i cannot use any third party software for the conversion. Thanking...

4. Shell Programming and Scripting

Flat file to csv conversion

Hi Guy's can someone help me in converting the following I have a flat text file which has several thousand lines which I need to convert to a csv it's got a consistent format but basically want every time it hit's txt to create a new line with the subsequent lines comma delimited for example ...

5. Ubuntu

Conversion of the format of a file in linux

How to convert a rtf file to a ttf file in ubuntu terminal?

6. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

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 ----------------------- ------------------------------------------------ ------- ----- ---------------------------------...

7. Shell Programming and Scripting

Conversion of spaces Text file into CSV format file

Input file (each line is separaed by spaces )given below: Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- -----...

8. Shell Programming and Scripting

Conversion of xhtml data into csv format using dump utility

Hi Unix Gurus, I tried to convert the attached xhtml table content into csv file using unix shell script (lynx -dump filename) and got the below results: Title ID Owner Priority Estimate Project Change Date Changed By Complexity Create Date Created By Detail Estimate Total De tail...

9. Shell Programming and Scripting

perl : number to date conversion in CSV file

I have a CSV file in the below format. while generating CSV file from excel sheet , date in excel sheet(Format :Mon 8/28/2012) got converted into the below format with numbers 41148,41149 so on. Could anyone please let me know how to the convert the numbers(41148,41149 so on.) to its actual...

10. UNIX for Beginners Questions & Answers

Conversion of Binary csv file

Hello, I have a binary csv file that was created on 'Red Hat Enterprise Linux Server release 6.6'. Now we have transferred all files on Ubuntu 16.04.2 LTS/xenial On opening the file in Ubuntu, there are special characters ...

LEARN ABOUT DEBIAN

rackdiag

NWDIAG(1)						      General Commands Manual							 NWDIAG(1)

NAME

       rackdiag - generate rack-structure-diagram image file from spec-text file.

SYNOPSIS

       rackdiag [options] files

DESCRIPTION

       This manual page documents briefly the rackdiag commands.

       rackdiag is generate sequence-diagram image file from spec-text file.

OPTIONS

       These  programs	follow	the  usual  GNU  command  line	syntax, with long options starting with two dashes (`-').  A summary of options is
       included below.	For a complete description, see the Info files.

       -h, --help
	      show this help message and exit.

       --version
	      show program's version number and exit.

       -a, --antialias
	      Pass diagram image to anti-alias filter.

       -c FILE, --config=FILE
	      read configurations from FILE.

       -o FILE
	      write diagram to FILE.

       -f FONT, --font=FONT
	      use FONT to draw diagram.

       -T TYPE
	      Output diagram as TYPE format.

SEE ALSO

       The programs are documented fully by
       http://blockdiag.com/en/nwdiag/

AUTHOR

       rackdiag was written by Takeshi Komiya <i.tkomiya@gmail.com>

       This manual page was written by Kouhei Maeda <mkouhei@palmtb.net>, for the Debian project (and may be used by others).

								   June 11, 2011							 NWDIAG(1)