Alternate to UNIX `grep` in Datastage Basic

[Madhusv]

Hi All,

I am writing after job routine .

I need function which gets the line of the search string, I want to take first part of the line(here i can use Field). Delimiter in the line is /.

Is there any alternate to UNIX `grep` in Datastage Basic Or is there any other logic to do the same.

Also can i use DSExecute to interact with UNIX(AIX) shell.


Regards,
Madhu

[vmcburney]

If you are talking about using search and replace on the data in the file you are better off doing it in the job via a transformer. Otherwise the easiest way to do grep is to call the grep command via dsexecute. Have a look at the DataStage BASIC Guide or do a forum search for the dozens of dsexecute examples.

[kumar_s]

Hi,

You can do the same from Datastage Basic.
You can use DSExecutable to do the same. This is to perform all the unix command in that.
You can store it into a variable and use the field function to partion.

Regards
Kumar

[kduke]

If you want to find a string then use INDEX() in BASIC. Do a search. How to use INDEX() in BASIC has been covered a lot. You need UPCASE() or DOWNCASE() to make it case insensitive.