DSXchange

Hi all,

I have a file (email.txt) which stores user emails and the subject area.

Format:

email1@domain,email2@domain,email3@domain|subject1
email21@domain|subject2
email31@domain,email32@domain|subject3

I created a sequencer contains
execute_command(cat) --> UVA --> Parallel Job --> Notification_activity

execute_command, it cat email.txt
UVA, define user_email variable to store email address from email.txt

code:
Ereplace(Field(EC_CAT.$CommandOutput,"|",1,-1),@FM,'')

Notification_activity will inherit value from user_email variable in UVA

In the user_email will always return first row from email.txt.
May I know if there is a way to read second row of record from email.txt based on the subject area (pass in as parameter)

Thanks in advance for your help.

If the subject areas are distinct, you could use grep command to read the line from the file.

Thanks ray. It works