07-31-2006
Align Text from a file.
I need to align text from a file that has columns seperated by spaces and commas. Any ideas?
Text is similar to this.
File Name is Test.
05/14/06 13:46:56.575 ,TEST,5,123,1234,123,12345,12,12.2,2.1,4.5,5.23
05/14/06 13:49:58.009 ,TEST,6,456,456.7,45,4.56,453,34,54.3,3.2,6.456
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All !!!
I have an HTML file whose contents are as below:
<html>
<body>
<title>This is a test file</title>
<p>PLEASE ALIGN
ME IN ONE
LINE. TEXT....</p>
<h2>This is a Test file</h2>
<p>PLEASE ALIGN
ME IN ONE
LINE. TEXT....</p>
</body>
</html> (2 Replies)
Discussion started by: parshant_bvcoe
2 Replies
2. Shell Programming and Scripting
HI ,
I am new to shell scripting i m getting the below format like this
Name FirstName Lastname
------ --------- ----------
Name1 Balaji NandaKishore
Name123 Vijaya krsihna
... (5 Replies)
Discussion started by: Lucky123
5 Replies
3. Shell Programming and Scripting
Hi All,
I have a file contains below contents, "interfacename/subnet: public (or) interfacename/subnet:cluster_interconnect"
"en2"/10.185.81.0:cluster_interconnect,"en5"/10.185.81.0:cluster_interconnect,"en6"/169.181.146.0:public... (6 Replies)
Discussion started by: kamauv234
6 Replies
4. Shell Programming and Scripting
Input:
hiddenhausen 99.60 y 1.05 2.50 -550 -110 1:25:200
herbstein 99.021 n 1.05 2.50 -550 -110 1:25:200
bangalore 98.82 y 1.05 2.50 -550 -110 1:25:200
golm 98.8 y 1.05 2.50 -550 -110 1:25:200
para 98.82 n 1.05 2.50 -550 -110 1:25:200
bogen 98.61 n 1.05 2.50 -550 -110 1:25:200
saintandre... (5 Replies)
Discussion started by: asavaliya
5 Replies
5. Shell Programming and Scripting
Hi,
I need your help to align data from paragraph.
It's to :
- delete the lign contain NDS
- align data between paragraph start to "ND=" from second "ND="
example of file:
@
ABOIL;
@
CEN=1/15-05-23/09 H 06 MN 18/LISTAGE CARACTERISTIQUES D'ABONNES
TRAITEMENT TGLAIL ACC... (1 Reply)
Discussion started by: vremen3
1 Replies
6. Shell Programming and Scripting
Hi,
I have a question on how to align columns in shellscipt.
SAMPLE
2015-07-15 09:01:00.0 |TCSERVER01 |10965
2015-07-15 09:02:00.0 |TCSERVER01 |4752
2015-07-15 09:03:00.0 |TCSERVER01 |4805
2015-07-15 09:04:00.0 |TCSERVER01 |3690
2015-07-15 09:01:00.0 |TCSERVER02 |8703
2015-07-15... (1 Reply)
Discussion started by: reignangel2003
1 Replies
7. Shell Programming and Scripting
Hello again,
I'm having a issue with a contact form. I want the input fields to be aligned on same row and I really dont know how to do it.
I attached a image for you to understand what i am trying to do.
<BR>
<label for="name" class="required">
Name <strong... (1 Reply)
Discussion started by: galford
1 Replies
8. Shell Programming and Scripting
I have a text file that I filtered using awk. I only exctracted two columns.
I want those two columns to be aligned. Most of the answers I found was to use `column -t` command. I tried that but I am getting a
`bash: column: command not found`.
Is there another way to align columns... (1 Reply)
Discussion started by: erin00
1 Replies
9. UNIX for Beginners Questions & Answers
I have a csv file as shown below,
xop_thy 80 avr_njk 50 str_nyu 60
avr_irt 70 str_nhj 60 avr_ngt 50
str_tgt 80 xop_nmg 50 xop_nth 40
cyv_gty 40 cop_thl 40 vir_tyk 80
vir_plo 20 vir_thk 40 ijk_yuc 70
cop_thy 70 ijk_yuc 80 irt_hgt 80
I need to align/sort the csv file based... (7 Replies)
Discussion started by: dineshkumarsrk
7 Replies
10. Shell Programming and Scripting
hi all,
trying this using shell/bash with sed/awk/grep
I have two files, one containing one column, the other containing multiple columns (comma delimited).
file1.txt
abc12345
def12345
ghi54321
...
file2.txt
abc1,text1,texta
abc,text2,textb
def123,text3,textc
gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies
LEARN ABOUT PHP
splfileobject.fputcsv
SPLFILEOBJECT.FPUTCSV(3) 1 SPLFILEOBJECT.FPUTCSV(3)
SplFileObject::fputcsv - Write a field array as a CSV line
SYNOPSIS
public int SplFileObject::fputcsv (array $fields, [string $delimiter = ","], [string $enclosure = '"'], [string $escape = "
DESCRIPTION
Writes the $fields array to the file as a CSV line.
PARAMETERS
o $fields
- An array of values.
o $delimiter
- The optional $delimiter parameter sets the field delimiter (one character only).
o $enclosure
- The optional $enclosure parameter sets the field enclosure (one character only).
o $escape
- The optional $escape parameter sets the escape character (one character only).
RETURN VALUES
Returns the length of the written string or FALSE on failure.
Returns FALSE, and does not write the CSV line to the file, if the $delimiter or $enclosure parameter is not a single character.
ERRORS
/EXCEPTIONS
An E_WARNING level error is issued if the $delimiter or $enclosure parameter is not a single character.
CHANGELOG
+--------------+-------------------------------+
| Version | |
| | |
| | Description |
| | |
+--------------+-------------------------------+
|5.5.21, 5.6.5 | |
| | |
| | Added the $escape parameter. |
| | |
+--------------+-------------------------------+
EXAMPLES
Example #1
SplFileObject::fputcsv example
<?php
$list = array (
array('aaa', 'bbb', 'ccc', 'dddd'),
array('123', '456', '789'),
array('"aaa"', '"bbb"')
);
$file = new SplFileObject('file.csv', 'w');
foreach ($list as $fields) {
$file->fputcsv($fields);
}
?>
The above example will write the following to file.csv:
aaa,bbb,ccc,dddd
123,456,789
"""aaa""","""bbb"""
SEE ALSO
fputcsv(3), SplFileObject::fgetcsv.
PHP Documentation Group SPLFILEOBJECT.FPUTCSV(3)