Recent content by ronaldmacdonald

Hi CluelessChris Not in my Excel you can't (2010). Select multiple columns = Microsoft Excel can convert only one column as a time..." Regardless the manual processing is a bit old school! Ronald

Hi SkipVought, yes a prn file format is ok, however, I cannot (or at least did no see any option) change the column widths. I really wouldn't want to do this manually :-) Ronald

Hello CluelessChris Yes this feature is interesting but very labour intensive. It only lets you modify 1 column at a time and the file remains xls. I wanted to basically produce a file that I would later be able to open in notepad and the fields be the specified column widths. Thanks for the...

Hello I have an excel (xls) spreadsheet with 4 columns: ColA ColB ColC ColD Hello World This Is Is there a way to convert this to a fixed width column file (doesn't need an xls extension), so for instance: ColA (2 chars) ColB (10 chars) ColC (5 chars) ColD (4 chars) He...

Thanks gmmastros - this worked perfectly for my requirement [bigsmile]

Hello I have a table as thus: Col1 Col2 Col3 Col4 Col5 etc 1 Mr JOHN DOE ZZ 2 MR JOHN DOE BB 3 Miss SAM ADAMS CC 4 Mr PAUL SMITH VV I would like to remove column 1 where Col3 and Col4 are the same but Col2 is different case. Is there a simple way to achieve...

Sorted it now by using the query below - which removed the duplicate rows. USE XX GO WITH duplicates AS( SELECT ROW_NUMBER() OVER(PARTITION BY Field1 ORDER BY CLAIMID) AS dups, Field1, Field2, Field3, Field4 FROM Yourtable DELETE duplicates WHERE dups...

Wow tamar - genius. It gives the correct effect but leaves me with duplicate lines (as I have other fields) Field1 Field2 Field3 Field4 Field5 1 JOHN DOE 2 JOHNNY SMITH 3 MR JONES 3 MR JONES MRS JONES 5 MR PATTER 4 MR PATTER MRS PATTER

I have a table with the contents below: Field1 Field2 Field3 1 JOHN DOE 2 JOHNNY SMITH 3 MR JONES 3 MRS JONES 4 MR PATTER 4 MRS PATTER I want to create a table with the contents below from the above: Field1 Field2 Field3 Field4...

Yes that looks likeit would be ok, sadly I am using sed for windows which isn't as forgiving as the sed for unix so I need to tweak that up a bit but thanks.

Hello I am looking for a sed script that can search through a file and replace a string that starts with a certain letter and ends with a fulls stop for a fixed string. For example: Hello world, I am ronaldmacdonald. This is the repalcement string. So in the above I want to replace all...

Hi simian336 - your statement worked perfectly on sql server - thankyou. gmmastros - the field isn't indexed but its always good to consider efficiency!

Yes sorry, I am more use to Oracle but this is for SQL Server 2005.

Hi I am trying to select rows from a table where a date field match the current date. The date is stored in the table as 'yyyy-mm-dd hh:mm:ss' so I am looking for something that would be the equivalent of select * from table where datefield = sysdate

I have a URL running through Apache as follows: http://<server name>/welcome I didn't want to reveal the <server name> in the url so had a DNS entry created called <new server name> that resolved to <server name> Now I can access my URL as http://<new server name> and it takes me to the...