How To change data Inside Text File

Question

Post reply

How To change data Inside Text File

Rakesh.Chaudhary

SSC Eights!

Points: 901
More actions
August 3, 2012 at 2:45 am

#264575

HY00980000780000000000000000000000000000000000000000000
GH00001200000000000000000000000000000000000000000000000
GH00001200000000000000000000000000000000000000000000000
GH00001200000000000000000000000000000000000000000000000
GH00001200000000000000000000000000000000000000000000000
GH00001300000000000000000000000000000000000000000000000
GH00001300000000000000000000000000000000000000000000000
GH00001300000000000000000000000000000000000000000000000
GH00001400000000000000000000000000000000000000000000000
GH00001400000000000000000000000000000000000000000000000
GH00001400000000000000000000000000000000000000000000000
HY00990000780000000000000000000000000000000000000000000
*************************************
Changes that needed
HY00980000780000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
GH0XXXXX00000000000000000000000000000000000000000000000
HY00990000780000000000000000000000000000000000000000000
iN THIS BLOCK WHERE i HAVE put xxxxx AT POSITIONS ,i NEED TO
get counting as 00001 in Place oF 00012
00002 in place of 00013
00003 in place of 00014
Hi,
i want to change data inside the block as given above this block is created using a table and BCp comamnd
Now here I want to do changes at
August 3, 2012 at 3:21 am

This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Rakesh.Chaudhary SSC Eights! Points: 901 More actions · Answer 1

Hi I got help from my colleague and we are doing like this as:

Select @trancount= ( cast( substring(Data,charindex('KL0509',Data)+8,7) as int)-1) from DB..ABC_TB

----------------------------------

select Data,

DB..String_FN( (cast( substring(Data,charindex('KL0509',Data)+8,7) as int)-@trancount), 7, 0, 0, 0, '0'),

replace(Data,substring(Data,charindex('KL0509',Data)+8,7), DB..String_FN( (cast( substring(Data,charindex('KL0509',Data)+8,7) as int)-@trancount), 7, 0, 0, 0, '0'))

from DB..ABC_TB

-----------------------------------