Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: need a text parser
Top Forums Shell Programming and Scripting need a text parser Post 302219448 by sfaizan on Tuesday 29th of July 2008 06:43:43 AM
Old 07-29-2008
Question need a text parser
i need a simple text parser which can parse a data file created by a softwre so that i can export it to my mysqldb,, datafile created as one record per line with different number of fields.
e.g datafile contains following.
a=1, b=3, c=4
a=1, c=55, d=abcd
a=5, b=hello, c=99, d=help

now i want to parse them as
1,3,4
1,55,abcd
5,hello,99,help
i want to remove field name and make data as comma seperated so that i can export them to my db. or anyother way to export these fields to mysql where field names are same as a,b,c,d.
a,b,c and d are fields.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

string parser

I am new to scripting I want to parse a string in a loop eg A:B:C:D E:F:G:H and put them in different variable attr1 = A attr2 = B attr3 = C attr4 = D . . /* do processing with attr1, attr2, attr3 and attr4 */ then go to next line E:F:G:H and again assign... (8 Replies)
Discussion started by: flextronics
8 Replies

2. Shell Programming and Scripting

Text Parser

I am having a text file as follows say server.txt Date Time server ip error code -------------------------------------------------------------------------- 02/21/2008 18:10:14 server1 xxx.xxx.xxx.xxx 6 02/21/2008 08:10:14 server2 ... (8 Replies)
Discussion started by: karthikn7974
8 Replies

3. Shell Programming and Scripting

Help with an (easy) parser

Hello, i'm workig with a file with structural information about biological macromolecules (proteins etc). In a certain file, the info is structured like this @<TRIPOS>MOLECULE blah 1 blah 2 blah 3 @<TRIPOS>MOLECULE foo 1 foo 2 foo 3 @<TRIPOS>MOLECULE mmm 1 mmm 2 mmm 3 I would... (7 Replies)
Discussion started by: aristegui
7 Replies

4. Shell Programming and Scripting

Incremental log parser

I have log file that is incremented every second and is rather big. I need monitor error in this file. I do not want to parse it all every time. I want parse it first time then remember last position (as byte for example) All consequent parsing I want to start from last saved position to the... (3 Replies)
Discussion started by: Narcom
3 Replies

5. Shell Programming and Scripting

Parser with sed

Hi, I have this variable: <a href="http://www.rtve.es/mediateca/videos/20100916/video-calamares-rellenos-salsa-pimientos-garbanzos-16-09-10/878586.shtml">V�deo: Calamares rellenos con salsa de pimientos y ...</a> I would like to have: ... (7 Replies)
Discussion started by: mierdatuti
7 Replies

6. Programming

Parser

Hi Everyone I have an out put of multiple lines which I would like to parse and retrieve certain info from it. The output consists of multiple sections that starts with the line Client: and ends with STL tag: each section separated by an empty line. So basically somehting like Client: ... (10 Replies)
Discussion started by: bombcan1
10 Replies

7. Shell Programming and Scripting

File Parser

Hi need help parsing a file. I have tag fields and values in a file with delimiter |. sample records from the file listed below 8=value|9=value|35=value|49=value|56=value|34=value|50=value|48=value|10=value 8=value|9=value|35=value|49=value|56=value|34=value|51=value|48=value|10=value... (2 Replies)
Discussion started by: subramanian
2 Replies

8. Shell Programming and Scripting

SQL Parser

Hi, I have been assigned a task to migrate few thousands of sql scripts to a different db format. there could be sub queries and complex joins. there would be functions that needs to be replaced from a given list to another values. this should also parse the sub\inline queries. Can you please... (1 Reply)
Discussion started by: hitmansilentass
1 Replies

9. Shell Programming and Scripting

Parser

Hi All, I am trying to create a parser to find out what cobol programs are being called by which JCL's. I need to search recursively until the main cobol program is found being called by a JCL. I tried to create a script but I am not able to generalize it. Can someone please help. ... (1 Reply)
Discussion started by: nua7
1 Replies

10. UNIX for Beginners Questions & Answers

Making a parser

input 1..100km 112..403km 500..623km required output 1..51 112..162 500..550 (i.e 50kms added to the initial distance) (2 Replies)
Discussion started by: ANKIT ROY
2 Replies

LEARN ABOUT X11R4

xmark

Xmark(1)						      General Commands Manual							  Xmark(1)

NAME

       Xmark - summarize x11perf results

SYNTAX

       Xmark datafile

DESCRIPTION

       Xmark  is  a  shell  script that reads the indicated datafile and compiles a benchmark which it writes to standard output.  It writes three
       numbers:

	      A weighted performance number for the x11perf results.

	      A weighted performance number for a standard SparcStation 1, with SunOS 4.1.2, X11R5 Xsun, and a CG3 dumb Color Frame Buffer.

	      The Xmark, which is the ratio of the two numbers above.

       The datafile must be an ordinary file, produced by x11perf in the following way:

       x11perf -display display -v1.3 -rop GXcopy GXxor -all > datafile

       It is possible to run the GXcopy and GXxor tests separately, as long as they are concatenated to the same output file:
       x11perf -display display -v1.3 -rop GXcopy -all > datafile
       x11perf -display display -v1.3 -rop GXxor -all >> datafile
       or
       x11perf -display display -v1.3 -rop GXxor -all > datafile
       x11perf -display display -v1.3 -rop GXcopy -all >> datafile

FILES

       temp.$$
	      Temporary file created in the current directory, deleted after use.

DIAGNOSTICS

       Usage: Xmark datafile
	      Xmark was invoked without arguments or with more than one argument, or with options.  Xmark takes no options.

       Error: data file does not exist or is not ordinary.
	      Xmark cannot find the datafile named on its command line, or the datafile is a special file such as a directory.

       WARNING: datafile contains nnn, not 441 or 447 'trep' results;
	      The file named on the command line does not seem to be a file generated by x11perf in the expected way.

       Diagnostic: ERROR: sum of weights =nnn, not equal to 4566.0;
	      There is an internal error in Xmark.

SEE ALSO

       X(7), x11perf(1), x11perfcomp(1)

X Version 11							    x11perf 1.5 							  Xmark(1)
All times are GMT -4. The time now is 07:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy