DSXchange

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

substring or []...

I believe the Right() function is more intuitively obvious.

ray.wurlod wrote:I believe the Right() function is more intuitively obvious.

Code: Select all

Right(InLink.Col1, 1)

Hello:

Thank you. works.

Thanks,
MJ