RE: Special characters in PF

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.