10-24-2016
Hello cmccabe,
Could you please make sure that your Input_file has delimiter as TAB as example shown by you, doesn't seems to have TABs as delimiter in it, please do confirm on same.
Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have the following data in the format as shown (note: there are more than 1 blank spaces between each field and the spaces are not uniform, meaning there can be one blank space between field1 and field2 and 3 spaces between field3 and field4, in this example, # are the spaces in between... (19 Replies)
Discussion started by: ReV
19 Replies
2. Shell Programming and Scripting
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Discussion started by: axo959
4 Replies
3. Shell Programming and Scripting
Hi Friends,
I have large volume of data file as shown below.
Beganing or end of each filed, there are some blank spaces.
How do I remove those spaces?
AAA AAA1 | BBB BB1 BB2 |CC CCCC
DDDD DD | EEEEEEE EEEEEEEE | FFF FFFFFF FFFF
GG GGGGGG |HH HH ... (3 Replies)
Discussion started by: ppat7046
3 Replies
4. Shell Programming and Scripting
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Discussion started by: 100bees
6 Replies
5. Shell Programming and Scripting
Hello All,
I am trying a one liner for finding the number of null columns in every line of my flat file.
The format of my flat file is like this
a|b|c|d||||e|f|g|
a|b|c|d||||e|f|g|
I want to count the number of fields delimited by "|" which are blank.
In above case the count should be... (6 Replies)
Discussion started by: nnani
6 Replies
6. Shell Programming and Scripting
Sample txt file :
OK00001111112|
OK00003443434|skjdaskldj
OK32812983918|asidisoado
OK00000000001|
ZM02910291029|sldkjaslkjdasldjk
what would be the shell script to figure out the blank space (if any) after the pipe sign? (4 Replies)
Discussion started by: chatwithsaurav
4 Replies
7. Shell Programming and Scripting
I have a tab delimited file with some fields potentially containing no data. In ksh 'read' though treats multiple tabs as a single delimiter. Is there any way to change that behavior so I could have blank data too? I.e. When encountering 2 tabs it would take it as a null field? Or do I have to... (3 Replies)
Discussion started by: benalt
3 Replies
8. Shell Programming and Scripting
Hi
I have a file as below
<field1> <field2> <field3> ... <field_num1> <field_num2>
Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields.
I tried this and it doesn't sort on the difference field .. Appreciate your help.
cat... (9 Replies)
Discussion started by: newstart
9 Replies
9. Shell Programming and Scripting
The below code runs and creates an output file with three sections. The first 2 sections are ok, but the third section doesn't seem to put a . in all the fields that are blank. I don't know if this is what causes the last two fields in the current output to shift to a newline, but I can not seem... (3 Replies)
Discussion started by: cmccabe
3 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account.
$ head -500 x.txt y.txt
==> x.txt <==
TEST01 APP_USER_PROFILE
USER03 APP_USER_PROFILE
TEST02 APP_USER_EXP_PROFILE
TEST04 APP_USER_PROFILE
USER01 ... (3 Replies)
Discussion started by: newbie_01
3 Replies
LEARN ABOUT SUSE
pagesizes
PAGESIZES(5F) PAGESIZES(5F)
NAME
pagesizes - HylaFAX page size definitions
DESCRIPTION
The pagesizes database defines the page dimensions and guaranteed reproducible areas (GRA) for well-known page sizes. The GRA is the por-
tion of the page that is guaranteed to be imaged during facsimile transmission. This region is typically less than the full page dimen-
sions because of paper roller contacts and other mechanical aspects of the printing process in a facsimile machine.
All HylaFAX programs that require page size information read the information from this database using a page size name. Documents should
be prepared such that the full page dimensions are employed with the imaged area contained within the GRA.
The system-wide default page size to use in preparing documents for transmission is given by the ``default'' entry in the database. (NB:
the default entry should be placed last so that inverse matches find the real page size name and not the default entry.)
The page size database is an ASCII file with the following format. Each entry consists of whitespace-separated fields:
name abbrev width height gra-width gra-height top-margin left-margin
Fields have the following interpretation:
name the full name for the page size; e.g. ISO A4;
abbrev an abbreviated version of the full name for use in compact listings such as the receive queue listing printed by faxstat(1);
width the full width of the page;
height the full height of the page;
gra-width the width of the GRA;
gra-height the height of the GRA;
top-margin the margin between the top of the full page and the top of the GRA;
left-margin the margin between the left side of the full page the left side of the GRA.
The first two fields must be separated from the subsequent fields by a tab character (possibly followed by more whitespace); this is done
to easily permit blank characters to be included in names. Otherwise fields can be separated by any amount of any kind of whitespace.
Numbers are all base 10 and in basic measurement units (BMU); defined as 1/1200 x 25.4 millimeters for paper output with a scale factor of
one. All fields must be present on a single line; otherwise the entry is ignored. Comments are introduced by the ``#'' character and con-
tinue to the end the line.
Page size database lookups are either by name or by page dimensions. Lookups by name are done by sequentially scanning the entries in the
database for the first entry that has a matching abbreviation or substring of the page size name field. The string comparisons ignore case
so, for example, ``a4'' would match a full name of ``ISO A4''. Lookups by dimension scan the entire database and return the page with the
closest dimensions using a straightforward distance metric. If the difference in dimensions of the closest match is greater than 1/2 inch
on each side, then no page entry is returned for a lookup by dimension.
SEE ALSO
hylafax-client(1), faxmail(1), faxstat(1), sendfax(1), sgi2fax(1), textfmt(1).
December 5, 1994 PAGESIZES(5F)