Sponsored Content
Top Forums Shell Programming and Scripting Convert comma text file to Column in html format Post 302302216 by joeyg on Monday 30th of March 2009 11:29:03 AM
Old 03-30-2009
Question Is this what you are trying to do?

Code:
> inv="EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick"
> echo $inv | awk -F"," '{printf("%15s%15s%15s%15s%15s%15s\n",$1,$2,$3,$4,$5,$6)}'
          EQADM  edrtere9-phys      8122caef0        gpatmon       /bin/ksh    nuten Erick

or
Code:
> echo $inv | awk -F"," '{printf("%-15s%-15s%-15s%-15s%-15s%-15s\n",$1,$2,$3,$4,$5,$6)}'
EQADM          edrtere9-phys  8122caef0      gpatmon        /bin/ksh       nuten Erick

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (1 Reply)
Discussion started by: natalie23
1 Replies

2. UNIX for Advanced & Expert Users

Urgent! need help! how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (2 Replies)
Discussion started by: natalie23
2 Replies

3. Shell Programming and Scripting

Is it possible to convert text file to html table using perl

Hi, I have a text file say file1 having data like ABC c:/hm/new1 Dir DEF d:/ner/d sd ...... So i want to make a table from this text file, is it possible to do it using perl. Thanks in advance Sarbjit (1 Reply)
Discussion started by: sarbjit
1 Replies

4. Shell Programming and Scripting

How to format file into comma separated text file?

Hi Guys, I have text file which is tab/space separated but I want it to re-format into a comma separated and trim the spaces in between. Can someone spare me a perl or sed script that can do the job? INPUT FILE: 500010245623 500 21-APR-11 05.58.21 PM ... (14 Replies)
Discussion started by: pinpe
14 Replies

5. UNIX for Dummies Questions & Answers

How to convert a text file into tab delimited format?

I have a text file that made using text editor in Ubuntu. However the text file is not being recognized as space or tab delimited, the formatting seems to be messed up. How can I convert the text file into tab delimited format? (3 Replies)
Discussion started by: evelibertine
3 Replies

6. Shell Programming and Scripting

Convert the date format from mdy to ymd in column of file

The date format in the delimited file for one column '6/27/2011 12:00:00 AM' Is it possible o change it to '2011-06-27 12:00:00 AM' for all the records.. Thanks in advance..... (8 Replies)
Discussion started by: infernalhell
8 Replies

7. Shell Programming and Scripting

Convert text file to HTML tabular format.

Please provide script/commands to convert text file to HTML tabular format. No need of styles and colours, just output and a heading in table is required. Output file will be send via email and will be seen from outlook. (script required without using awk). output file content: (sar... (7 Replies)
Discussion started by: Veera_V
7 Replies

8. Shell Programming and Scripting

Format text file to html

Hi Experts, Anybody out there figure out on how to achieve in shell scripts or tools. I have done googling to find solutions but no luck. I have thousands of .txt files to batch process, please see the below sample text content after -------- start here --------. What I want to achieve is to... (10 Replies)
Discussion started by: lxdorney
10 Replies

9. Shell Programming and Scripting

Loop to convert text output in the HTML format

Hello Everyone, I have a sample file raw.txt as shown below : Drive Bays Bay Name : SD-2C Number of Standby Power Supplies : 4 Number of Drive Enclosures : 12 Summary Status of Contained Modules All... (6 Replies)
Discussion started by: rahul2662
6 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
CUBRID_FIELD_TYPE(3)							 1						      CUBRID_FIELD_TYPE(3)

cubrid_field_type - Return the type of the column corresponding to the given field offset

SYNOPSIS
string cubrid_field_type (resource $result, int $field_offset) DESCRIPTION
This function returns the type of the column corresponding to the given field offset. The returned field type could be one of the follow- ing: "int", "real", "string", etc. PARAMETERS
o $result -Array type of the fetched result CUBRID_NUM, CUBRID_ASSOC, CUBRID_BOTH. o $field_offset - The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level E_WARNING is also issued. RETURN VALUES
Type of the column, on success. FALSE when invalid field_offset value. -1 if SQL sentence is not SELECT. EXAMPLES
Example #1 cubrid_field_type(3) example <?php $conn = cubrid_connect("localhost", 33000, "demodb"); $result = cubrid_execute($conn, "SELECT * FROM code"); $col_num = cubrid_num_cols($result); printf("%-15s %-15s %s ", "Field Table", "Field Name", "Field Type"); for($i = 0; $i < $col_num; $i++) { printf("%-15s %-15s %s ", cubrid_field_table($result, $i), cubrid_field_name($result, $i), cubrid_field_type($result, $i)); } cubrid_disconnect($conn); ?> The above example will output: Field Table Field Name Field Type code s_name char code f_name varchar PHP Documentation Group CUBRID_FIELD_TYPE(3)
All times are GMT -4. The time now is 04:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy