04-15-2014
I'm guessing that the field separator may play a part here. Can you re-display your sample input using <sp> for a space and <tab> for tabs etc. so it's easy to see what we have as input. It might get quite into the geek mode, but we need to know the characters being sent, not what they look like on screen.
Regards,
Robin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a sample file as shown below --
id parent name dba
-----------------------------------... (7 Replies)
Discussion started by: sumirmehta
7 Replies
2. UNIX for Dummies Questions & Answers
Hi, I am trying to sort a file first by the string column, then by the number column.
file:
xyz1 2
xyzX 4
xyz2 1
xyz13 3
xyz11 5
xyz13 10
xyz1 1
xyz10 1
xyz4 2
result should be
xyz1 1
xyz1 2 ... (3 Replies)
Discussion started by: fargo
3 Replies
3. UNIX for Dummies Questions & Answers
Hi Everybody,
I am just new to UNIX as well as to this forum. I have a text file with 10,000 coloumns and each coloumn contains values separated by space. I want to separate them into new coloumns..the file is something like this
as ad af 1 A
as ad af 1 D
...
...
1 and A are in one... (7 Replies)
Discussion started by: Unilearn
7 Replies
4. Shell Programming and Scripting
Hi,
I am very new to Unix script. Suppose i have a file with column header:
NAME1 NAME2 Address Tel
And I always need to make a file with column header:
ID NAME1 NAME2 EMail Address Tel
For the columns that do not exist in the file, I would still like to make a column with blank.
... (11 Replies)
Discussion started by: nightrider
11 Replies
5. UNIX for Dummies Questions & Answers
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies
6. Shell Programming and Scripting
File will have two columns key column and second column which is pipe separated and that need to be sorted.
Below is input file.
1, D|B|A|C
2, C|A|B
3, E|A|F|G|H|D|B|C
4, A|B|D|C|F
Output should be
1, A|B|C|D
2, A|B|C
3, A|B|C|D|E|F|G|H
4, A|B|D|C|F (11 Replies)
Discussion started by: girish119d
11 Replies
7. Shell Programming and Scripting
Hi,
i have a csv file which have headers and values of it like below :
headers --> CI Ref SerialNumber LastScanDate
values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000
i want to have a above csv in below format :
headers --> CI Name CI Description CI Ref... (6 Replies)
Discussion started by: omkar.jadhav
6 Replies
8. Shell Programming and Scripting
Hello,
I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs.
I was thinking of using sed to replace instances of double tab with blank,
sed 's/\t\t//g'
All of the examples... (2 Replies)
Discussion started by: LMHmedchem
2 Replies
9. Shell Programming and Scripting
I have a file with the following format:
X|High|2|GIC|DM||XHM|||6 Months
X|Moderate|2|GIC|DM||XHM|||6 Months
X|High|2|GCM|DM||XSF|||6 Months
X|Med|2|GCM|DM||XSF|||6
Here there are ten columns but I need to print rows having blank records in any of the rows (except for 6th,8th and 9th... (10 Replies)
Discussion started by: chatwithsaurav
10 Replies
10. Shell Programming and Scripting
I've spent the past hour trying different things and googling for this solution and cannot find the answer. Found variations of this, but not this exact thing.
I have the following text, which is the output from our mainframe. Each field is on a separate line, with a blank line between each... (7 Replies)
Discussion started by: lupin..the..3rd
7 Replies
col(1) General Commands Manual col(1)
Name
col - filter reverse line feeds
Syntax
col [-options]
Description
The command reads the standard input and writes the standard output. It performs the line overlays implied by reverse line feeds (ESC-7 in
ASCII) and by forward and reverse half line feeds (ESC-9 and ESC-8, respectively). The command is particularly useful for filtering multi-
column output made with the command of and for filtering output resulting from the preprocessor.
Although accepts half line motions in its input, it does not normally output them. Instead, text that would appear between lines is moved
to the next lower full line boundary.
The control characters SO (ASCII code 017) and SI (ASCII code 016) are assumed to start and end text in an alternate character set. The
character set (primary or alternate) associated with each printing character read is remembered. On output, SO and SI characters are gen-
erated where necessary to maintain the correct treatment of each character.
The command normally converts white space to tabs to shorten printing time. If the -h option is given, this conversion is suppressed.
On input, the only control characters accepted are <space>, <backspace>, <tab>, <return>, <newline>, etc... The VT character is an alter-
nate form of full reverse linefeed, included for compatibility with earlier programs of this type. All other non-printing characters are
ignored.
Options
-b Assumes that the output device does not have backspacing.
-f Suppresses moving half lines to the next full line.
-h Suppresses conversion of white space to tabs.
-p Forces through unchanged any unknown escape sequences that are found in its input. This option should be used with care.
-x Suppresses conversion of white space to tabs (same as -h).
Restrictions
Cannot back up more than 128 lines.
No more than 800 characters, including backspaces, on a line.
See Also
tbl(1), nroff(1)
col(1)