Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Hi,
In my file (which is "," delimited and text qualifier is "), I have to extract a particualr field.
file1:
1,"aa,b",4
expected is the 2nd field:
aa,b
I tried the basic cut -d "," -f 2 file 1, this gave me
aa alone instead aa,b.
A small hint ot help on this will be very... (5 Replies)
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
hi,
i have a variable which contains some file names separated by comma. example
FNAME="abc.txt,def.txt,ghi.txt"
i want to extract each filename and store it into an array and also count the number of files in the array.
file=abc.txt
file=def.txt
file=ghi.txt
i thought of using the... (8 Replies)
Hi... I can't find my little red AWK book and it's been a long while since I've awk'd. But I need to take a CSV file and convert the first word of the fifth field to its own field by replacing a space with a comma.
This is for importing a spreadsheet of issues into JIRA...
Example:
a line... (9 Replies)
Hi,
Is there a one-liner that I can use to change a line of text into a comma delimited string?
For example, convert
user1
user2
user3
user4to
user1,user2,user3,user4Currently using while read x, although got the extra comma at the end that I have to remove manually.
Please... (5 Replies)
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below.
Current file (file.csv)
----------------------
empname,date_of_join,dept,date_of_resignation
ram,08/09/2015,sales,21/06/2016
"akash,sahu",08/10/2015,IT,21/07/2016
... (6 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
LEARN ABOUT PHP
pagesizes
PAGESIZES(5) File Formats Manual PAGESIZES(5)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(5)