|
View previous topic :: View next topic
|
| Author |
Message |
Virinchi.Ravi
New User
Joined: 14 Sep 2012
Posts: 2
Location: India
|
|
|
|
Hi,
Good Morning. I am working on the FileAid Suite of tools provided by Compuware for ETL processing. As part of the solution, we have to Privatise Name fields and this is where I ran into some challenges. Below is the Scenario :
I have a flat file with below fields :
| Code: |
...
01 FULL-NAME PIC X(50).
...
|
It holds first name, Middle name and last name separated by Spaces.
For eg,
SACHIN R TENDULKAR
SUPER STAR RAJNI
FILE AID
Each word (token) in this field has to be translated. Output can be like
SHANE X WARNE
A B C
HTML ABC
I am using FileAid/Data Solutions 4.4. The Challenge is Splitting the name into three tokens.
I know that we can write a COBOL program and using Unstring we can split them. But I cannot write code here.
Do you know if FA/DS has any Built in String function to achieve this ?
Thanks,
Virinchi |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Since you have the product, you have the documentation. Have you tried looking there? Using PF1? Registering for the Compuware support site and searching/asking there? |
|
| Back to top |
|
|
Virinchi.Ravi
New User
Joined: 14 Sep 2012
Posts: 2
Location: India
|
|
|
|
Thanks for your reply. I posted here only as the last option. I read the documentation. As I understood, FileAid/DS does not have such kind of ability . But, I wanted to confirm before concluding.
I posted a mail to Compuware only to find that there is no response. There are no FileAid experts at my site.
I know one way which is not the best option to go with.
(1) Define three Global variables - &FIRST, &SECOND, &THIRD (To store three different words of Full-name)
(2) Scan through the FULL-WORD for 50 times (One time for each Character)
(3) If a Space occurs, append all characters as a word and Store in one of the 3 variables based on the Occurrence of the Space.
Since FileAid Does not have any String Function/Looping facity, nearly 250 sets of 'Selection Criteria' and 'Change criteria' have to be defined.
I know that this option will work, but I was looking for any other option that I am not aware of. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
You should try to register for their site. There may be discussion groups there where someone has done something similar.
It is a holiday weekend in the US, so not as many people as usual will be looking here. Try again late Monday/early Tuesday, perhaps.
If you get nowhere, there's always "do it in a program..." |
|
| Back to top |
|
|
|
|
