Re: [U2] Help in removing erroneous character from data file
So your output file is csv, xml, edi, json, txt ?? If xml a good dtd will find problems for you, anything else you will have to write a little program. Should only take a programmer 10 minutes. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ggayathri Sent: 17 September 2010 09:39 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help in removing erroneous character from data file Another application had problem processing the file that it had pulled from my application with the data. In Line Number : 2506 a field(field comes from a UniVerse table) had a value of 11 and the application is looking for time (XX:XX:XX format) After this field all data is incorrect. Also, the line 2506 is unusually long. Gayathru Mecki Foerthmann wrote: > > More information would be helpful. > > On 17/09/2010 06:10, ggayathri wrote: >> I have a data file that is sent from my application(on UniVerse) to an >> interfacing application. >> In the huge amount of data, an erroneous character has been introduced. >> Can someone suggest a way to remove that character? >> May be a routine that would do it? > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-file-tp 29735223p29736257.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file {Unclassified}
I can't help finding a certain delicious irony in seeing a UniVerse support request coming from someone who works for the former owner of the product. Gayathru, I expect that IBM India should still have some internal support people who know about UniVerse, or at least know where they've gone. Do you have a local Value Added Reseller or are you a direct support customer of Rocket Software? From your postings, it appears that you have a potentially badly corrupted file and are a little light on in-depth understanding of the platform. You also need to think about how did the bad data get there? The routine that puts the data into your UniVerse file may need amendment to better control the quality of the incoming data, if that is the seat of the problem. Just 'correcting' the apparently bad data may not solve the problem at all Good luck, I'm afraid you're going to need some Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org On Behalf Of ggayat...@in.ibm.com Sent: Friday, 17 September 2010 8:39 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help in removing erroneous character from data file Another application had problem processing the file that it had pulled from my application with the data. In Line Number : 2506 a field(field comes from a UniVerse table) had a value of 11 and the application is looking for time (XX:XX:XX format) After this field all data is incorrect. Also, the line 2506 is unusually long. Gayathru Mecki Foerthmann wrote: > > More information would be helpful. > > On 17/09/2010 06:10, ggayathri wrote: >> I have a data file that is sent from my application(on UniVerse) to an >> interfacing application. >> In the huge amount of data, an erroneous character has been introduced. >> Can someone suggest a way to remove that character? >> May be a routine that would do it? > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-fil e-tp29735223p29736257.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file
> From: ggayathri > In the huge amount of data, an erroneous character has > been introduced. Can someone suggest a way to remove > that character? May be a routine that would do it? This may not fit your specific scenario. On our freeware page is a utility to "Find Bad Characters". It tells you exactly where funky characters are; it doesn't fix them. no.spam.pleaseNebula-RnD.com/freeware/ Always remove part before Nebula. I believe that was written in response to another public forum thread like this. It's a little verbose and not intended to be fast, but it gets the job done. I haven't run it on UD or UV. I welcome changes for a U2-specific version of that code, or a link to an alternative which I will add to that code. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog (latest blogs on charts/graphs) Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file
Another application had problem processing the file that it had pulled from my application with the data. In Line Number : 2506 a field(field comes from a UniVerse table) had a value of 11 and the application is looking for time (XX:XX:XX format) After this field all data is incorrect. Also, the line 2506 is unusually long. Gayathru Mecki Foerthmann wrote: > > More information would be helpful. > > On 17/09/2010 06:10, ggayathri wrote: >> I have a data file that is sent from my application(on UniVerse) to an >> interfacing application. >> In the huge amount of data, an erroneous character has been introduced. >> Can someone suggest a way to remove that character? >> May be a routine that would do it? > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-file-tp29735223p29736257.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file
More information would be helpful. On 17/09/2010 06:10, ggayathri wrote: > I have a data file that is sent from my application(on UniVerse) to an > interfacing application. > In the huge amount of data, an erroneous character has been introduced. > Can someone suggest a way to remove that character? > May be a routine that would do it? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file
If you are on *nix the tr command will do this very fast. cat filename | tr -d \NNN > outputfile Where NNN is the octal character value -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ggayathri Sent: 17 September 2010 06:10 To: u2-users@listserver.u2ug.org Subject: [U2] Help in removing erroneous character from data file I have a data file that is sent from my application(on UniVerse) to an interfacing application. In the huge amount of data, an erroneous character has been introduced. Can someone suggest a way to remove that character? May be a routine that would do it? -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-file-tp 29735223p29735223.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Help in removing erroneous character from data file
I have a data file that is sent from my application(on UniVerse) to an interfacing application. In the huge amount of data, an erroneous character has been introduced. Can someone suggest a way to remove that character? May be a routine that would do it? -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-file-tp29735223p29735223.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users