String format

DS_MJ · Post by **DS_MJ** » Thu May 26, 2005 1:31 pm

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

amsh76 · Post by **amsh76** » Thu May 26, 2005 2:01 pm

substring or []...

ray.wurlod · Post by **ray.wurlod** » Thu May 26, 2005 5:05 pm

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

Code: Select all

Right(InLink.Col1, 1)

DS_MJ · Post by **DS_MJ** » Fri May 27, 2005 8:49 am

ray.wurlod wrote:I believe the Right() function is more intuitively obvious.
Code: Select all
Right(InLink.Col1, 1)

Hello:

Thank you.

Code: Select all

Right(InLink.Col1, 1)

works.

Thanks,
MJ