DSXchange

Thanks much BHASDS. I now have the result based on your solution. Really appreciate your time and help.

<>

pandees, i tried that, says invalid format...Invalid Format [%hh%nn%ss%c] used for string_from_time type conversion. James, The requirement is a little different in this case. I am just trying to understand why the conversion would not work for 7 length time field (Ex: 1010103). Thanks for the repli...

Thanks for the quick reply James.
The source column that is sending the time value is a char(7).

Please bear with me on below.
If i understood you correct, are you suggesting that i move this to a char/varchar with a format string.
will this preserve the time format still?

Thanks.

Hi All, I have a time value in format HHMMSSC, HH is hours, MM is minutes, SS is seconds and C is fraction of a second. I need to convert this to a valid time format. If i have 1212124 from the source, the result format should be 12:12:12.4. I tried StringToTime(sourcecol,"%hh%nn%ss"), whi...

Great info there jgreve. Thanks for that and i will try to work a solution using the same. Will let u know soon enough.

Thanks Again.

Thanks Chulett for replying. About the decimal, you are right.
Going to the question, the date range is dynamic. Any number of years/months. could be 2 months or 36 months/ 3 years.

All, I would really appreciate some ideas on the below requirement. *********************************************************** Input is a single record from source, like below, with start year, end year and the total amount spent for those years: Start_Year End_Year Amt ____________________________...

Hi All, I have a requirement to split the incoming data based on a key column data comes in as: Key column column2 column3 column4 A 1 2 3 A 4 5 6 A 19 20 21 B 7 8 9 B 10 11 12 C 13 14 15 C 16 17 18 and so on.................... I need all As,Bs,Cs in separate O/P links. Help appreciated. Thanks in ...

We went with a different alternative, fixed the data before we receive in ETL.

Hi All,

I have a requirement to insert a special character (ex: +) into a description column.

Example:

Source value : "klhsdpjgljhsljkdgljh"

I need to insert a '+' after every 5 characters

the O/P should be "klhsd + pjglj + hsljk + dgljh"

Thanks Guys, I am planning on getting this done thru a SQL by looking up the table. I will updated this thread once the issue is resolved.

This 'month number' reference, where is it stored - in a database table? And the 'create month' is a string field? And are you saying there's more to this than just a lookup, that you have a starting month/number and you need to compute the result somehow? Or just convert '2009/10/05' to 'October-2...

Hi All, I need some help on some Date calculations. My Requirement: I have a month_number assigned to every month starting 'MAY-2009'. Ex: Create_Date, Month_Number May-2009, 150 June-2009, 151 July-2009, 152 ........... as so forth I receive create date from source, which, say is today's date 2009/...

Thanks ArndW, That works!!!