replacing '*' with empty string

dsdev_123 · Post by **dsdev_123** » 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

ray.wurlod · Post by **ray.wurlod** » Thu Dec 20, 2007 3:12 pm

Code: Select all

Convert("*", "", InLink.TheColumn)

Beware that not all databases (particularly Oracle) like receiving "" and will convert the same to NULL.

dsdev_123 · Post by **dsdev_123** » Thu Dec 20, 2007 6:11 pm

Thanks Ray that solved my problem

ray.wurlod · Post by **ray.wurlod** » Thu Dec 20, 2007 7:47 pm

Perchance you might mark the thread as Resolved, then?