Search results for query: *

ED, I've tried your methods: replace(Old_INST,","," "), and: replace(Old_INST,char(2),","), and I get Incorrect syntax near the keyword 'replace'. ??

Greg, Running Sybase on UNIX. :-) Thanks, Steve

Hi, I have some SQL that I run to create output to a csv file. This is mailed out to my users and when they open the file it opens in Excel. This is all very good, but two of the columns contain strings that may include commas at any point in the string. This obviously buggers up the output! I...

Hi, I have some SQL that I run to create output to a csv file. This is mailed out to my users and when they open the file it opens in Excel. This is all very good, but two of the columns contain strings that may include commas at any point in the string. This obviously buggers up the output! I...

Simon, Thanks for that - the problem is that I'm trying to open this file at work and don't have access to the installation package. I guess I'll have to see if I can get the file resent in a different format. Thanks anyway. Steve.

Hi guys, I have been sent a .wks file and only have Office - not Works. Is there any way I can open this file in Excel? When I try I get a "file is not in a recognisable format" message. Thanks, :-) Steve.

Thanks for all your help, guys. The VBA code worked in the end.

I've tried that and I get a #NAME? error. Any ideas?

Thanks - I'll try that. :-)

I have a table which has single values ('A', 'B', 'C', etc) in each cell. To summarise each row I have a formula like: =COUNTIF(C7:AF7,"P"). This gives me all the occurrences of P in that row. I have now had to change the table so that it includes more than one value in a cell ('AFH'...

Mike, Thanks for that. Yes the -u does work - syntax, for what I'm doing,being: sort -u inputfile.txt -o outputfile.txt This is a lot simpler. :-)

Apologies - the other duplicates weren't eliminated. Having looked in MAN I have found what I wanted. UNIQ -d displays the duplicated lines, UNIQ -u displays the unduplicated lines - and without a switch UNIQ displays all unduplicated lines plus a singular entry of the duplicated line. Sorry -...

Can anybody help me? I have a large file that I am going to bcp to a database. To ensure that the file loads correctly I need to ensure that each entry is unique. I have run: sort inputfile.txt | uniq but the 1st 2 lines of the file will not become one. Other duplicates have been eliminated. The...