REMOVING $ FROM .CSV FILE

[IncredibleVolk]

I USE A DTS PACKAGE TO IMPORT A .CSV FILE INTO A TABLE. ONE OF THE COLUMNS IS AN AMOUNT COLUMN. I WAS WONDERING HOW I CAN REMOVE THE DOLLAR SIGN ($) FROM THAT COLUMN DURING THE IMPORT.

 

[dbomrrsm]

could do an update when the import is finished

UPDATE YOURTABLE
SET YOURFIELD = replace(YOURFIELD,'$','')

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[IncredibleVolk]

That did it. Thanks for your help.

 

[dbomrrsm]

No problem

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]