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
STRSPN(3) 1 STRSPN(3)
strspn - Finds the length of the initial segment of a string consisting entirely of characters contained within a given mask.
SYNOPSIS
int strspn (string $subject, string $mask, [int $start], [int $length])
DESCRIPTION
Finds the length of the initial segment of $subject that contains only characters from $mask.
If $start and $length are omitted, then all of $subject will be examined. If they are included, then the effect will be the same as call-
ing strspn(substr($subject, $start, $length), $mask) (see "substr" for more information).
The line of code:
<?php
$var = strspn("42 is the answer to the 128th question.", "1234567890");
?>
2 to $var, because the string "42" is the initial segment of $subject that consists only of characters contained within "1234567890".
PARAMETERS
o $subject
- The string to examine.
o $mask
- The list of allowable characters.
o $start
- The position in $subject to start searching. If $start is given and is non-negative, then strspn(3) will begin examining $sub-
ject at the $start'th position. For instance, in the string ' abcdef', the character at position 0 is ' a', the character at posi-
tion 2 is ' c', and so forth. If $start is given and is negative, then strspn(3) will begin examining $subject at the $start'th
position from the end of $subject.
o $length
- The length of the segment from $subject to examine. If $length is given and is non-negative, then $subject will be examined for
$length characters after the starting position. If $length is given and is negative, then $subject will be examined from the
starting position up to $length characters from the end of $subject.
RETURN VALUES
Returns the length of the initial segment of $subject which consists entirely of characters in $mask.
EXAMPLES
Example #1
strspn(3) example
<?php
// subject does not start with any characters from mask
var_dump(strspn("foo", "o"));
// examine two characters from subject starting at offset 1
var_dump(strspn("foo", "o", 1, 2));
// examine one character from subject starting at offset 1
var_dump(strspn("foo", "o", 1, 1));
?>
The above example will output:
int(0)
int(2)
int(1)
NOTES
Note
This function is binary-safe.
SEE ALSO
strcspn(3).
PHP Documentation Group STRSPN(3)