Reading only file name in Datastage Windows

[AmeyJoshi14]

Hi Experts,

Datastage 9.
O/S Windows 2008 R2
DB SQL Server

We are unable to read just the filename from the sequential file for Datastage windows operating system. Currently the file name is populated as

Code: Select all

D:\LoadInputFile\StageArea\<FileName>.txt

The file path varies in different environment,so we can't hardcode any transformation logic.
Is there command like "basename" where in we can just populate the file name?

Appreciate all your help!

Thanks in Advance!!

[ray.wurlod]

Can't you use the basename command?

If not, research the tilde options (particularly ~n) for batch script arguments with the DOS shell. Type HELP CALL at a DOS prompt.

Yet another possibility is to treat the pathname as a set of backslash-delimited strings.

Code: Select all

Field(InLink.Pathname, "\", DCount(InLink.Pathname, "\"), 1)

[chulett]

I don't think you'd need to "hardcode" any transformation logic. I've had to do something similar in the past and put together a generic routine that would count the number of delimiters and then use Field() to take the count+1 delimited field from the full path.

[srinivas.nettalam]

You can count the number of '\' and take the text after the last '\' using string functions.

Code: Select all

For eg : Field(FileNameColumn,'\',Count(FileNameColumn,'\')+1)