Shell Programming and Scripting

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

Try

Code:

sed -r 's#\*##g;s#^([^ ]* ){3}##' file

it results as below
Local Group MembershipsAdministrators Guests

I need
Administrators Guests

Hello Litu,

If your requirement is to get results except first 3 columns then following may help you in same.

Code:

awk '{$1=$2=$3=""} 1'  Input_file

Thanks,
R. Singh

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

thanks R Singh

it results as below
*Administrators *Guests

with a tab character at the beginning.

pls find attached

mytxt.txt- actual file
mytxt1.txt- expected file(even comma separated format would be fine as output file)

Thanks