Re: [U2] Special Character Handling
Depends on which special charactersIf you mean accented letters, I use a subroutine that converts the accented high ASCII code to it's non-accented letter. (EX. e' to e). Basically, it's just a bunch of converts. But it's good for converting data that was entered via a website text entry where foreign letters can be entered. The hard part is collecting all the possible accented letters. George George Gallen Senior Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings [ron_hutchi...@hotmail.com] Sent: Tuesday, January 11, 2011 6:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Special Character Handling Is there a tool to remove special characters from a text file? Other than a roll your own with convert or replace in a program? ___ 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] Special Character Handling
I know I'm not answering the original question Is there a tool , but if the validation is on-line, it would be best to manage a list of valid characters, rather than do converts of specific characters. Bearing in mind that users can copy-paste into your input field, or type Alt+nnn you can easily get trash in your database, that later comes back to haunt you when you export to excel, try to put together an SQL query, etc. If it's a web-based app, there are security issues and you definitely should have a set of valid characters. Regards, Marc On Wed, 12 Jan 2011 04:10:52 -0600, George Gallen ggal...@wyanokegroup.com wrote: Depends on which special charactersIf you mean accented letters, I use a subroutine that converts the accented high ASCII code to it's non-accented letter. (EX. e' to e). Basically, it's just a bunch of converts. But it's good for converting data that was entered via a website text entry where foreign letters can be entered. The hard part is collecting all the possible accented letters. George George Gallen Senior Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings [ron_hutchi...@hotmail.com] Sent: Tuesday, January 11, 2011 6:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Special Character Handling Is there a tool to remove special characters from a text file? Other than a roll your own with convert or replace in a program? ___ 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
Re: [U2] Special Character Handling
I've used the OCONV to remove non-printable (control) characters; actually it doesn't remove them just replaces with a period . ITEM=OCONV(ITEM,MCP) Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings Sent: Tuesday, January 11, 2011 4:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] Special Character Handling Is there a tool to remove special characters from a text file? Other than a roll your own with convert or replace in a program? ___ 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] Special Character Handling
Something we used on our old ERP system was to define all valid characters, and use this against a copy of the input string to remove all valid characters, then use the remaining string (if anything remains...it's not valid) against the original input string. HTH Drew -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mhilb...@ppcsoftware.com Sent: Wednesday, January 12, 2011 7:31 PM To: U2 Users List Subject: Re: [U2] Special Character Handling I know I'm not answering the original question Is there a tool , but if the validation is on-line, it would be best to manage a list of valid characters, rather than do converts of specific characters. Bearing in mind that users can copy-paste into your input field, or type Alt+nnn you can easily get trash in your database, that later comes back to haunt you when you export to excel, try to put together an SQL query, etc. If it's a web-based app, there are security issues and you definitely should have a set of valid characters. Regards, Marc On Wed, 12 Jan 2011 04:10:52 -0600, George Gallen ggal...@wyanokegroup.com wrote: Depends on which special charactersIf you mean accented letters, I use a subroutine that converts the accented high ASCII code to it's non-accented letter. (EX. e' to e). Basically, it's just a bunch of converts. But it's good for converting data that was entered via a website text entry where foreign letters can be entered. The hard part is collecting all the possible accented letters. George George Gallen Senior Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings [ron_hutchi...@hotmail.com] Sent: Tuesday, January 11, 2011 6:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Special Character Handling Is there a tool to remove special characters from a text file? Other than a roll your own with convert or replace in a program? ___ 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
Re: [U2] Special Character Handling
I think I have seen where user submitted csv files have been good until one of our team opened it for further processing in Excel, and autocorrect took over and turned cafe and other words into alternate spellings. If you have a similar workflow, make sure the team members doing this preprocessing turn off autocorrect for those. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Special Character Handling
I think that's clippy's revenge! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, January 12, 2011 9:06 AM To: U2 Users List Subject: Re: [U2] Special Character Handling I think I have seen where user submitted csv files have been good until one of our team opened it for further processing in Excel, and autocorrect took over and turned cafe and other words into alternate spellings. If you have a similar workflow, make sure the team members doing this preprocessing turn off autocorrect for those. ___ 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] Special Character Handling
I don't know of an existing tool, probably because it depends on what you consider a 'special' character. Are line feeds and carriage returns OK? How about tab? If you only want 'printable' characters then loop through each character in the file: IF SEQ(CHARACTER) 31 AND SEQ(CHARACTER) 127 THEN... Ron Hutchings wrote: Is there a tool to remove special characters from a text file? Other than a roll your own with convert or replace in a program? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Special Character Handling
Heres a couple of subs i use to uri encode - but you can easily change them to do whatever you want with certain characters 001:SUBROUTINE URIENCODE(url) 002: * Sub to uri encode a url 003: 004:max=LEN(url) 005:newurl='' 006: 007:FOR i = 1 TO max 008: thischar = url[i,1] 009: IF SEQ(thischar)126 THEN 010: thischar=%:DTX(SEQ(thischar)) 011: END 012: newurl := thischar 013:NEXT i 014: 015:url=newurl 016: 017:RETURN 001:SUBROUTINE FULL.URIENCODE(url) 002: * Sub to fully uri encode all characters in a url except 0-9 and a-z 003: 004:max=LEN(url) 005:newurl='' 006: 007:FOR i = 1 TO max 008: thischar = url[i,1] 009: thischar.seq=SEQ(thischar) 010: IF NOT((thischar.seq47 AND thischar.seq58) OR (thischar.seq64 AND thischar.seq91) OR (thischar.seq96 AND thischar.seq123)) THEN 011: thischar=%:DTX(SEQ(thischar)) 012: END 013: newurl := thischar 014:NEXT i 015: 016:url=newurl 017: 018:RETURN From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: 12 January 2011 14:58 To: U2 Users List Subject: Re: [U2] Special Character Handling I don't know of an existing tool, probably because it depends on what you consider a 'special' character. Are line feeds and carriage returns OK? How about tab? If you only want 'printable' characters then loop through each character in the file: IF SEQ(CHARACTER) 31 AND SEQ(CHARACTER) 127 THEN... Ron Hutchings wrote: Is there a tool to remove special characters from a text file? Other than a roll your own with convert or replace in a program? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3374 - Release Date: 01/11/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV 11.1 and HP Itanium
Richard, We have a customer reporting the error below running UV 11.1 on Itanium 11.31. So far it has been an isolated incident ( 2 times) . This error on Unidata typically Indicates you need to increase SHM_GPAGESZ. However in this case it occurred when a user was simply trying to Login to UV. It has not recurred following a reboot. Are you experiencing SHM errors? If so what kind of errors are you seeing? Error when attaching shm (25985033, 0, 0), errno=22 addr of shm seg being attached may be too high, retry... Regards, Terry _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, January 11, 2011 6:05 PM To: U2 Users List Subject: Re: [U2] UV 11.1 and HP Itanium And what version of UV are you running? Richard On Tue, Jan 11, 2011 at 4:49 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: We are running HP-Ux 11i v2 Itanium. We have not had any memory issues at all. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, January 11, 2011 6:10 PM To: U2 Users List Subject: [U2] UV 11.1 and HP Itanium Our sysadmin would like me to ask: How many out there are running UV 11.1 on Itanium? Have any of you on UV 11.1 on Itanium had any issues with shared memory? Thanks! Richard Lewis IBM Certified Solutions Expert ___ 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 _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3372 - Release Date: 01/10/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Special Character Handling
I would suggest this IF String # Oconv(String,MCP) then End This will quite quickly tell you *whether* any given string has a non-printable char in it. It is the fastest known method to give you this Boolean result. Then use the INDEX function to return the absolute location of any . (period) in the string. If there was not a period at that same location in the original string, then that char is invalid. W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Special Character Handling
Which characters does it consider invalid? Just 32 and 128?
I use the following: (It's missing a few accents, I need to update it when I
find some time)
I think I'll add Will's piece to the end to see if I missed any however.
SUBROUTINE REMOVE.IIT.ACCENT(INDATA,OUTDATA)
*
UAE=CHAR(140):CHAR(198)
LAE=CHAR(156):CHAR(230)
DEGREE=CHAR(176)
*
NULL1=CHAR(128):CHAR(129):CHAR(130):CHAR(131):CHAR(132):CHAR(133):CHAR(134):CHAR(135):CHAR(136):CHAR(137)
NULL2=CHAR(139):CHAR(141):CHAR(143):CHAR(144):CHAR(145):CHAR(146):CHAR(147):CHAR(148):CHAR(149):CHAR(150)
NULL3=CHAR(151):CHAR(152):CHAR(153):CHAR(155):CHAR(157):CHAR(160):CHAR(161):CHAR(162):CHAR(163):CHAR(164)
NULL4=CHAR(165):CHAR(166):CHAR(167):CHAR(168):CHAR(169):CHAR(171):CHAR(172):CHAR(173):CHAR(174):CHAR(175)
NULL5=CHAR(177):CHAR(178):CHAR(179):CHAR(180):CHAR(181):CHAR(182):CHAR(183):CHAR(184):CHAR(185):CHAR(187)
NULL6=CHAR(188):CHAR(189):CHAR(190):CHAR(191)
NULLX=CHAR(186):CHAR(216):CHAR(222):CHAR(240):CHAR(247):CHAR(248)
*
UPA=CHAR(192):CHAR(193):CHAR(194):CHAR(195):CHAR(196):CHAR(197)
LWA=CHAR(224):CHAR(225):CHAR(226):CHAR(227):CHAR(228):CHAR(229)
RUA=STR('A',LEN(UPA))
RLA=STR('a',LEN(LWA))
UPE=CHAR(200):CHAR(201):CHAR(202):CHAR(203)
LWE=CHAR(232):CHAR(233):CHAR(234):CHAR(235)
RUE=STR('E',LEN(UPE))
RLE=STR('e',LEN(LWE))
UPI=CHAR(204):CHAR(205):CHAR(206):CHAR(207)
LWI=CHAR(236):CHAR(237):CHAR(238):CHAR(239)
RUI=STR('I',LEN(UPI))
RLI=STR('i',LEN(LWI))
UPO=CHAR(210):CHAR(211):CHAR(212):CHAR(213):CHAR(214)
LWO=CHAR(242):CHAR(243):CHAR(244):CHAR(245):CHAR(246)
RUO=STR('O',LEN(UPO))
RLO=STR('o',LEN(LWO))
UPU=CHAR(217):CHAR(218):CHAR(219):CHAR(220)
LWU=CHAR(249):CHAR(250):CHAR(251):CHAR(252)
RUU=STR('U',LEN(UPU))
RLU=STR('u',LEN(LWU))
SS1=CHAR(138):CHAR(142):CHAR(154):CHAR(158):CHAR(159):CHAR(199):CHAR(208):CHAR(209):CHAR(221):CHAR(223):CHAR(231)
SR1=SZszYCDNYBc
SS2=CHAR(241):CHAR(253):CHAR(170):CHAR(215)
SR2=nyax
*
EXPR1=UPA:LWA:UPE:LWE:UPI:LWI:UPO:LWO:UPU:LWU:SS1:SS2
EXPR2=RUA:RLA:RUE:RLE:RUI:RLI:RUO:RLO:RUU:RLU:SR1:SR2
NULCHARS=NULL1:NULL2:NULL3:NULL4:NULL5:NULL6:NULLX:DEGREE
*
LIN=INDATA
*
CONVERT EXPR1 TO EXPR2 IN LIN
CONVERT NULCHARS TO IN LIN
LIN=CHANGE(LIN,UAE,AE)
LIN=CHANGE(LIN,LAE,ae)
*
OUTDATA=LIN
RETURN
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com
Sent: Wednesday, January 12, 2011 12:28 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Special Character Handling
I would suggest this
IF String # Oconv(String,MCP) then
End
This will quite quickly tell you *whether* any given string has a
non-printable char in it.
It is the fastest known method to give you this Boolean result.
Then use the INDEX function to return the absolute location of any .
(period) in the string. If there was not a period at that same
location in the
original string, then that char is invalid.
W
___
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] UV User Logout
When one user here logs out via Dynamic Connect on HP-Ux 11i v2 running UV 10.3.6, she gets the following screenful... mkpath: SAVEDLISTS/S.maryann.13 is not a directory mkpath: SAVEDLISTS/S.maryann.13 is not a directory . . mkpath: SAVEDLISTS/S.maryann.13 is not a directory MaryAnn is setup like most everybody else. Clarification on the significance of this message would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV User Logout
Bill, It looks like it's trying to write out maryann's command stack. SAVEDLISTS is apparently setup as a Type 1 file, and since maryann's stack key is longer, it's trying to create a sub-directory and write into it. It looks like maryann doesn't have appropriate prviileges to create the sub-directory in the SAVEDLISTS directory. You could resize the SAVEDLISTS file as a Type 19, or fix the owner /or group of SAVEDLISTS, or just turn STACK.WRITE off. Without looking, that's what I would guess. Best Regards, Richard Lewis On Wed, Jan 12, 2011 at 2:15 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: When one user here logs out via Dynamic Connect on HP-Ux 11i v2 running UV 10.3.6, she gets the following screenful... mkpath: SAVEDLISTS/S.maryann.13 is not a directory mkpath: SAVEDLISTS/S.maryann.13 is not a directory . . mkpath: SAVEDLISTS/S.maryann.13 is not a directory MaryAnn is setup like most everybody else. Clarification on the significance of this message would be appreciated. --Bill ___ 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] UV User Logout
RL: Thanks for writing. ed VOC STACKWRITE 0001: X 0002: ON S.maryann.13 was found to be a file. I just renamed it to .13.BAK. Now MaryAnn's logout is clean. I want to keep the STACKWRITE setting intact since I use it and my boss uses it. Let's call this a victory. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Wednesday, January 12, 2011 5:01 PM To: U2 Users List Subject: Re: [U2] UV User Logout Bill, It looks like it's trying to write out maryann's command stack. SAVEDLISTS is apparently setup as a Type 1 file, and since maryann's stack key is longer, it's trying to create a sub-directory and write into it. It looks like maryann doesn't have appropriate prviileges to create the sub-directory in the SAVEDLISTS directory. You could resize the SAVEDLISTS file as a Type 19, or fix the owner /or group of SAVEDLISTS, or just turn STACK.WRITE off. Without looking, that's what I would guess. Best Regards, Richard Lewis On Wed, Jan 12, 2011 at 2:15 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: When one user here logs out via Dynamic Connect on HP-Ux 11i v2 running UV 10.3.6, she gets the following screenful... mkpath: SAVEDLISTS/S.maryann.13 is not a directory mkpath: SAVEDLISTS/S.maryann.13 is not a directory . . mkpath: SAVEDLISTS/S.maryann.13 is not a directory MaryAnn is setup like most everybody else. Clarification on the significance of this message would be appreciated. --Bill ___ 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] SB+ printer font changes
Hi All, I have a question about having the printer-font size switch to condensed when a SB+ report is sent to a laser printer (HP LaserJet) that is wider than 80 characters. I know that there is a SB+ user group but I cannot log into that from work and this is a work question. I was hoping that there would be a few people who are SB+ users to help me. Anyway, I created a report the same way as other reports that work just fine but this report refuses to switch from the large font. If I send the report to the screen it will switch to condensed print but not when I send it to the printer. Is there something in the printer setup? Printer Class definition? Stationary type? Or do I add something in the NETPROCESS Thanks for your help, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Server Socket logic
I'm unsure on how I should structure the logic flow when opening a server socket (UV 10.0.16 HP-UX 11i). At present I start with initServerSocket in the setup phase of the program, and then wait on acceptConnection. If there's an incoming connection I do readSocket; after the data is read I do writeSocket to send an ACK as required by the other end, then back to acceptConnection to wait for another incoming connection. Does this make sense ? When acceptConnection or readSocket times out I go back to acceptConnection again. At present I'm using 10 second timeouts for acceptConnection readSocket. Thanks for any comments ! David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * david.nor...@health.sa.gov.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
