12-04-2014
How to read data from tab delimited file after a specific position?
Hi Experts,
I have a tab deliminated file as below
myfile.txt
Local Group Memberships *Administrators *Guests
I need data in below format starting from 4th position.
myfile1.txt
Administrators Guests
the above one is just an example and there could any number of columns only starting 1-3rd position is constant.basically i need all data except starting 3 position.
pls suggest
Thanks,
Litu
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello people,
Can you please tell me how to loop thru the contents of a variable having tab delimited data using for loop in KSH.
For example:
data1 data2 data3 data4
How can I access the above data in a for loop? Please let me know. Thanks.
Regards,
T. (6 Replies)
Discussion started by: tipsy
6 Replies
2. Shell Programming and Scripting
Hi All,
Please help me out with a script which checks whether a given file say abc.txt is in ASCII format and data is tab-delimited. If the condition doesn't satisfy then it should generate error code "100" for file not in ASCII format and "105" if it is not in tab-delimited format.
If the... (9 Replies)
Discussion started by: Mandab
9 Replies
3. Shell Programming and Scripting
Hi I have a spaced filled file having records like below:
What I want is to read line having RT3 at position 17-19 then go to position 2651 check the 18 characters (might be space filled till 18 characters). This position should have a... (6 Replies)
Discussion started by: COD
6 Replies
4. UNIX for Dummies Questions & Answers
OK, let's set this up. I have a tab delimited file from excel. In my UNIX shell I have the following lines
IFS=`printf "\t"`
while read LINE_NO SKIP IGNORE_ERRORS OTHER
do
....
This works fine if there is something in every column like this. NOTE, those are tabs, not spaces. :)
... (2 Replies)
Discussion started by: podzach
2 Replies
5. Shell Programming and Scripting
hi, I want to determine the position of specific values over a cutoff.
So I have a string of values that are mainly negative in number and I want to print the rare few that are positive. Specifically I want to know the position of the value along the string. The position is based from right to... (11 Replies)
Discussion started by: phil_heath
11 Replies
6. Shell Programming and Scripting
Hi All
I wanted to know how to effectively delete some columns in a large tab delimited file.
I have a file that contains 5 columns and almost 100,000 rows
3456 f g t t
3456 g h
456 f h
4567 f g h z
345 f g
567 h j k lThis is a very large data file and tab delimited.
I need... (2 Replies)
Discussion started by: Lucky Ali
2 Replies
7. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
Hello!
I need help with this problem bash shell scripting that basically just reads the data in a tab delimited file and does the following below
1. Read in the data file Survey.txt and assign the column values to variables of... (6 Replies)
Discussion started by: jsmith6932
6 Replies
8. 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
9. 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
10. UNIX for Beginners Questions & Answers
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 DEBIAN
px_put_recordn
PX_PUT_RECORDN(3) Library Functions Manual PX_PUT_RECORDN(3)
NAME
PX_put_recordn -- Stores record in Paradox file at certain position
SYNOPSIS
#include <paradox.h>
int PX_put_recordn(pxdoc_t *pxdoc, char *data, int recpos)
DESCRIPTION
Stores a record in the buffer data into a Paradox file at the given position recpos. The first position has number 0. The function will
determine the data block for this record. If the position is after the last data block, then as many as needed empty data blocks will be
added. If the position is in the middle of a data block and there is no record right before the position, then the position will be recal-
culated to make sure the new record will be stored in the first free slot of the datablock. For example, if a datablock contains H records
and the first call of PX_put_recordn wants to store a record at postion 11, then this will be corrected to position H. PX_put_recordn will
also add an empty data block and store the record as the first record of the second data block. Storing a second record at position 11
again, will be executed without any position change.
data must be constructed with PX_put_data_xxx(3) functions before. It is of the same structure as the record returned by PX_get_record(3)
and PX_get_record2(3).
RETURN VALUE
Returns the record position on success and -1 on failure. The first position has number 0.
SEE ALSO
PX_get_record(3), PX_get_record2(3), PX_put_record(3), PX_put_data_byte(3), PX_put_data_short(3), PX_put_data_long(3), PX_put_data_dou-
ble(3), PX_put_data_alpha(3)
AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx.
PX_PUT_RECORDN(3)