-   Programming (
-   -   String manipulation with a script. (

philipina 03-15-2004 08:39 AM

String manipulation with a script.

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

Steve Stites

crabboy 03-15-2004 12:07 PM

I would probably use an update statement:




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"

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


naflan 03-16-2004 03:42 PM

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


#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");
                replace = argv[2];
                tok = argv[3];
        while (fgets(line,MAXLINE,stdin))
                int i=0;
                char *t;
                t = strtok(line,tok);
                        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.

All times are GMT -5. The time now is 05:02 PM.