02-23-2007
Thanks both for the speedy replies. It certainly helped me get started!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a comma delimited file that sometimes has addresses details in. The problem is that the address detail can be seen as:
"Sample House, Sample Road". When I run a script specifying the file is comma delimited I would like it to ignore comma's that are in between speech marks.
Is this... (2 Replies)
Discussion started by: dbrundrett
2 Replies
2. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
3. Shell Programming and Scripting
I would like to know code that will delete multiple text from a comma delimited file. For example, how would the comma delimited file below delete the word 'PEST' in Perl language (previously an excel file that was converted to a csv and the last column was PEST):
1, 2,43,34, bosx,PEST
1,... (1 Reply)
Discussion started by: dolo21taf
1 Replies
4. UNIX for Advanced & Expert Users
Hi,
I have two files that I need to match patterns with and the second file has comma delimited rows of data that match but I'm having trouble getting a script to work that gives me the match output to these sets :
file 1:
PADG_05255
PADG_06803
PADG_07148
PADG_02849
PADG_02886... (8 Replies)
Discussion started by: greptastic
8 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have output of sql saved in comma separated file.
Now i need to read line by line this file
and assign word to a unix variable for further processing
Eg:
Test file
world, 1, 3, 4
earth,2,3,4,5
moon,1,2,3,4
Output should be
word1= world
word2=1
echo " first word... (7 Replies)
Discussion started by: gwrm
7 Replies
6. Shell Programming and Scripting
I have a log file that contains several reports with following format.
<Start of delimiter> Report1 header
Report1 header continue
Report1 header continue
Record1 header
Record1 header continue
Record1 header continue
field1 field2 field3 field4
------... (1 Reply)
Discussion started by: yoda9691
1 Replies
7. UNIX for Dummies Questions & Answers
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)
Discussion started by: newbie_01
5 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am not sure if I've posted this question before.
Anyway, I previously asked about converting lines of text into a comma delimited string. Now I am needing to do the other way around ... :( :o
Can anyone advise how is this possible?
Example as below:
Converting records/lines to... (2 Replies)
Discussion started by: newbie_01
2 Replies
9. Shell Programming and Scripting
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)
Discussion started by: newbie_01
2 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Apologies in advance to the moderator if I am posting this the wrong way.
I've searched and found the solution to an old post but as it is a very old post, I don't see an option to update it with additional question.
The question I have is in relation to the following post:
How to... (6 Replies)
Discussion started by: newbie_01
6 Replies
LEARN ABOUT SUSE
arbitron
ARBITRON(8) System Manager's Manual ARBITRON(8)
*
NAME
arbitron - arbitron mailboxes
SYNOPSIS
arbitron [ -C config-file ] [ -o ] [ -u ] [ -l ] [ -p months ]
[ -d days | -D mmddyyyy[:mmddyyyy] ] mailbox...
DESCRIPTION
Arbitron collects and reports readership statistics for mailboxes on the server. It also optionally prunes the mailboxes of Seen state
for dormant users.
Arbitron produces one line of output per mailbox, reporting the mailbox name followed by a space, followed by the number of readers (and if
-u is specified, followed by a colon and a comma-separated list of the readers userids), and if -o is not specified, another space and the
number of subscribers (and if -u is specified, followed by a colon and a comma-separated list of the subscribers userids). IMPORTANT: This
format is subject to change in future versions.
Each "reader" is a distinct authentication identity which has "s" rights to the mailbox and which has SELECTed the mailbox within either
the past days days or the specified date range. Users are not counted as reading their own personal mailboxes. Personal mailboxes are not
reported unless there is at least one reader other than the mailboxes owner.
Arbitron reads its configuration options out of the imapd.conf(5) file unless specified otherwise by -C.
OPTIONS
-C config-file
Read configuration options from config-file.
-o "old way" -- do not report subscribers.
-u Report userids in addition to the count(s).
-l Enable long reporting (comma delimited table consisting of mbox, userid, r/s, start time, end time).
-d days
Count as a reader an authentication identity which has SELECTed the mailbox within days days. Default is 30.
-D mmddyyyy[:mmddyyyy]
Count as a reader an authentication identity which has SELECTed the mailbox within the given date range. The start date and
optional end date are specified as 2-digit month of the year, 2-digit day of the month, and 4-digit year. If the end date is not
specified, then the current system time is used as the end time.
-p months
Prune Seen state for users who have not SELECTed the mailbox within months months. Default is infinity.
FILES
/etc/imapd.conf
CMU
Project Cyrus ARBITRON(8)