× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Donna, I understood your request as needing to "prep"
 the data on the Excel side.
You could also, right click on your worksheet tab and choose "View Code"

type this code:

Private Sub Worksheet_Change(ByVal Target As Range)
Cells.Replace What:="&", Replacement:="", LookAt:=xlPart,
SearchOrder:=xlByRows, MatchCase:=False
Cells.Replace What:="/", Replacement:="", LookAt:=xlPart,
SearchOrder:=xlByRows, MatchCase:=False
Cells.Replace What:="#", Replacement:="", LookAt:=xlPart,
SearchOrder:=xlByRows, MatchCase:=False
End Sub

make a new line for each character to want to eliminate.

make sure you use a new line for each row that begins with "cells."

HTH, 
Phil

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of donna lester
Sent: Tuesday, October 24, 2006 10:13 AM
To: RPG programming on the AS400 / iSeries
Subject: Special characters in PF

I have an XL sheet with 6 fields..Im converting xl into PF.
Among 6fields, 2 fields have problem  i.e. first name(field3) and last
name(field4) have got special characters & digits & quotes & slashes &
#...
I got to remove them & should have only alphabets from A to Z in first &
last names...
Please suggest me various techniques how do I this?
   
  Thanks for all the help.
  Donna


Thanks,

Donna.
                
---------------------------------
Stay in the know. Pulse on the new Yahoo.com.  Check it out. 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.