script to sort a string of numerical data in set fields Post: 302397355

Sponsored Content

Top Forums Shell Programming and Scripting script to sort a string of numerical data in set fields Post 302397355 by tlarkin on Monday 22nd of February 2010 01:04:44 AM

02-22-2010

Registered User

script to sort a string of numerical data in set fields

So, I will be working with someone and basically we are trying to build a form that is submitted most likely via the web and the data is just a string of numbers.

like:

19383882872201110929282821818182827349190102837364718191001932873711

Now, each number is part of a numerical value of some data they want. It will always be sent like this in plain text but there is a pattern to it. Like the first 5 digits are data entry A, the next 8 digits are data entry B, the next 3 digits are for C and so forth.

Then I need to output it so it is like this

A = 19383
B = 88287220
C = 111

I don't know all the details but these numbers plug into some system for data analysis and I just need to be able to organize the data for whomever is going to input it. I have no clue if this will be done email or web form. I told them to just send me a plain text file to begin with. I will have to split up each huge string of numbers and assign them to the proper value. I also do not know the patterns yet, but every giant string of numbers will contain the same amount of digits and be in the same pattern.

Now, lets say it is over web, I could have php invoke the shell or run a shell script correct?

Thanks in advance for any insight

-tl

tlarkin

View Public Profile for tlarkin

Find all posts by tlarkin

9 More Discussions You Might Find Interesting

1. Programming

Adding files of numerical data

Hi I was hoping that maybe someone could help me with a small piece of C code. I have a number of files, which are all of similar layout ie. three lines of text and 5-6 columns of numerical data. I need to add each of the elements of the second column in one file to their counterparts in the second...

2. Shell Programming and Scripting

How to strip non numerical data out of file?

Hi, How can I remove all non numerical data from line, so I don't want to delete the line but to have only the numbers. e.g.: ######### 123 aaa124 125bbb 126 127 ######### So I want all the leading and trailing non numerical stuff(letters/white space/tabs anything else except...

3. Shell Programming and Scripting

Script to sort data

Hi All, I have a .csv file with 3 columns called nLats, nLongs, and fRes. in following format : "nLats","nLongs","fRes" 0,0,-1 0,1,-1 0,2,-1 0,3,-1 0,4,-1 ......... ......... 0,143,-1 nLats increments at nLongs=143 1,0, -1 1,1, -1 .......... .......... 1,143,-1...

4. Shell Programming and Scripting

Reading Numerical Binary Data using KSH

Hi, I've searched and couldn't find anyone else with this problem. Is there anyway (preferably using ksh - but other script languages would do) that I can read in binary float data into a text file. The data (arrays from various stages of radar processing) comes in various formats, but mainly...

5. Shell Programming and Scripting

Sort numerically a non numerical

Hello, I have this sample data: 01 * * * * 01 * * * * 01 * * * * 01 * * * * 01 0 * * * 01 0 * * * 01 0 * * * 01 0 * * * 02 * * * 0 02 * * * 0 02 * * * 6 02 * * * 6 02 0 * * 1 02 0 * * 1 02 0 * * 2 02 0 * * 2 02 0 * * 3

6. UNIX for Dummies Questions & Answers

How to sort a column based on numerical ascending order if it includes e-10?

I have a column of numbers in the following format: 1.722e-05 2.018e-05 2.548e-05 2.747e-05 7.897e-05 4.016e-05 4.613e-05 4.613e-05 5.151e-05 5.151e-05 5.151e-05 6.1e-05 6.254e-05 7.04e-05 7.12e-05 7.12e-05

7. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

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...

8. Shell Programming and Scripting

Use sort to sort numerical column

How to sort the following output based on lowest to highest BE? The following sort does not work. $ sort -t. -k1,1n -k2,2n bfd.txt BE31.116 0s 0s DOWN DAMP BE31.116 0s 0s DOWN DAMP BE31.117 0s 0s ...

9. Shell Programming and Scripting

Sort file data according to a custom list of string

I have a string of pre defined ip address list which will always remain constant their order will never change like in below sample: iplist=8.8.5.19,9.7.5.14,12.9.9.23,8.8.8.14,144.1.113 In the above example i m considering only 5 ips but there could be many more. Now i have a file which...

LEARN ABOUT REDHAT

printf

PRINTF(1)								FSF								 PRINTF(1)

NAME

       printf - format and print data

SYNOPSIS

       printf FORMAT [ARGUMENT]...
       printf OPTION

DESCRIPTION

       NOTE:  your shell may have its own version of printf which will supercede the version described here. Please refer to your shell's documen-
       tation for details about the options it supports.

       Print ARGUMENT(s) according to FORMAT.

       --help display this help and exit

       --version
	      output version information and exit

       FORMAT controls the output as in C printf.  Interpreted sequences are:

       "     double quote

       NNN  character with octal value NNN (0 to 3 digits)

       \     backslash

       a     alert (BEL)

            backspace

       c     produce no further output

       f     form feed

       
     new line

       
     carriage return

       	     horizontal tab

       v     vertical tab

       xNNN  byte with hexadecimal value NNN (1 to 3 digits)

       uNNNN character with hexadecimal value NNNN (4 digits)

       UNNNNNNNN
	      character with hexadecimal value NNNNNNNN (8 digits)

       %%     a single %

       %b     ARGUMENT as a string with `' escapes interpreted

       and all C format specifications ending with one of diouxXfeEgGcs, with ARGUMENTs converted to proper type first.  Variable widths are  han-
       dled.

AUTHOR

       Written by David MacKenzie.

REPORTING BUGS

       Report bugs to <bug-coreutils@gnu.org>.

COPYRIGHT

       Copyright (C) 2002 Free Software Foundation, Inc.
       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

SEE ALSO

       The full documentation for printf is maintained as a Texinfo manual.  If the info and printf programs are properly installed at your  site,
       the command

	      info printf

       should give you access to the complete manual.

GNU coreutils 4.5.3						   February 2003							 PRINTF(1)