[U2] Help in removing erroneous character from data file

[ggayathri]

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

[U2] File statistics program

[Boydell, Stuart]

Hi
I've tried doing a search on-line but ...did someone once post a program that 
would parse the data in a file and return stats on the attributes used.

I think it summarised: Counts, Attributes used and their types (max/min length; 
int, varchar; sv,mv etc), empty attributes and some other stuff...

I thought I had a copy somewhere. If anyone knows what I'm talking about I'd 
appreciate a copy.

Cheers,
Stuart Boydell



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] Is anyone storing multi-byte names or addresses

[Symeon Breen]

I just use putty, then again our term emulation is just for our dev guys - all 
user interfaces are browser based.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen
Sent: 14 September 2010 20:28
To: U2 Users List
Subject: Re: [U2] [UV] Is anyone storing multi-byte names or addresses

[Ad] For a terminal emulator that can handle UTF-8 data, try Anzio.

On Tue, 14 Sep 2010, Symeon Breen wrote:

> We use utf-8 encoding of Unicode - this is good as it is compact as it 
> only uses 1 2 3 or 4 bytes depending on the character value in the unicode 
> set.
> Also 1-127 is the same as regular ascii. - For us it is only ever 
> single or double bytes, it just stores it in the field, so for 
> instance the character Z is stored as c5 bb.
> 
> I don't think Selects and lists etc would work on such data unless you 
> have nls configured, but we don't do many selects in our systems and 
> certainly not on any fields that would have utf-8 in them.
> 
> For viewing - so long as your emulator is set up for utf-8 it will 
> view the data correctly, if you switch your emulator to an extended 
> acii type character encoding it will give you control characters.
> 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Neil 
> Richards
> Sent: 14 September 2010 17:51
> To: U2 Users List
> Subject: Re: [U2] [UV] Is anyone storing multi-byte names or addresses
> 
> Symeon, How are you storing unicode in your regular files? I thought 
> to go multibyte you need to turn on NLS?
> 
> 
> From: u2-users-boun...@listserver.u2ug.org
> [u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen 
> [syme...@gmail.com]
> Sent: Monday, September 13, 2010 8:50 AM
> To: 'U2 Users List'
> Subject: Re: [U2] [UV] Is anyone storing multi-byte names or addresses
> 
> We do store multi byte stuff, the biggest issues we have are not in 
> the storing but in its identification so that you can then transport 
> and display it correctly, we often get the data in xml files so we 
> need to know that the file has the correct character set definition, 
> similarly the data is displayed in a browser via html so again we need 
> to know that the correct character set is used, and certainly not mix 
> character sets on one output,
> ascii/utf8 combination is fine, but you can get in knots if you start 
> to combine iso8859-1 with utf8 as the characters 127-255 are single 
> byte in
> iso8859-1 but double byte in utf8. In some ways utf8 is better than
> is08859-1 as you don't get the u umlout issue as character 253. You 
> can of course mix character sets in your data, so long as you know what is 
> what.
> 
> 
> 
> -Original Message-
> From:
> u2-users-boun...@listserver.u2ug.org r.u2ug
> .org>
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker 
> Hughes
> Sent: 13 September 2010 16:38
> To: 'U2 Users List'
> Subject: [U2] [UV] Is anyone storing multi-byte names or addresses
> 
> Hey,
> 
> Just wondering how others have approached this - storing multi-byte 
> names and addresses for non-English languages.
> 
> I don't think we're approaching the demarcation line where an NLS 
> implementation would be warranted, with the Administrative overhead 
> that incurs. We are doing a lot more other language business though 
> since we are opening more and more off-shore call centers, and have 
> deployed multiple non English language websites.
> 
> Our immediate need just relates to Name, and ship to / bill to 
> addresses, such words as "Mosiezno-Zelaznych".
> 
> Thanks in advance for the always enlightening insights.
> 
> -Baker
> 
> 
> 
> 
> This communication, its contents and any file attachments transmitted 
> with it are intended solely for the addressee(s) and may contain 
> confidential proprietary information.
> Access by any other party without the express written permission of 
> the sender is STRICTLY PROHIBITED.
> If you have received this communication in error you may not copy, 
> distribute or use the contents, attachments or information in any way.
> Please destroy it and contact the sender.
> ___
> 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-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing li

Re: [U2] [UV] Is anyone storing multi-byte names or addresses

[John Varney]

I hear good things about Anzio

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, September 14, 2010 3:05 PM
To: 'U2 Users List'
Subject: Re: [U2] [UV] Is anyone storing multi-byte names or addresses

We use utf-8 encoding of Unicode - this is good as it is compact as it only
uses 1 2 3 or 4 bytes depending on the character value in the unicode set.
Also 1-127 is the same as regular ascii. - For us it is only ever single or
double bytes, it just stores it in the field, so for instance the character
Ż is stored as c5 bb.

I don't think Selects and lists etc would work on such data unless you have
nls configured, but we don't do many selects in our systems and certainly
not on any fields that would have utf-8 in them.

For viewing - so long as your emulator is set up for utf-8 it will view the
data correctly, if you switch your emulator to an extended acii type
character encoding it will give you control characters.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Neil Richards
Sent: 14 September 2010 17:51
To: U2 Users List
Subject: Re: [U2] [UV] Is anyone storing multi-byte names or addresses

Symeon, How are you storing unicode in your regular files? I thought to go
multibyte you need to turn on NLS?


From: u2-users-boun...@listserver.u2ug.org
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
[syme...@gmail.com]
Sent: Monday, September 13, 2010 8:50 AM
To: 'U2 Users List'
Subject: Re: [U2] [UV] Is anyone storing multi-byte names or addresses

We do store multi byte stuff, the biggest issues we have are not in the
storing but in its identification so that you can then transport and display
it correctly, we often get the data in xml files so we need to know that the
file has the correct character set definition, similarly the data is
displayed in a browser via html so again we need to know that the correct
character set is used, and certainly not mix character sets on one output,
ascii/utf8 combination is fine, but you can get in knots if you start to
combine iso8859-1 with utf8 as the characters 127-255 are single byte in
iso8859-1 but double byte in utf8. In some ways utf8 is better than
is08859-1 as you don't get the u umlout issue as character 253. You can of
course mix character sets in your data, so long as you know what is what.



-Original Message-
From:
u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: 13 September 2010 16:38
To: 'U2 Users List'
Subject: [U2] [UV] Is anyone storing multi-byte names or addresses

Hey,

Just wondering how others have approached this - storing multi-byte names
and addresses for non-English languages.

I don't think we're approaching the demarcation line where an NLS
implementation would be warranted, with the Administrative overhead that
incurs. We are doing a lot more other language business though since we are
opening more and more off-shore call centers, and have deployed multiple non
English language websites.

Our immediate need just relates to Name, and ship to / bill to addresses,
such words as "Mosiężno-Żelaznych".

Thanks in advance for the always enlightening insights.

-Baker




This communication, its contents and any file attachments transmitted with
it are intended solely for the addressee(s) and may contain confidential
proprietary information.
Access by any other party without the express written permission of the
sender is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy,
distribute or use the contents, attachments or information in any way.
Please destroy it and contact the sender.
___
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-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-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users