I want to exclude (-v) blank records from a file before analysing it.
I know I can use '^]$' for spaces and tabs but how do you look for lines that have nothing (/n or line feed) ? (2 Replies)
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:
... (5 Replies)
Hello,
Is there a direct command to check if the delimiter in your file is a tab or a space? And how can they be converted from one to another.
Thanks,
G (4 Replies)
Hi, I want to read lines from a file, and I'm using two methods
1 use
while read line
do
done<filename
2 use
line=`sed -n '3p' filename`
however, in both of them, I notice that the tab between fields are automatically converted to space
because I want to use awk over the... (10 Replies)
Hi,
I have a space delimited text file but I only want to change the first space to a tab and keep the rest of the spaces intact. How do I go about doing that? Thanks! (3 Replies)
I have a variable sumOfJEOutputFile which is the output file of an SQL command which contains the output of that SQL. The output looks like below:
-----------
58
I am using following code to manipulate the output:
(sed 1,2d $sumOfJEOutputFile > $newTemp1 | sed '$d' $newTemp1)... (4 Replies)
Input file:
xyz,pqrs.lmno,NA,NA,NA,NA,NA,NA,NA
abcd,pqrs.xyz,NA,NA,NA,NA,NA,NA,NA
Expected Output:
xyz pqrs.lmno NA NA NA NA NA NA NA
abcd pqrs.xyz NA NA NA NA NA NA NA
Command Tried so far:
awk -F"," 'BEGIN{OFS=" ";} {print}' $File_Path/File_Name.csv
Issue:... (5 Replies)
My file looks like
3 33 210.01.10.0 2.1 1211 560 26 45 1298 98763451112 15412323499 INPUT OK
3 233 40.01.10.0 2.1 1451 780 54 99 1876 78787878784 15423210199 CANCEL OK
Aim is to replace the spaces in each line by tab
Used: sed -e 's/ */\t/g'
But I get output like this... (3 Replies)
Discussion started by: sa@@
3 Replies
LEARN ABOUT PLAN9
pr
PR(1) General Commands Manual PR(1)NAME
pr - print file
SYNOPSIS
pr [ option ... ] [ file ... ]
DESCRIPTION
Pr produces a printed listing of one or more files on its standard output. The output is separated into pages headed by a date, the name
of the file or a specified header, and the page number. With no file arguments, pr prints its standard input.
Options apply to all following files but may be reset between files:
-n Produce n-column output.
+n Begin printing with page n.
-b Balance columns on last page, in case of multi-column output.
-d Double space.
-en Set the tab stops for input text every n spaces.
-h Take the next argument as a page header (file by default).
-in Replace sequences of blanks in the output by tabs, using tab stops set every n spaces.
-f Use formfeeds to separate pages.
-ln Take the length of the page to be n lines instead of the default 66.
-m Print all files simultaneously, each in one column.
-n Number the lines of each file.
-on Offset the left margin n character positions.
-sc Separate columns by the single character c instead of aligning them with white space. A missing c is taken to be a tab.
-t Do not print the 5-line header or the 5-line trailer normally supplied for each page.
-wn For multi-column output, take the width of the page to be n characters instead of the default 72.
SOURCE
/sys/src/cmd/pr.c
SEE ALSO cat(1), lp(1)PR(1)