Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Having a memory error

Status
Not open for further replies.

Stella001

Programmer
Mar 24, 2004
71
US
I am using Datastage TX 7.5
I have an input field of;

NAME / ADDRESS

For my first output I need everything left of the / , and of course for my next element output I need everything right of the /. I know I have done this rule before but I am not at my normal computer and can't lookup any of my old maps. Many thanks in advance.

Stella001

 
Use...
Code:
=WORD(field, "/", 1)
for the name, and...
Code:
=WORD(field, "/", 2)
for the address.

Richard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top