XPR1 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
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 "."
(p
ailto: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
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) < 1
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
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
preprocessi
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 ma
ssage-
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 &
..@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
yanoke 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
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 th
Is TRIM what you are after?
On 12 January 2011 12:10, 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
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
13 matches
Mail list logo
