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
Filter the string data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Funnily enough you need the Index() function. can be your constraint expression.
You *could* use Matches but need to specify the wildcard characters correctly.
Code: Select all
Index(InLink.TheString, "Index", 1) = 0
You *could* use Matches but need to specify the wildcard characters correctly.
Code: Select all
Not(InLink.TheString Matches "...'Index'...")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: