hmmm..... this is a bit confusing:
.
I don't see the correlation in your sample files...
I don't follow - can you elaborate?
And maybe provide a desired result based on the samples provided.
Hi all,
I have a file with single white space delimited values, I want to convert them to a tab delimited file.
I tried sed, tr ... but nothing is working.
Thanks,
Rajeevan D (16 Replies)
Hi
I have 100 files each with only one column of 10 numbers that I wish to add to a new file so that I get 100 columns collected in one tab delimited file.
I tried something like:
foreach num (1 2 3)
foreach? gawk -F '\t' '{$num=$1}1' OFS='\t' Eu9_10.2patienter/pospep_10.2patient$num >>... (5 Replies)
Hi Forum
I have a tab delimited file that opens well in Openoffice calc (excel). But when I perform any operation in command line, it reads the file incorrectly. When I 'save As' the same file in office as tab delimited then it works fine.
The file that I think is tab delimited is actually... (8 Replies)
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Hi How to make tab delimited file to space delimited?
in put file:
ABC kgy
jkh ghj
ash kjl
o/p file:
ABC kgy
jkh ghj
ash kjl
Use code tags, thanks. (1 Reply)
Hi,
I need urgent help with a tab delimited file I am working on.
This is the file :
TTTT|YYYYYYY|jargon-journal|MP0000000UID||"j1, j2, j3"
I need th following output:
TTTT|YYYYYYY|jargon-journal|MP0000000UID||ji
TTTT|YYYYYYY|jargon-journal|MP0000000UID||j2... (8 Replies)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
Hi,
I have requirement to create tab delimited file with values coming from variables.
File will contain only two columns separated by tab.
Header will be added once.
Values will be keep adding upon the script run.
If values already exists then values will be replaced.
I have done so... (1 Reply)
Hello Everyone..
I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files
FileP.txt
... (2 Replies)
Discussion started by: YogeshG
2 Replies
LEARN ABOUT SUSE
funcolumnlookup
funcolumnlookup(3) SAORD Documentation funcolumnlookup(3)NAME
FunColumnLookup - lookup a Funtools column
SYNOPSIS
#include <funtools.h>
int FunColumnLookup(Fun fun, char *s, int which,
char **name, int *type, int *mode,
int *offset, int *n, int *width)
DESCRIPTION
The FunColumnLookup() routine returns information about a named (or indexed) column. The first argument is the Fun handle associated with
this set of columns. The second argument is the name of the column to look up. If the name argument is NULL, the argument that follows is
the zero-based index into the column array of the column for which information should be returned. The next argument is a pointer to a
char *, which will contain the name of the column. The arguments that follow are the addresses of int values into which the following
information will be returned:
o type: data type of column:
o A: ASCII characters
o B: unsigned 8-bit char
o I: signed 16-bit int
o U: unsigned 16-bit int (not standard FITS)
o J: signed 32-bit int
o V: unsigned 32-bit int (not standard FITS)
o E: 32-bit float
o D: 64-bit float
o mode: bit flag status of column, including:
o COL_ACTIVE 1 is column activated?
o COL_IBUF 2 is column in the raw input data?
o COL_PTR 4 is column a pointer to an array?
o COL_READ 010 is read mode selected?
o COL_WRITE 020 is write mode selected?
o COL_REPLACEME 040 is this column being replaced by user data?
o offset: byte offset in struct
o n: number of elements (i.e. size of vector) in this column
o width: size in bytes of this column
If the named column exists, the routine returns a positive integer, otherwise zero is returned. (The positive integer is the index+1 into
the column array where this column was located.)
If NULL is passed as the return address of one (or more) of these values, no data is passed back for that information. For example:
if( !FunColumnLookup(fun, "phas", 0, NULL NULL, NULL, NULL, &npha, NULL) )
gerror(stderr, "can't find phas column
");
only returns information about the size of the phas vector.
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funcolumnlookup(3)