Page 1 of 1

Read from begging of a charecter till EOF

Posted: Tue Jan 31, 2012 1:44 am
by chetan.c
Hi,

In a file if i have data like this.

Col1
It costs me $100 for books.


How to read from "$" till the end of file?.

Thanks,
Chetan

Posted: Tue Jan 31, 2012 3:37 am
by ray.wurlod
Find the location of the "$" character, skip forward one character, and read the remainder.

Did you want to do this with an operating system command, a DataStage job or a DataStage routine?