Sponsored Content
Top Forums UNIX for Dummies Questions & Answers converting a tabular format data to comma seperated data in KSH Post 302205677 by Hemamalini on Monday 16th of June 2008 04:37:15 AM
Old 06-16-2008
Hi Don,

I tried the same its just substituting the one comma for each space.
the space in between the columns are of variable length so could you please help me.

The data in table format will be something like this

User ID Eid T Profile S E
---------- ----------- - -------------------------------------------------- - -
234 1 U Data Administration A
123 2 U M A
and the header gets repeated for every 10 records.
could you please help me n removing the header records in between other than the first line also pls.

Thanks,
Hema.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert the result of the select query to comma seperated data - urgent pls

how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell. Pls help me as its very urgent. Thanks, Hema. (1 Reply)
Discussion started by: Hemamalini
1 Replies

2. Shell Programming and Scripting

Removing blank lines from comma seperated and space seperated file.

Hi, I want to remove empty/blank lines from comma seperated and space seperated files Thanks all for help (11 Replies)
Discussion started by: pinnacle
11 Replies

3. Shell Programming and Scripting

[SOLVED] Converting data from one format to the other

Hi All, I need to convert an exel spreadsheet into a SAS dataset, and the following format change is needed. Please help, this is too complex for a biologist. Let me describe the input. 1st row is generation.1st column in keyword 'generation', starting 2nd column there are 5... (9 Replies)
Discussion started by: newbie83
9 Replies

4. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

5. Shell Programming and Scripting

Extract data in tabular format from multiple files

Hi, I have directory with multiple files from which i need to extract portion of specif lines and insert it in a new file, the new file will contain a separate columns for each file data. Example: I need to extract Value_1 & Value_3 from all files and insert in output file as below: ... (2 Replies)
Discussion started by: belalr
2 Replies

6. Shell Programming and Scripting

Convert data to a tabular format

How can i convert the below data to a simpler format :- cat tabular.txt User 1 Details :- First Name = Tom Middle Name = Last Name = Hanks Age = 40 Address = User 2 details :- First Name = Mike Middle Name = Last Name = Tyson Age = 50 Address = (2 Replies)
Discussion started by: lazydev
2 Replies

7. Shell Programming and Scripting

Converting text files to xls through awk script for specific data format

Dear Friends, I am in urgent need for awk/sed/sh script for converting a specific data format (.txt) to .xls. The input is as follows: >gi|1234|ref| Query = 1 - 65, Target = 1677 - 1733 Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46 fd sdfsdfsdfsdf fsdfdsfdfdfdfdfdf... (6 Replies)
Discussion started by: Amit1
6 Replies

8. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

9. Programming

Visual Basic converting a decimal data type to a label with currency format

Here is the code that I am working with. I have tried several other things. any suggestions? Lbl_Cost_Output.Text = (dDistance * dCostPerMile).ToString("C") The label is formatted correctly in terms of value 0.00 but no dollar sign appears. Please let me know if you have any questions. (1 Reply)
Discussion started by: briandanielz
1 Replies

10. Shell Programming and Scripting

Convert listner.log to csv format with comma seperated

Hi All, I am new to shell scripting i am trying to convert the listner.log to csv which can be inturn converted to excel for easy reading. i used this command awk '/SID=/ && /HOST=/ && /PORT=/ && /USER=/ { i=match($0,"SID="); i=i+RLENGTH; h0=substr($0,i); i=match(h0,")");... (6 Replies)
Discussion started by: skoshekay
6 Replies
Mojolicious::Plugin::Mount(3pm) 			User Contributed Perl Documentation			   Mojolicious::Plugin::Mount(3pm)

NAME
Mojolicious::Plugin::Mount - Application mount plugin SYNOPSIS
# Mojolicious my $route = $self->plugin(Mount => {'/prefix' => '/home/sri/myapp.pl'}); # Mojolicious::Lite my $route = plugin Mount => {'/prefix' => '/home/sri/myapp.pl'}; # Adjust the generated route my $example = plugin Mount => {'/example' => '/home/sri/example.pl'}; $example->to(message => 'It works great!'); # Mount application with host plugin Mount => {'mojolicio.us' => '/home/sri/myapp.pl'}; # Host and path plugin Mount => {'mojolicio.us/myapp' => '/home/sri/myapp.pl'}; # Or even hosts with wildcard subdomains plugin Mount => {'*.mojolicio.us/myapp' => '/home/sri/myapp.pl'}; DESCRIPTION
Mojolicious::Plugin::Mount is a plugin that allows you to mount whole Mojolicious applications. The code of this plugin is a good example for learning to build new plugins, you're welcome to fork it. METHODS
Mojolicious::Plugin::Mount inherits all methods from Mojolicious::Plugin and implements the following new ones. "register" my $route = $plugin->register($app, $conf); Mount Mojolicious application. SEE ALSO
Mojolicious, Mojolicious::Guides, <http://mojolicio.us>. perl v5.14.2 2012-09-05 Mojolicious::Plugin::Mount(3pm)
All times are GMT -4. The time now is 06:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy