Hi All,
I am Extract Data from .csv file, and loading to Oracle Database.
I am using StringToDecimal Conversion but i am getting 0 instead of actual value in Target Database...
Input is .csv file it's a comma seprated and partially Quoted file...
i used the following methord but i am not getting proper Result:--
1. StringToDecimal(Column_Name)
2. Trim(StringToDecimal(Column_Name))
3. StringToDecimal(Trim(Column_Name))
4. Trim(StringToDecimal(Trim(Column_Name)))
Please suggest me some solution...
Thanks & Regards,
Sandeep
StringToDecimal
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
What datatype and length is your source String column defined as? Option (2) and (4) won't work as your output is a decimal column. Option (3) is my preferred one, although (1) might work.
What is a "partially quoted" file?
Can you write just your original string and Decimal converted columns to a PEEK stage and post the output for one or two rows?
What is a "partially quoted" file?
Can you write just your original string and Decimal converted columns to a PEEK stage and post the output for one or two rows?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 9
- Joined: Fri Jun 01, 2007 12:14 am
nkreddy_3 - are you also working on the same file and problem as the original poster? If not then we should wait for the original poster to reply if his/her file has empty or zero values.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>