Hi,
I have a delimited file generated by a database and i need to convert it to fixed width file using the field length of the database. Can any body suggest me how can i proceed with it?
:confused:
Thanks
Raghavan (2 Replies)
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 came across a very good script to convert a comma seperated to pipe delimited file in this forum. the script serves most of the requirement but looks like it does not handle embedded double quotes and commas i.e if the input is like
1234, "value","first,second", "LDC5"monitor",... (15 Replies)
I have a text file with irregular spacing between values which makes it really difficult to manipulate. Is there an easy way to convert it into a space delimited text file so that all the spaces, double spaces, triple spaces, tabs between numbers are converted into spaces. The file looks like this:... (5 Replies)
Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU2345098809 009697 005374
BB ATIU2345097809 005445 006518
CC ATIU9685098809 003215 003571
DD... (7 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,
I have a space delimited text file but I only want to change the first space to a tab and keep the rest of the spaces intact. How do I go about doing that? Thanks! (3 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 am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies
LEARN ABOUT DEBIAN
fs_listcells
FS_LISTCELLS(1) AFS Command Reference FS_LISTCELLS(1)NAME
fs_listcells - Displays the database server machines known to the Cache Manager
SYNOPSIS
fs listcells [-numeric] [-help]
fs listc [-n] [-h]
DESCRIPTION
The fs listcells command formats and displays the list of the database server machines that the Cache Manager stores in kernel memory for
its home cell and foreign cells.
At each reboot of the client machine, the Cache Manager copies the contents of /etc/openafs/CellServDB into kernel memory. To modify the
list between reboots, use the fs newcell command.
OPTIONS -numeric
Displays each database server machine's IP address rather than hostname.
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The output includes a line for each cell included in the Cache Manager's kernel memory list, in the following format:
Cell <cell> on hosts <database server machines>
The Cache Manager stores IP addresses, but by default has them translated to hostnames before reporting them, by passing them to the cell's
name service (such as the Domain Name Service or a local host table). The name service sometimes returns hostnames in uppercase letters, or
an IP address if it cannot resolve a name.
Using the -numeric flag bypasses the translation to hostnames, which can result in significantly faster production of output. The output
includes IP addresses only.
EXAMPLES
The following example shows output for several cells as illustrations of the different formats for machine names:
% fs listcells
Cell abc.com on hosts fs1.abc.com fs2.abc.com fs3.abc.com
Cell stateu.edu on hosts DB1.FS.STATEU.EDU
DB2.FS.STATEU.EDU DB3.FS.STATEU.EDU
Cell def.gov on hosts 138.255.0.2 sv3.def.gov
PRIVILEGE REQUIRED
None
SEE ALSO CellServDB(5), fs_newcell(1)COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 FS_LISTCELLS(1)