I seem to be having challenges that are text related..

Thanks a lot it works....

Yes there are both negative and positive values in the monetary column.....

Yes sure you can add columns. Is it for Cleaning the data ?

Actual_Text is currently = '01 759 9991 997 -0.560'

Desired output ...

Couldn't combine your last script with the rest of the script I have so I used the this. How can I combine it Should I decide to use it in...

Sorry about that man. I didn't realise they were no spaces in the data that I sent last night. There spaces and thats why maybe its doesn't strip out all...

Thanks,

I changed it slightly and it now picks up a few more. problem is that

the spaces are not always 3 spaces sometimes its 2 sometimes 3 sometimes 1 space.

I...

SELECT * FROM tbPROCESSED

This is the full picture of what I'm trying to do.The problematic field is called Actual_Text which is the string that requires manipulation.

I'm deriving three fields from...

Tally of Sysobjects

1267

This is what the merged file looks like. That funny character causes errors when you try and re import that file into sql

This works but problem is that it generates a '|'  like character when you merge the two files.How do l get rid of it. The Data file looks fine bu...