sjgriffiths

Hello I want to sort a file and then uniq it, but ignoring the first field so i have REF | FOR | SUR TLT090991|STEPHEN|GRIFFITHS TLT090992|STEPHEN|GRIFFITHS So i want to uniq but ignore the REF field I had this but it doesnt work cat $FILE | sort -t '|' -k2,3 …

hello I am inserting records into a MYSQL table via a loop Records are being inserted, but every now and then the program bombs out with the below message There is nothing wrong with the query line though (If i restart the job, this record will be inserted without issue) …

Hello I want to update a table with ID from another table, where the companyname field within the tables match as below ABC LIMITED Would Match AST BIRCH CONT LIMITED I basically want to take the 1st letter of each word Can someone help me

Ok, my email has already been setup with postfix. However, we have a new company and they want us to host their emails I know i need to modify the following files /etc/postfix/main.cf /etc/postfix/virtual What do i need to add to these files to be able to host @testemail.com Please …

Hello. I have 2 files which, and i want to supress one file against another. for example. File 1 - suplist.txt hello123 chris635 mike822 I then have another file File2 - checklist.txt stephen929 mike822 hiop191 I can see that mike 822 appears in the suppression list so i do not …

Hello. I have 2 files which, and i want to supress one file against another. for example. File 1 - suplist.txt hello123 chris635 mike822 I then have another file File2 - checklist.txt stephen929 mike822 hiop191 I can see that mike 822 appears in the suppression list so i do not …

Hello I have a list of data, which looks something like below www.clickajob.co.uk%2Fprofiles%2F316%2F6%2F|a/TLT10911641168.google www.ukdata.com%2Fcompany-listings%2FAd-16.html|a/TLT10911767856.google I need to parse this data so i am left with www.clickajob.co.uk|TLT10911641168.google www.ukdata.com|TLT10911767856.google Does anyone know how to help me? I have the following so far [ICODE] if ( fp == NULL ) { printf("Error opening …

Hello Is there a way i can have a MYSQL query to run automatically at a certain time without me running it myself?

Is there any way to check the first $NUM chars of a variable? For example if I have a veriable which contains VAR="LONGMORE LTD" Can i check the first character begins with L?

Hello I have the following in a variable called TEST echo $TEST result : STEPHEN LTD What i want to do is find out whether there are any spaces in my variable name, and if so do the following STEPHEN%42LTD bascially put a %42 where the space is....any ideas?

I have the following file 1928282,Stephen LTD,31280938,L34 3128398,Stephen LTD,84327489,L34 I want to uniq on fields 2 & 4, the fields are comma seperated I cant figure out how to do this....any ideas? im pretty sure uniq does not support this

Hello I was wondering whether someone could help me with the below I have a variable called: char company[50]; I have a string which contains: "STEPHEN JOHNSON LTD" I want to change the LTD to LIMITED How do i do this?

Hello char **pOutData; /* Output results */ char *ptoken I have a pointer which contains the following hdjhasdjkhasd;stephenjohnson;647823463;dhasdjhaj I want to work through and get out just stephenjohnson I have the following so far, which does not work....any help? [code=c] for ( size = 0; size < b2b_data_drill_nNoSelect; size++ ) …

hello I have the following [code=c] while(fgets(b2b_rates_address,1000,in_fp) != NULL ) { strcpy(rates_details[j].ig1, strtok(b2b_rates_address,",")); printf("rates_details[j].ig7 = %s\n",rates_details[j].ig1 ); strcpy(rates_details[j].ig2,strtok(NULL,",")); printf("rates_details[j].ig7 = %s\n",rates_details[j].ig2 ); strcpy(rates_details[j].ig3,strtok(NULL,",")); printf("rates_details[j].ig7 = %s\n",rates_details[j].ig3 ); j++; } [/code] The issue i have is this:- It works fine up to field ig3, this is due to the fact that …

hello i have the following char *b2b_data_Out[1]={"0"}; The number "0" can change. I have a loop which goes round, and i have an integer value which i am going to use to change the above "0" into whatever value i need Question - How do i assign my integer value …

Hello I have the following pointer char **pOutData; This contains an array of strings. How do i printf each element in of pOutData Hope someone can help best regards

hello I am trying to open a file which exists on my local PC using fopen the file is located in c:\B2B Data\files and is called file.txt When i put the above into a variable called filename, i cannot open it ie char filename[27]="c:\B2B Data\files\file.txt"; i then issue an fp …