replacing '*' with empty string
Posted: Thu Dec 20, 2007 11:31 am
hi
i have a requirement where i am extracting the data from fixedwidth flat file and loading the data to the database after doing some transformations. the file contains some '*' values. so while loading the data to the database i need to make sure that whenever there is * in the text field i need to replace with empty string. Is there any specific function to deal with this. any Help would be really appreciated.
Thanks
i have a requirement where i am extracting the data from fixedwidth flat file and loading the data to the database after doing some transformations. the file contains some '*' values. so while loading the data to the database i need to make sure that whenever there is * in the text field i need to replace with empty string. Is there any specific function to deal with this. any Help would be really appreciated.
Thanks