LinuxQuestions.org - String manipulation with a script.

- Programming (https://www.linuxquestions.org/questions/programming-9/)

- - String manipulation with a script. (https://www.linuxquestions.org/questions/programming-9/string-manipulation-with-a-script-157906/)

philipina

03-15-2004 07:39 AM

String manipulation with a script.

Hello,

I'm a newbie in linux and I have a question about linux script and string manipulation.
In my case I have file with a dump of a mysql database.
ex: INSERT INTO test_table VALUES ('first','1','','','test');
I would like to change this line to add a new parameter.
For example, if I need to add the parameter 'A' in fourth position I will have to count the number of comma (3) and insert the letter 'A'.
My question is. Is it possible to do this with a simple script. If yes, what can I use as command to count a special charater and insert a small string after x special charaters?

Thanks in advance.

jailbait

03-15-2004 10:03 AM

"what can I use as command to count a special charater and insert a small string after x special charaters?"

You can probably do this with the sed command. See:
man sed

___________________________________
Be prepared. Create a LifeBoat CD.
http://users.rcn.com/srstites/LifeBo...home.page.html

Steve Stites

crabboy

03-15-2004 11:07 AM

I would probably use an update statement:

Code:

#!/bin/sh



TABLE_NAME="test_table"



IFS='

'



for i in `cat data.dump | grep $TABLE_NAME | grep INSERT`; do

  KEY=`echo $i | cut -d'(' -f2 | cut -d',' -f1 `

  echo "UPDATE $TABLE_NAME set fourth_col = 'A' where first_col =  $KEY"

done

Otherwise you will have to parse out the data for each column and build you insert statement. Since you don't mess with the existing data with the update script you are less likely to corrupt it.

bigearsbilly

03-16-2004 10:32 AM

What exectly are you trying to do?

change a MySQL dump file?
do you want a general solution or a one off?

if it's a one-off, just use sed.

billy

naflan

03-16-2004 02:42 PM

save the following code as mod_tok.c and compile with make mod_tok.

Code:

#include <stdio.h>

#include <string.h>

#include <stdlib.h>

#define MAXLINE        1000



int main(int argc, char *argv[])

{

        int index;

        char *tok;

        char *replace;

        char line[MAXLINE];

        char new_line[MAXLINE];

        

        if(argc < 4){

                printf("Usage:  mod_tok INDEX, REPLACE, TOKEN\n");

                exit(1);

        }

        else{

                index=atoi(argv[1]);

                replace = argv[2];

                tok = argv[3];

        }

        while (fgets(line,MAXLINE,stdin))

        {

                int i=0;

                char *t;

                strcpy(new_line,line);

                t = strtok(line,tok);

                if(strncmp(line,"INSERT",6)){

                        printf("%s",new_line);

                        continue;

                }

                while(t){

                        if(i) printf("%s",tok);

                        if (index == i++) printf("%s",replace);

                        else printf("%s",t);

                        t = strtok(NULL, tok);

                }

        

        }

}

To run

./mod_tok 3 \\'A\\' , < example.sql > newfile.sql

To change 'first',

./mod_tok 1 second \\' < example.sql > newfile.sql

I'm sure there are sql commands to do what you need as well.
naflan

All times are GMT -5. The time now is 12:17 AM.