Originally posted by: SJacob

Hi, Can any one please help me with the below.

I have an input string of an Item of length 60.

I want to map the first 30 to a field and Map the remaining 30, starting from position 31 to another field.

Any suggestion would be greately appreciated.

Thanks.

SJacob

Originally posted by: paul.brett

Use LEFT(Input,30) and MID(Input,31,30)

Thank-you.

Paul

Follow me on Twitter

Originally posted by: SJacob

Thanks Paul.