dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333644485' post='1301602697'] avnu baa ..transformer loo ee funtion use chesi strip cheyaloo adram avvatledu [/quote] field function use cheyyi........ Field(InputColumn,' ', 1) aah space ki mundhu vunnadhi vastadhi...........try chesi chuudu.........emi vachindoo cheppu Link to comment Share on other sites More sharing options...
dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='dalapathi' timestamp='1333644897' post='1301602714'] field function use cheyyi........ Field(InputColumn,' ', 1) aah space ki mundhu vunnadhi vastadhi...........try chesi chuudu.........emi vachindoo cheppu [/quote] tom taruvaata space vundi & vuntey..........ee field function work avvaali.........try chesi result emochindhoo cheppu Link to comment Share on other sites More sharing options...
mettastar Posted April 5, 2012 Report Share Posted April 5, 2012 '&' adi delimiter and field function use chesaka trim chesko just in case emanna spaces vasthayemo Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='dalapathi' timestamp='1333644959' post='1301602721'] tom taruvaata space vundi & vuntey..........ee field function work avvaali.........try chesi result emochindhoo cheppu [/quote] I sould have elaborate my case in the previous reply the input data can be like this TOM NICK & ADAM SAM F RICK & ANDY RAM in the above data my output should be TOM NICK SAM F RICK field function will be gud..if there is only a single word before "&" but ikkada ala ledu baa data Link to comment Share on other sites More sharing options...
mettastar Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333476334' post='1301594111'] nenu ila cheyali ani anukuntunna baa for example 1st input row: column not null kadu..so it has to split into two rows in output ..so I use the loop iteration variable and generate the output as 1 for the first row of output and 2 for the second row of the output. 2nd input row: column null anukoo..then output row should be numbered as 3 3rd input row: column again null anukoo then the output row shoulb be numbered as 4 4th input row: column not null anukoo..then we have two output rows numbered 5 and 6 (logic is same as for 1st input row case) so overall ga enti ante..if input column is not null then it should go through the loop ..if not don't go to the loop condition..but how to keep track of the incrementing number anedhi naa question [/quote] baaa transformer nunchi 3output links theesko and aa moodu funnel chesko oka link emo 'NULLS' ki define chesko, inka rendu 'NOT NULL' ki and sequence number emo Stagevariables lo generate chesko depending on whether the column is null or not null and one more thing neku previous seq number thelvali ante Second Stage Variable First Variable lo call chesthe always previous value of that Second Stage Variable first daniki pass avuthundi Link to comment Share on other sites More sharing options...
mettastar Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333645601' post='1301602751'] I sould have elaborate my case in the previous reply the input data can be like this TOM NICK & ADAM SAM F RICK & ANDY RAM in the above data my output should be TOM NICK SAM F RICK field function will be gud..if there is only a single word before "&" but ikkada ala ledu baa data [/quote] Field Syntax - Field(Column,'Delimiter',Position) In your case below shud work for u Field(InputColumn,'&',1) '&' adi delimiter Link to comment Share on other sites More sharing options...
dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='mettastar' timestamp='1333645778' post='1301602760'] Field Syntax - Field(Column,'Delimiter',Position) In your case below shud work for u Field(InputColumn,'&',1) '&' adi delimiter [/quote] yeah.........idhi try chesi chuudu....... Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='mettastar' timestamp='1333645621' post='1301602752'] baaa transformer nunchi 3output links theesko and aa moodu funnel chesko oka link emo 'NULLS' ki define chesko, inka rendu 'NOT NULL' ki and sequence number emo Stagevariables lo generate chesko depending on whether the column is null or not null and one more thing neku previous seq number thelvali ante Second Stage Variable First Variable lo call chesthe always previous value of that Second Stage Variable first daniki pass avuthundi [/quote] Thanx baa...I implemented in the same way yesterday and got my intended result [quote name='mettastar' timestamp='1333645778' post='1301602760'] Field Syntax - Field(Column,'Delimiter',Position) In your case below shud work for u Field(InputColumn,'&',1) '&' adi delimiter [/quote] nuvvu DS ee na baa Link to comment Share on other sites More sharing options...
dalapathi Posted April 5, 2012 Report Share Posted April 5, 2012 [quote name='arey ooo samba' timestamp='1333646248' post='1301602783'] Thanx baa...I implemented in the same way yesterday and got my intended result nuvvu DS ee na baa [/quote] DS aey....... Link to comment Share on other sites More sharing options...
pandemkodi Posted April 5, 2012 Report Share Posted April 5, 2012 or else you can you this trim(left(column,index(column,'&')-1)) Link to comment Share on other sites More sharing options...
pandemkodi Posted April 5, 2012 Report Share Posted April 5, 2012 oh cinma ipoinda Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='pandemkodi' timestamp='1333646401' post='1301602797'] or else you can you this trim(left(column,index(column,'&')-1)) [/quote] derivation lo error chupisthundi baa... Link to comment Share on other sites More sharing options...
pandemkodi Posted April 5, 2012 Report Share Posted April 5, 2012 i used this one in my job ba its working fine Trim(left(Lnk_Input,index(Lnk_Input, char(9),1))) Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='dalapathi' timestamp='1333646376' post='1301602793'] DS aey....... [/quote] Link to comment Share on other sites More sharing options...
qwerty1204 Posted April 5, 2012 Author Report Share Posted April 5, 2012 [quote name='pandemkodi' timestamp='1333647421' post='1301602860'] i used this one in my job ba its working fine Trim(left(Lnk_Input,index(Lnk_Input,[b] char(9)[/b],1))) [/quote] enti baa adhi..we have to give..substring value aa akkada Link to comment Share on other sites More sharing options...
Recommended Posts