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
replacing '*' with empty string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Convert("*", "", InLink.TheColumn)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: