Here my input data is like this coming as string datatype
i need to remove commas in the data and i need out put like
but it is not coming populated in to target which is with '-' negative sign in row data
please any one tell me the correct expression what to write in the expr transfmn
Thanks in Advance
Thanks For your Response
I come to know while running debugger that in source data its taking for the amount which is having with
'-' negative sign into input as (7,737.00) instead of negative its taking inpput like as shown here
any one please suggest me how to achieve this issue
Thanks in Advance
Until now, the +ve values are populated as expected and the -ve values are not loaded right....
Please let us know what output you are getting for the -ve values?
here is the logic to be used:
after col name give comma in single quotes and again give two single quotes without space this means a null is replaced iun place of comma.
Sounds like your source data for this value is formated as number (<value>) rather than -<value>? And the source column is a char/string? But, you want the target to have decimal/number value?
If the source value is string, you could take what srilatha started, just adding in for the ( and ), something like expression
value_v '-'||REPLACESTR(1,<value>, ',' , '(' , ')', ")
If the source value is a number and your not getting the negative value, you could convert to a string maybe in SQL override. Something like this in your override query:
select ...., to_char(value) as value, ... from <table> ...
then use the above REPLACESTR. Try your TO_DECIMAL after that.
Can anyone provide me solution for the above question.
I have my source coming as :
i need target to be :
I have tried with all the above given logic; but no luck. My target datatype is integer.
Thank you !