02-14-2013
Hi Pamu,
Thanks for the suggestion ... as I mentioned I am a complete newbie and dont know how I would write the script at all. Please could you give me a more detailed example that I could test on my data?
Many thanks
10 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 experts,
I need urget help! I have the a text file with this format:
Types of fruits
Name of fruits
1,1
Farm_no,1
apple,1
pineapple,1
grapes,1
orange,1
banana,1
2,2--->this is the record seperator
Farm_no,2
apple,1
pineapple,1
grapes,3
orange,2
banana,1
3,3--->this is the... (1 Reply)
Discussion started by: natalie23
1 Replies
3. UNIX for Advanced & Expert Users
Hi experts,
I need urget help! I have the a text file with this format:
Types of fruits
Name of fruits
1,1
Farm_no,1
apple,1
pineapple,1
grapes,1
orange,1
banana,1
2,2--->this is the record seperator
Farm_no,2
apple,1
pineapple,1
grapes,3
orange,2
banana,1
3,3--->this is the... (2 Replies)
Discussion started by: natalie23
2 Replies
4. 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
5. Shell Programming and Scripting
Hi all,
How can i convert comma delimited .csv file to tab separate using sed command or script.
Thanks,
Krupa (4 Replies)
Discussion started by: krupasindhu18
4 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I am not sure if I've posted this question before.
Anyway, I previously asked about converting lines of text into a comma delimited string. Now I am needing to do the other way around ... :( :o
Can anyone advise how is this possible?
Example as below:
Converting records/lines to... (2 Replies)
Discussion started by: newbie_01
2 Replies
7. 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
8. 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
9. Shell Programming and Scripting
I have file in linux with comma delimited and string fields in double quotations ", I need to convert them to pipe delimiter please share your inputs.
Example:
Input:
"2017-09-30","ACBD,TVF","01234",NULL,18,NULL,"686091802","BANK OF ABCD, LIMITED, THE",790456
Output:
... (4 Replies)
Discussion started by: shieksir
4 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Apologies in advance to the moderator if I am posting this the wrong way.
I've searched and found the solution to an old post but as it is a very old post, I don't see an option to update it with additional question.
The question I have is in relation to the following post:
How to... (6 Replies)
Discussion started by: newbie_01
6 Replies
LEARN ABOUT DEBIAN
ptrepack
PTREPACK(1) General Commands Manual PTREPACK(1)
NAME
ptrepack - Copy any PyTables Leaf, Group or complete subtree into another file.
SYNOPSIS
ptrepack -h -v -o -R start,stop,step --non-recursive --dest-title=title --dont-copyuser-attrs --overwrite-nodes --complevel=(0-9) --com-
plib=lib --shuffle=(0|1) --fletcher32=(0|1) --keep-source-filters --upgrade-flavors --dont-regenerate-old-indexes sourcefile:sourcegroup
destfile:destgroup
DESCRIPTION
Copy any Leaf, Group or complete subtree from a PyTables file into another file.
OPTIONS
A summary of options is included below.
-h Prints a help text.
-v Show more information.
-o Overwite destination file.
-R RANGE
Select a RANGE of rows in the form start,stop,step during the copy of all the leaves.
--non-recursive
Do not do a recursive copy. Default is to do it.
--dest-title=title
Title for the new file (if not specified, the source is copied).
--dont-copy-userattrs
Do not copy the user attrs (default is to do it).
--overwrite-nodes
Overwrite destination nodes if they exist. Default is not to overwrite them.
--complevel=(0-9)
Set a compression level (0 for no compression, which is the default).
--complib=lib
Set the compression library to be used during the copy. lib can be set to "zlib", "lzo", "ucl" or "bzip2". Defaults to "zlib".
--shuffle=(0|1)
Activate or not the shuffling filter (default is active if complevel>0).
--fletcher32=(0|1)
Whether to activate or not the fletcher32 filter (not active by default).
--keep-source-filters
Use the original filters in source files. The default is not doing that if any of --complevel, --complib, --shuffle or --fletcher32
option is specified.
--upgrade-flavors
When repacking PyTables 1.x files, the flavor of leaves will be unset. With this, such a leaves will be serialized as objects with
the internal flavor ("numpy" for 2.x series).
--dont-regenerate-old-indexes
Disable regenerating old indexes. The default is to regenerate old indexes as they are found.
SEE ALSO
ptdump(1).
These utilities are documented fully by PyTables user's manual.
AUTHOR
This manual page was written by Francesc Altet <faltet@carabos.com>.
July 7, 2007 PTREPACK(1)