Desamudhuru Posted January 10, 2013 Report Posted January 10, 2013 na data ni pushing to flat files. leading 0's kavali. data in DB 039 002 ABC output flat file 39 2 ABC I tried Derived column. RIGHT("000"+(DT_SWTR,3) COLUMNNAME,3) Data conversion task use chesanu... output mataram maradam ledu..... Please
remobabu Posted January 10, 2013 Report Posted January 10, 2013 LTT... rep last day pettukuni inka em chesthunnav vay ..
Ranga_The_Donga Posted January 10, 2013 Report Posted January 10, 2013 right("000"+[columname],3) saripothundhi anukunta.. try cheyyi..
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='remobabu' timestamp='1357844293' post='1303085827'] LTT... rep last day pettukuni inka em chesthunnav vay .. [/quote] eyala udhayanne subhavartha next week last
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='Jeedeelu' timestamp='1357844454' post='1303085853'] right("000"+[columname],3) saripothundhi anukunta.. try cheyyi.. [/quote] isn't it just the same as i posted above. In the derived column.
remobabu Posted January 10, 2013 Report Posted January 10, 2013 [quote name='Desamudhuru' timestamp='1357844607' post='1303085874'] eyala udhayanne subhavartha next week last [/quote]
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='remobabu' timestamp='1357844710' post='1303085888'] [/quote]
Ranga_The_Donga Posted January 10, 2013 Report Posted January 10, 2013 [quote name='Desamudhuru' timestamp='1357844665' post='1303085883'] isn't it just the same as i posted above. In the derived column. [/quote] DT_SWTR ani paina rasavu for conversion I think... basically adhi typo anukunta.. DT_WSTR....shd be.. ah Unicode ga convert cheyakunda dirct ga try cheyyi.. [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]right("000"+[columname],3)[/background][/size][/font][/color]
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='Jeedeelu' timestamp='1357844454' post='1303085853'] right("000"+[columname],3) saripothundhi anukunta.. try cheyyi.. [/quote] try chesa mama still the same.. input 039 ki output 39 vosthondi.
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='Jeedeelu' timestamp='1357844892' post='1303085915'] DT_SWTR ani paina rasavu for conversion I think... basically adhi typo anukunta.. DT_WSTR....shd be.. ah Unicode ga convert cheyakunda dirct ga try cheyyi.. [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]right("000"+[columname],3)[/background][/size][/font][/color] [/quote] chesa mama testing ki only 2000 rows ee rastuna so easy ga reply eva galigina.
loveindia Posted January 10, 2013 Report Posted January 10, 2013 flat file connection properties ki velli, in the advanced tab set it to DT_STR. instead of Derived column. It will do the work I believe. or use this....... REPLICATE("0",3 - LEN([columnname])) + [columnname] Try and tell me..
Desamudhuru Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='loveindia' timestamp='1357849428' post='1303086518'] flat file connection properties ki velli, in the advanced tab set it to DT_STR. instead of Derived column. It will do the work I believe. or use this....... REPLICATE("0",3 - LEN([columnname])) + [columnname] Try and tell me.. [/quote] will try this now working on a different one bhayya. oka 1/2 n hour lo update cgepthanu.
lolliman Posted January 10, 2013 Report Posted January 10, 2013 baa input ni int nundi varchar ki maarchu saripothadi anukuntaaaa
Recommended Posts