Filter the string data

arshi · Post by **arshi** » Fri Oct 03, 2008 1:09 am

Hi,

I have a requirement to filter the 5 character data from the source file and load the data into Target.Source data will provide in text file with pipe delimeter.How to impliment this logic and is there any function available in datastage.

Datastage: Server edition(7.X)
Source: Text File(Pipe delimetr)

Regards,
Arshi

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 1:52 am

Sequential File stage with pipe character ("|") specified as the field separator.

arshi · Post by **arshi** » Fri Oct 03, 2008 2:51 am

Ray,

Once importing data into sequential file,how to build the mentioned filter logic(to filter the 5 character data from the source file ) .Can you give the solution for this.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 3:49 am

What do you mean by "filter"?

arshi · Post by **arshi** » Fri Oct 03, 2008 4:13 am

Hi,

One of my source column data having the word 'Index' (this word is part of the Text).If the 'Index' word occured then I want to remove that particular row while populating to the Target.

I am trying with 'Matches' function.But unable to get the solution.

Regards,Arshi

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 4:54 am

Funnily enough you need the Index() function.

Code: Select all

Index(InLink.TheString, "Index", 1) = 0

can be your constraint expression.

You *could* use Matches but need to specify the wildcard characters correctly.

Code: Select all

Not(InLink.TheString Matches "...'Index'...")

arshi · Post by **arshi** » Fri Oct 03, 2008 7:50 am

Its working fine by using Index() function

Thanks,
Arshi

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 3:53 pm

Please mark this thread as Resolved using the green button at top.