DSXchange

I tried convert.
The problem is if I have a decimal value, something like "- 65.70"
Convert(" ", "", InLink.TheNumericString) is giving me "-66" as the output but where as StripWhiteSpaces is giving me "-65.70"

I got the Solution to my problem. I need to do StripWhiteSpace javascript:emoticon(':D')
Very Happy

Thank ...

This partially solves my problem...
Actually the data coming in is "- 65" (there is space in between the negative sign and the number)
I tried Trim() but it doesn't work

Hi all, I have a string "-65". In the transformer I want to do a mathematical operation on this string. So I need to convert this string into number. How do I handle negative sign. Will DS function StringToDecimal work? How do I accomplish this ?javascript:emoticon(':roll:') Rolling Eyes T...

Ya I did extract the string I get and its as expected. i.e "700.123,2007,1"
but when I do Field (Input.str,',',1) i get only 700 as output

Its a float coloumn in the database.

i used to_number(string)

I am taking it into a string and then doing a to_number in the insert query.

Hi all, I have a input to the transformer something like this "700.123, 2007,06" its a comma separated value. I want it to be mapped to 3 different column by doing a substring on it. I used Field function Field(Input.string,',',1) but the output is 700 and not 700.123 Can anyone help me. I...

Ok..

Can I call sub-routine from the job properties. So that it calls a sql file to delete the tables. I have a series of insertions. So I want to truncate the tables before my jobs runs in a sequencer.

Ok..

Can I call sub-routine from the job properties. So that it calls a sql file to delete the tables. I have a series of insertions. So I want to truncate the tables before my jobs runs in a sequencer.

Ok..

Can I call sub-routine from the job properties. So that it calls a sql file to delete the tables. I have a series of insertions. So I want to truncate the tables before my jobs runs in a sequencer.

Ok..

Can I call sub-routine from the job properties. So that it calls a sql file to delete the tables. I have a series of insertions. So I want to truncate the tables before my jobs runs in a sequencer.

Thank you...

I am new to data stage so was wondering if what I am doing is right or wrong...

Hi, I have mutiple comma seperated files. They vary in thier structure. I have to read them all and place them into the necessary tables. My problem is I have ended up writing 10 server job for the 10 input files I have. I have connected all these 10 jobs using job sequence. But I guess this a wrong...

Got ur point...
I am going with truncate and insert option..
Thank u