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
Old 02-22-2010
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
 

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... (17 Replies)
Discussion started by: Boucho
17 Replies

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... (10 Replies)
Discussion started by: Juha
10 Replies

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... (1 Reply)
Discussion started by: wizardy_maximus
1 Replies

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... (3 Replies)
Discussion started by: Jonny2Vests
3 Replies

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 (3 Replies)
Discussion started by: gio001
3 Replies

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 (6 Replies)
Discussion started by: evelibertine
6 Replies

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... (9 Replies)
Discussion started by: newstart
9 Replies

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 ... (7 Replies)
Discussion started by: sand1234
7 Replies

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... (15 Replies)
Discussion started by: mohtashims
15 Replies
FNMATCH(3)								 1								FNMATCH(3)

fnmatch - Match filename against a pattern

SYNOPSIS
bool fnmatch (string $pattern, string $string, [int $flags]) DESCRIPTION
fnmatch(3) checks if the passed $string would match the given shell wildcard $pattern. PARAMETERS
o $pattern - The shell wildcard pattern. o $string - The tested string. This function is especially useful for filenames, but may also be used on regular strings. The average user may be used to shell patterns or at least in their simplest form to '?' and '*' wildcards so using fnmatch(3) instead of preg_match(3) for frontend search expression input may be way more convenient for non-programming users. o $flags - The value of $flags can be any combination of the following flags, joined with the binary OR (|) operator. A list of possible flags for fnmatch(3) +-------------+---------------------------------------------------+ | $Flag | | | | | | | Description | | | | +-------------+---------------------------------------------------+ | | | |FNM_NOESCAPE | | | | | | | Disable backslash escaping. | | | | | | | |FNM_PATHNAME | | | | | | | Slash in string only matches slash in the given | | | pattern. | | | | | | | | FNM_PERIOD | | | | | | | Leading period in string must be exactly matched | | | by period in the given pattern. | | | | | | | |FNM_CASEFOLD | | | | | | | Caseless match. Part of the GNU extension. | | | | +-------------+---------------------------------------------------+ RETURN VALUES
Returns TRUE if there is a match, FALSE otherwise. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.3.0 | | | | | | | This function is now available on Windows plat- | | | forms. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 Checking a color name against a shell wildcard pattern <?php if (fnmatch("*gr[ae]y", $color)) { echo "some form of gray ..."; } ?> NOTES
Warning For now, this function is not available on non-POSIX compliant systems except Windows. SEE ALSO
glob(3), preg_match(3), sscanf(3), printf(3), sprintf(3). PHP Documentation Group FNMATCH(3)
All times are GMT -4. The time now is 04:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy