Hello All:
My source file is a Complex flat file with Data Format set to EBCDIC and Record Style to Binary. I can view data fine.
In the table there is a column set to columnname char 1. The source file for that column is sending us something like 198655T. We need to accept only the character which is usually the last in the string and the rest to be filtered out. How do I do it...?
Thanks much.
MJ
String format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I believe the Right() function is more intuitively obvious.
Code: Select all
Right(InLink.Col1, 1)
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.
Hello:ray.wurlod wrote:I believe the Right() function is more intuitively obvious.Code: Select all
Right(InLink.Col1, 1)
Thank you.
Code: Select all
Right(InLink.Col1, 1)
Thanks,
MJ