awk with tab delimeter

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk output seperated by tab

I am just trying to output the below awk separated by tabs. Thank you :). awk (added OFS as an attempt to itroduce tabs) awk '{split($5,a,"-"); OFS='\t' print $1,$2,$3,a}' file.bed > test.bed The awk runs and produces all the data in 1 field instead of 4 fields. current output ...

2. Shell Programming and Scripting

awk substr delimeter

Hi All, I have an awk command that uses the substr function - At the moment I know the length of the values so can use the example below i.e substr(i,0,1) However in future these lengths may change so wondered if you can use a delimiter within a substr? Like in bash you could use cut -d ';',...

3. Shell Programming and Scripting

Replace delimeter between quotes with \| using sed or awk

I've a pipe delimited data in a file of size 3GB. if the text data conatins pipe delimiter that will be enclose with double quotes. I have to replace delimiter which exists between double quotes with #%@#%@#%@ using awk or sed. can some one provide a better and efficient solution to me. The below...

4. Shell Programming and Scripting

Replace space and tab to pipe delimeter

I have file like below abc 12 34 45 code abcdef 451 1 4 code ghtyggg 4 56 3 code I need to change this to abc|12|34|45|code| abcdef|451|1|4|code| ghtyggg|4|56|3|code| I tried replace space with | in sed ... but in the middle some row has...

5. Shell Programming and Scripting

Replacing the delimeter with other delimeter

Hi Friends, I have a file1.txt as below 29123973�2012-0529�35310124�000000000004762�00010�20�390��F 29123974�20120529�35310125�0000000000046770�00010�20�390��F 29123975�20120529�35310126�0000000000046804�00010�20�390��F 29123976�20120529�35310127�0000000000044820�00010�20�390��F i have a file2.txt...

6. Shell Programming and Scripting

awk: string followed by tab comparision

Hi all, Currently i am using if( $0~/ NOT / && $0~/ NULL /) { ................. } to check if the input record contains "NOT" and "NULL". But in some cases "NOT" and "NULL" are preceded and followed by tab. How do i find compare for these fields as well?

7. Shell Programming and Scripting

Count the delimeter from a file and delete the row if delimeter count doesnt match.

I have a file containing about 5 million rows, in the file there are some records which has extra delimiter at random position. (we dont know the positions), now we have to Count the delimeter from each row and if the count of delimeter is not matching then I want to delete those rows from the...

8. Shell Programming and Scripting

Need Awk command to get part of string based on delimeter

HI, Need awk command to get date and time alone from Input : "15:29:15 28.08.2010|SCHEDULE: Started program POSG1" Output expected : "15:29:15 28.08.2010" Please help.

9. Shell Programming and Scripting

output - tab formatted - awk

Dear All, Good Day. I would like to hear your suggestions for the following problem: I have a file with 5 columns with some numbers in 16 lines as shown below. Input file: Col 1 Col 2 Col 3 Col 4 Col 5 12 220 2 121 20 234 30 22 9...

10. Shell Programming and Scripting

Awk to find space and tab.

Wants to print line when there exist leading or trailing space or tab in fields 2,3 and 5 The below code prints all lines in file even if they dont have leading and trailing space or tab. nawk -F"|" '{for(i=1;i<=NF;i++) {if ($i ~ "^*" || $i ~ "*$")}}1' file file Ouput required: ...

LEARN ABOUT HPUX

xmtablistinserttabs

XmTabListInsertTabs(library call)										 XmTabListInsertTabs(library call)

NAME

       XmTabListInsertTabs -- A convenience function that inserts tabs into a tab list

SYNOPSIS

       #include <Xm/Xm.h>
       XmTabList XmTabListInsertTabs(
       XmTabList oldlist,
       XmTab *tabs,
       Cardinal tab_count,
       int position);

DESCRIPTION

       XmTabListInsertTabs  creates  a	new tab list that includes the tabs in oldlist. This function copies specified tabs to the tab list at the
       given position. The first tab_count tabs of the tabs array are added to the tab list. If oldlist is NULL, XmTabListInsertTabs creates a new
       tab list containing only the tabs specified.

       oldlist	 Specifies the tab list to add the tabs to.  The function deallocates oldlist after extracting the required information.

       tabs	 Specifies a pointer to the tabs to be added to the tab list.  It is the caller's responsibility to free the tabs in tabs by using
		 XmTabFree.

       tab_count Specifies the number of tabs in tabs.

       position  Specifies the position of the first new tab in the tab list. A value of 0 (zero) makes the first new tab the first tab in the tab
		 list,	a  value of 1 makes it the second tab, and so on. If position is greater than the number of tabs in oldlist, then the tabs
		 will be inserted at the end. If position is negative, the count will be backwards from the end. A value of -1 makes the first new
		 tab the last tab, and so on.

RETURN

       If  tabs  is  NULL  or  tab_count is 0 (zero), this function returns oldlist. Otherwise, it returns a new tab list.  The function allocates
       space to hold the returned tab list.  The application is responsible for managing the allocated space.  The  application  can  recover  the
       allocated space by calling XmTabListFree.

RELATED

       XmTabList(3) and XmTabListFree(3).

														 XmTabListInsertTabs(library call)

Shell Programming and Scripting