I have a problem with a csv file generated on unix by ETL application (informatica) as its dropping leading zeroes.the only problem here is client does not want manual intervention to format the column as text.
I dont know if we can do this through a script .It would be great if we can call this on UNIX side as source is unix and recipeient (client) is on windows.
Any basic script to achieve the same is greatly appreciated..I am also attacing a sample of the csv file.
thanks
Hello
In what field does the missing zeros should be?
TESTING AUTOMATED SWAT DESCRIPTION ,7/25/2014,2061069,1069,19,77,19544,SEEMA JONES,RENAY STRONGE,,2055 HAMILTON DRIVE , ,PLYMOUTH MEETING , PA,19462-0000,US,6493385068,3,19128, ,0,41,21,P2,39.16,425.75,0,B64C8100 ,8/10/2012,2014-07-01-01.03.48.649863
should be what?
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
fourth field in the file.
Come on etldev! help me out a little! how many zeros should there be?
1069 goes to what ?
that was just an example.supposing 1069 had a leading zero we would want to preserve it from dropping.there are some other examples not 1069 in sprsheet
Ok, please give me an example of a record as it is in csv and the same row as should be (including the leading zeros). I intend to automate a process to put back the zeros in the fields that they're missing but i don't know how many and in which fields...
Originally Posted by etldev
ok, lets say we can't preserve it from dropping but we can put them back.. if we know in which field/column and how many zeros (how many characters the number should have including the zeros)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks