I want to add some prefixed to a list of 10k+ phrases but not sure how to do it. Can I do it in Excel ? I tried to use concatenate function but it don't concatenate two columns. ANy help will be highly appreciated Actually if I can read strings one by one using PHP than I can easily do it. I just need to know how to open file and start reading line by line in PHP. I really have to brush up my shell programming skills
same thing here fopen was the best way to do things, lost my ways, when my laptop crashed (had a script on their I was working on for a year and a half, stopped coding when it crashed) and fread flat file databases were the best experience I ever had with php.
You can do it in excel, it does allow concat, or create a table in mysql, and use PHP to update the table with prefix+result, in fact you can concat with mysql itself, no need for PHP, unless you want the flexiblity to modify it at some stage later on. Cheers GS
hi GS, can u tell me how to do it in excel ? If I can use excel than this will solve all the problem.
Assuming A has your prefix (i hope it is common for all) and B has existing phrases. Now to display it as A+B in excel, all you need to do is type in C =A1&""&B1 and drag it all the way down. C would contain A+B and you can then select C and save value. HTH