Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Normal format and scientific combined data Post 302537833 by drl on Sunday 10th of July 2011 03:40:50 PM
Old 07-10-2011
Hi, forevertl.

I'm with Corona688:
Quote:
I have no idea how you're getting that output data from that input data.
As we have often posted here:
Quote:
To obtain the best answers quickly when you want help in
processing datasets -- extracting, transforming, filtering,
then:

1. Post representative samples of your data (i.e. data that
should "succeed" and data that should "fail")

2. Post what you expect the results to be, instead of trying
only to describe them. Be clear about how the results are to be
obtained, e.g. "add field 2 in file1 to field 3 from file2"

3. Post what you have attempted to do so far.

4. Place the data and expected output within CODE tags, so that
they are more easily readable.

Special cases, exceptions, etc., are very important to include
in the samples.
Best wishes ... cheers, drl
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Convert scientific notation to normal ?

Hell friends, I wrote a script gets the summation of particular column using awk. The awk output is given in scientific notation. How do I convert the scientific notation to normal. My awk syntax : awk '{sum += $2} END { printf sum }' temprep.txt Out put is like 1.5365e+07 I want it as... (2 Replies)
Discussion started by: maheshsri
2 Replies

2. Shell Programming and Scripting

Exracting data from DB using normal login

Hi All, I ve a to extract data from oracle database . I already wrote code for the same ---------------------------------------------------------------------------------------- /u01/oracle/10.2/db_tst/bin/sqlplus -s $LOGIN/$PASS@$DBCONN <<-END > ${DSTDIR}/${FLNAME} set serveroutput on;... (7 Replies)
Discussion started by: malle
7 Replies

3. Shell Programming and Scripting

Convert Epoch time format to normal date time format in the same file

I have a file named "suspected" with series of line like these : {'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''} {'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies

4. Shell Programming and Scripting

mailx requirement - email body header in bold and data content in normal text

Dear all- I have a requirement to send an email via email with body content which looks something below- Email body contents -------------------- RequestType: Update DateAcctOpened: 1/5/2010 Note that header information and data content should be normal text.. Please advice on... (5 Replies)
Discussion started by: sureshg_sampat
5 Replies

5. UNIX for Dummies Questions & Answers

awk for scientific notion and decimal combined data

Dea all, I have a question. I have a column of numbers with scientific notion and decimal combined data. I want to print it only if the number <0.05 using awk. however the very small numbers with scientific notion is not selected. Do any one know how to solve it? Thanks! example as below: ... (4 Replies)
Discussion started by: forevertl
4 Replies

6. Shell Programming and Scripting

IF statement on floating point variable in scientific format

Hi all, I'm struggling :wall: to make a an if statement on two variables in scientific format. e.g. a=1.23e+01 b=3.21e+02 I know that it can be done with bc if the variable are not in scientific format. But what to do in this case??? Thank you, (3 Replies)
Discussion started by: f_o_555
3 Replies

7. Shell Programming and Scripting

EBCDIC Format to Normal String

Hi, I have EBCDIC format file and i wold like to convert normal string(user readable) in unix . The source having the binary IBM file format Sample Source Format: ... (3 Replies)
Discussion started by: koti_rama
3 Replies

8. Shell Programming and Scripting

Normal text to table format

Hi, I am trying to show my list, from a simple list format to a table (row and column formatted table) Currently i have this format in my output (the formart it will always be like this ) >> first 3 lines must be on the same line aligned, and the next 3 shud be on 2nd line....: INT1:... (10 Replies)
Discussion started by: eboye
10 Replies

9. Shell Programming and Scripting

Converting from scientific notation to normal

Hi everyone, I need to convert some numbers that are written in scientific notation to normal notation. Here is a sample line from my data file; "1",1,-1,0,0,502,0,0.00000000000E+00,0.00000000000E+00,0.35591163544E+03,0.35591163548E+03,0.50400001928E-02,0.,-1. first of all, my data file... (4 Replies)
Discussion started by: hayreter
4 Replies

10. UNIX for Dummies Questions & Answers

How to control the decimal points for p-values in scientific format?

Dear all, I have a txt file with only one column which contains p values. My data looks like this: 5.04726976606584e-190 2.94065711152402e-189 2.94065711152402e-189 9.19932135717279e-176 1.09472516659859e-170 1.24974648916809e-170 0.1223974648916 0.9874974648916 ... what I want... (2 Replies)
Discussion started by: forevertl
2 Replies
SPRINTF(3)								 1								SPRINTF(3)

sprintf - Return a formatted string

SYNOPSIS
string sprintf (string $format, [mixed $args], [mixed $...]) DESCRIPTION
Returns a string produced according to the formatting string $format. PARAMETERS
o $format - The format string is composed of zero or more directives: ordinary characters (excluding %) that are copied directly to the result, and conversion specifications, each of which results in fetching its own parameter. This applies to both sprintf(3) and printf(3). Each conversion specification consists of a percent sign ( %), followed by one or more of these elements, in order: o An optional sign specifier that forces a sign (- or +) to be used on a number. By default, only the - sign is used on a number if it's negative. This specifier forces positive numbers to have the + sign attached as well, and was added in PHP 4.3.0. o An optional padding specifier that says what character will be used for padding the results to the right string size. This may be a space character or a 0 (zero character). The default is to pad with spaces. An alternate padding character can be specified by prefixing it with a single quote ( '). See the examples below. o An optional alignment specifier that says if the result should be left-justified or right-justified. The default is right-justified; a - character here will make it left-justified. o An optional number, a width specifier that says how many characters (minimum) this conversion should result in. o An optional precision specifier in the form of a period ( .) followed by an optional decimal digit string that says how many decimal digits should be displayed for floating-point numbers. When using this specifier on a string, it acts as a cutoff point, setting a maximum character limit to the string. Additionally, the character to use when padding a number may optionally be specified between the period and the digit. o A type specifier that says what type the argument data should be treated as. Possible types: o % - a literal percent character. No argument is required. o b - the argument is treated as an integer, and presented as a binary number. o c - the argument is treated as an integer, and presented as the character with that ASCII value. o d - the argument is treated as an integer, and presented as a (signed) decimal number. o e - the argument is treated as scientific notation (e.g. 1.2e+2). The precision specifier stands for the number of digits after the decimal point since PHP 5.2.1. In earlier versions, it was taken as number of significant digits (one less). o E - like %e but uses uppercase letter (e.g. 1.2E+2). o f - the argument is treated as a float, and presented as a floating-point number (locale aware). o F - the argument is treated as a float, and presented as a floating-point number (non-locale aware). Available since PHP 4.3.10 and PHP 5.0.3. o g - shorter of %e and %f. o G - shorter of %E and %f. o o - the argument is treated as an integer, and presented as an octal number. o s - the argument is treated as and presented as a string. o u - the argument is treated as an integer, and presented as an unsigned decimal number. o x - the argument is treated as an integer and presented as a hexadecimal number (with lowercase letters). o X - the argument is treated as an integer and presented as a hexadecimal number (with uppercase letters). Variables will be co-erced to a suitable type for the specifier: Type Handling +--------+---------------------+ | Type | | | | | | | Specifiers | | | | +--------+---------------------+ | | | |string | | | | | | | | | | s | | | | | | | |integer | | | | | | | | | | d, u, c, o, x, X, b | | | | | | | |double | | | | | | | | | | g, G, e, E, f, F | | | | +--------+---------------------+ Warning Attempting to use a combination of the string and width specifiers with character sets that require more than one byte per character may result in unexpected results The format string supports argument numbering/swapping. Here is an example: Example #1 Argument swapping <?php $num = 5; $location = 'tree'; $format = 'There are %d monkeys in the %s'; echo sprintf($format, $num, $location); ?> This will output "There are 5 monkeys in the tree". But imagine we are creating a format string in a separate file, commonly because we would like to internationalize it and we rewrite it as: Example #2 Argument swapping <?php $format = 'The %s contains %d monkeys'; echo sprintf($format, $num, $location); ?> We now have a problem. The order of the placeholders in the format string does not match the order of the arguments in the code. We would like to leave the code as is and simply indicate in the format string which arguments the placeholders refer to. We would write the format string like this instead: Example #3 Argument swapping <?php $format = 'The %2$s contains %1$d monkeys'; echo sprintf($format, $num, $location); ?> An added benefit here is that you can repeat the placeholders without adding more arguments in the code. For example: Example #4 Argument swapping <?php $format = 'The %2$s contains %1$d monkeys. That's a nice %2$s full of %1$d monkeys.'; echo sprintf($format, $num, $location); ?> When using argument swapping, the n$ position specifier must come immediately after the percent sign ( %), before any other speci- fiers, as shown in the example below. Example #5 Specifying padding character <?php echo sprintf("%'.9d ", 123); echo sprintf("%'.09d ", 123); ?> The above example will output: 000000123 Example #6 Position specifier with other specifiers <?php $format = 'The %2$s contains %1$04d monkeys'; echo sprintf($format, $num, $location); ?> The above example will output: The tree contains 0005 monkeys Note Attempting to use a position specifier greater than PHP_INT_MAX will result in sprintf(3) generating warnings. Warning The c type specifier ignores padding and width o $args - o $... - RETURN VALUES
Returns a string produced according to the formatting string $format. EXAMPLES
Example #7 printf(3): various examples <?php $n = 43951789; $u = -43951789; $c = 65; // ASCII 65 is 'A' // notice the double %%, this prints a literal '%' character printf("%%b = '%b' ", $n); // binary representation printf("%%c = '%c' ", $c); // print the ascii character, same as chr() function printf("%%d = '%d' ", $n); // standard integer representation printf("%%e = '%e' ", $n); // scientific notation printf("%%u = '%u' ", $n); // unsigned integer representation of a positive integer printf("%%u = '%u' ", $u); // unsigned integer representation of a negative integer printf("%%f = '%f' ", $n); // floating point representation printf("%%o = '%o' ", $n); // octal representation printf("%%s = '%s' ", $n); // string representation printf("%%x = '%x' ", $n); // hexadecimal representation (lower-case) printf("%%X = '%X' ", $n); // hexadecimal representation (upper-case) printf("%%+d = '%+d' ", $n); // sign specifier on a positive integer printf("%%+d = '%+d' ", $u); // sign specifier on a negative integer ?> The above example will output: %b = '10100111101010011010101101' %c = 'A' %d = '43951789' %e = '4.39518e+7' %u = '43951789' %u = '4251015507' %f = '43951789.000000' %o = '247523255' %s = '43951789' %x = '29ea6ad' %X = '29EA6AD' %+d = '+43951789' %+d = '-43951789' Example #8 printf(3): string specifiers <?php $s = 'monkey'; $t = 'many monkeys'; printf("[%s] ", $s); // standard string output printf("[%10s] ", $s); // right-justification with spaces printf("[%-10s] ", $s); // left-justification with spaces printf("[%010s] ", $s); // zero-padding works on strings too printf("[%'#10s] ", $s); // use the custom padding character '#' printf("[%10.10s] ", $t); // left-justification but with a cutoff of 10 characters ?> The above example will output: [monkey] [ monkey] [monkey ] [0000monkey] [####monkey] [many monke] Example #9 sprintf(3): zero-padded integers <?php $isodate = sprintf("%04d-%02d-%02d", $year, $month, $day); ?> Example #10 sprintf(3): formatting currency <?php $money1 = 68.75; $money2 = 54.35; $money = $money1 + $money2; // echo $money will output "123.1"; $formatted = sprintf("%01.2f", $money); // echo $formatted will output "123.10" ?> Example #11 sprintf(3): scientific notation <?php $number = 362525200; echo sprintf("%.3e", $number); // outputs 3.625e+8 ?> SEE ALSO
printf(3), sscanf(3), fscanf(3), vsprintf(3), number_format(3). PHP Documentation Group SPRINTF(3)
All times are GMT -4. The time now is 07:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy