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 :
01 FULL-NAME PIC X(50).
It holds first name, Middle name and last name separated by Spaces.
SACHIN R TENDULKAR
SUPER STAR RAJNI
Each word (token) in this field has to be translated. Output can be like
SHANE X WARNE
A B C
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 ?