Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format .
The output should be like this 'a','b','c', (4 Replies)
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Hi All,
I get the test result file daily after running the main test script. from the resultfile, need to fetch only server info and status and put them in tabular format in a file and as well in CSV format output file.
I tried using awk command but am not able to put them in tabluar... (6 Replies)
I'm just wondering is there any way to capture the output of a unix command in a csv format.
df -h gives the result of filesystem,free space,Used space, use %,mounted on.
Is there a way to capture the command output and format it as comma sparated or fixed length file. (3 Replies)
Hi, all
I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file.
test.csv
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21
/home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Hi,
I have another problem. I want to sort another csv file by the first field.
result.csv
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw
/home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
My source file looks like this:
Cust-Number = "101"
Cust-Name="Joe"
Cust-Town="London"
Cust-hobby="tennis"
Cust-purchase="200"
Cust-Number = "102"
Cust-Name="Mary"
Cust-Town="Newyork"
Cust-hobby="reading"
Cust-purchase="125"
Now I want to parse this file (leaving out hobby) and... (10 Replies)
Hi,
Can someone please let me know as how I can send the below df -h format of a linux system into a CSV format ?
Resource Size GiB Used GiB Avail GiB Use% Cleanable GiB*
---------------- -------- -------- --------- ---- --------------
/data: pre-comp -... (10 Replies)
Hi Experts,
I am writing a python script to grep string from file and display output in csv file as in attached screenshot
https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view
Input file(result_EPFT_config_device)
Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies
LEARN ABOUT SUSE
radlist
RADLIST(1) Yard Radius Manual RADLIST(1)NAME
radlist - lists current on-line users and per user stats
SYNOPSIS
radlist [ -bhnstx ] [ -D|M|Y ] [ -F format_string ] [ -d day ] [ -m month ] [ -y year ] [ -u user ] [ -y year ]
DESCRIPTION
This program gives detailed statistics for current users on line (which is the default) or any user you like. Its statistics are on a per-
day/month/year base and can be used to produced useful reports. It shows on-line time and traffic, along with numbers of logins and cur-
rent port usage. Its output can be largerly customized as you prefer with a suitable format string. See FORMATS section below.
OPTIONS -b Uses a brief output format.
-t Uses a `traditional' tabular output format.
-n Skips the header when `-t' option is used.
-h Prints out usage of the command.
-F -Hformat_string
Define customized formats for output rows and the header. See FORMATS section below.
-m month
Reports statistics for month month where month is in the range 1-12.
-y year
Reports statistics for year year that is a four digits number.
-x Shows extedend information (port information).
- u user
Gets a single username database entry, i.e. select a specific username to report statistics for that user only.
-M -D -Y
Reports statistics on a dayly/monthly/yearly basis. They should be used along with d,m,y options. If not specified current date and
-M is considered.
FORMATS
radlist does allow the user to have a customized output format with the `-F' command line option (see above). The program accepts and out-
puts any character in a format string and parse it to find some %-prefixed one-letter tokens. Those `a la' printf tokens are substituted
with corresponding entry values. Normal C substitution are performed for \, ,
,
and \%. The list of legal % tokens follows, any oher
combination is parsed and ignored.
Token Value
---------------------------------------------------------
%l Username
%s Number of current sessions
%n Total number of sessions in the period specified
%t Total online time in secs
%T Total online time in HH:MM:SS format
%i Total input traffic in bytes
%I Total input traffic in KBytes
%o Total output traffic in bytes
%O Total output traffic in KBytes
%m Total traffic in bytes
%M Total traffic in KBytes
%k Mean online time per session in secs
%K Mean online time per session in HH:MM:SS format
%g Mean traffic per session in bytes
%G Mean traffic per session in KBytes
%% literal '%'
No alignment decimal values are allowed in this version of format strings.
FILES
/usr/logs/YEAR/user-stats
These are files which constitutes the yearly radlist database. They are in binary GDBM format and collect statistics on a per user
base, day by day.
/usr/logs/NAS/YEAR/detail-XX
These text files stores accounting information for every access server (NAS) listed in the clients file. Each user session is iden-
tified by a unique session-id and these accounting files store start/stop records for every single authenticated session. Informa-
tion stored in those records, but for a group of standard ones, strictly depend on the NAS model and operating system.
BUGS
The -x option apparently is not working.
SEE ALSO radiusd(8), radlast(1)builddbm(8), radtest(1), radwatch(1), radius_attributes(5)AUTHOR
Francesco Paolo Lovergine <francesco@yardradius.org>.
A complete list of contributors is contained in CREDITS file. You should get that file among other ones within your distribution and pos-
sibly installed under /usr/docs directory
COPYRIGHT
Copyright (C) 1997 Cristian Gafton. All rights reserved.
Copyright (C) 1999-2004 Francesco Paolo Lovergine. All rights reserved.
See the LICENSE file enclosed within this software for conditions of use and distribution. This is a pure ISO BSD Open Source License .
1.1 Aug 25, 2004 RADLIST(1)