Sponsored Content
Top Forums Shell Programming and Scripting How to read data from tab delimited file after a specific position? Post 302927600 by Scrutinizer on Thursday 4th of December 2014 06:14:34 AM
Old 12-04-2014
Could you show an actual, representative sample of the file. I doubt it is strictly TAB delimited ("local group memberships" seems like a single field name?)

For a strictly TAB delimited file, you could try this:
Code:
awk '{$1=$2=$3=x; sub(/^\t\t\t/,x)}1' FS='\t\\**' OFS='\t' file


Last edited by Scrutinizer; 12-04-2014 at 07:23 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Looping thru tab delimited data

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

Check whether a given file is in ASCII format and data is tab-delimited

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

read space filled file and replace text at specific position

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

Read a tab delimited

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

Determining position in a tab delimited file

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

Extracting a portion of data from a very large tab delimited text file

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

Shell Script to read a tab delimited file and perform simple tasks

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

How to make tab delimited file to space delimited?

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

Need to convert a pipe delimited text file to tab delimited

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

Replace a column in tab delimited file with column in other tab delimited file,based on match

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
clusters(4)						     Sun Cluster File Formats						       clusters(4)

NAME
clusters - cluster names database SYNOPSIS
/etc/clusters DESCRIPTION
The clusters file contains information regarding the known clusters in the local naming domain. For each cluster a single line should be present with the following information: clustername whitespace-delimited list of hosts Expansion is recursive if a name on the right hand side is tagged with the expansion marker: ``*''. Items are separated by any number of blanks and/or TAB characters. A `#' indicates the beginning of a comment. Characters up to the end of the line are not interpreted by routines which search the file. Cluster names may contain any printable character other than an upper case character, a field delimiter, NEWLINE, or comment character. The maximum length of a cluster name is 32 characters. This information is used by Sun Cluster system administration tools, like cconsole(1M) to specify a group of nodes to administer. The names used in this database must be host names, as used in the hosts database. The database is available from either NIS or NIS+ maps or a local file. Lookup order can be specified in the /etc/nsswitch.conf file. The default order is nis files. EXAMPLES
Example 1 A Sample /etc/clusters File Here is a typical /etc/clusters file: bothclusters *planets *wine planets mercury venus wine zinfandel merlot chardonnay riesling Here is a typical /etc/nsswitch.conf entry: clusters: nis files FILES
/etc/clusters /etc/nsswitch.conf ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWsczu | +-----------------------------+-----------------------------+ |Interface Stability |Uncommitted | +-----------------------------+-----------------------------+ SEE ALSO
cconsole(1M), chosts(1M), serialports(4), nsswitch.conf(4), attributes(5) Sun Cluster 3.2 26 Jun 2006 clusters(4)
All times are GMT -4. The time now is 04:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy