04-04-2016
Thanks rdrtx. This Works!
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
2. Shell Programming and Scripting
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)
Discussion started by: nithins007
7 Replies
3. Shell Programming and Scripting
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)
Discussion started by: karumudi7
6 Replies
4. UNIX for Dummies Questions & Answers
Hi, I have a question how to cut the column from non delimited file
This is my file
gene_id ENSG00000223972 transcript_id ENST00000456328 exon_number 1 gene_biotype pseudogene gene_name DDX11L1 transcript_name DDX11L1-002 tss_id TSS26614
gene_id ENSG00000223972 transcript_id ENST00000515242... (1 Reply)
Discussion started by: Wan Fahmi
1 Replies
5. Shell Programming and Scripting
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies
6. Shell Programming and Scripting
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)
Discussion started by: jagdishrout
1 Replies
7. Shell Programming and Scripting
Hello ppl
I have a requirement to split (cut in unix) a file (A.txt) which is a pipe delimited file into A1.txt and A2.txt
Now I have to join (paste in unix) this A2.txt with external file A3.txt to form
output file A4.txt which should be CSV (comma separated file) so that third party can... (25 Replies)
Discussion started by: etldev
25 Replies
8. UNIX for Dummies Questions & Answers
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)
Discussion started by: raja kakitapall
9 Replies
9. Shell Programming and Scripting
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 REDHAT
amstatus
AMSTATUS(8) System Manager's Manual AMSTATUS(8)
NAME
amstatus - display the state of an Amanda run
SYNOPSIS
amstatus [--config] config [--file amdumpfile ] [--summary] [--dumping] [--waitdumping] [--waittaper] [--dumpingtape] [--writingtape]
[--finished] [--failed] [--estimate] [--gestimate] [--stats]
DESCRIPTION
Amstatus gives the current state of the Amanda run specified by the config configuration. It may also be used after a run to summarize the
results.
See the amanda(8) man page for more details about Amanda.
OPTIONS
All options may be abbreviated to the shortest non-ambiguous sub-string. If no options are given, everything is displayed.
[--config] config
Specify the Amanda configuration you want to display the state for.
--file amdumpfile
Specify an alternate file instead of the amdump file.
--summary
Display a summary of the state of the run.
--dumping
Display all partitions that are dumping.
--waitdumping|wdumping
Display all partitions that are waiting to be dumped.
--waittaper|wtaper
Display all partitions dumped that are waiting to be written to tape.
--dumpingtape|dtape
Display all partitions that are dumping directly to tape.
--writingtape|wtape
Display all partitions that are writing to tape.
--finished
Display all partitions that are dumped and written to tape.
--failed|error
Display all partitions that failed.
--estimate
Display all partitions whose estimate is finished. Works only during the estimate phase.
--gestimate|gettingestimate
Display all partitions whose estimate is not finished. Works only during the estimate phase.
--stats|statistics
Display statistics about active-time of taper and dumpers.
SEE ALSO
amanda(8), amcheck(8), amdump(8), amrestore(8), amadmin(8)
AMSTATUS(8)