Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
define file
 Login/Join
 
Member
posted
Hi everybody,
Here is a piece of code:
DEFINE FILE S_REP_ANALYSIS
CCODE/I3 = COMPANY_CODE;
DCODE/I3 = DIVISION_CODE;
LASTN/A15 = GETTOK(SALES_REP_NAME, 20, -1, ' ', 15, LASTN);
FIRSTN/A15 = GETTOK(SALES_REP_NAME, 20, 1, ' ', 15, FIRSTN);
SRLIST/A70 = ',' || '"' || LASTNM || '"' || ',' || '"' || FIRSTNM || '"' || "," || '"' || SALES_REP_ID || '"' || ',' || '"' || EDIT(DCODE) || '"' || ',' || '"' || EDIT(CCODE) || '"';
END
TABLE FILE  S_REP_ANALYSIS
BY SRLIST
ON TABLE SAVE AS SALESREP FORMAT ALPHA
END 


...and it gives me the following error
"(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: LASTNM"

DIVISION_CODE, COMPANY_CODE, SALES_REP_NAME, SALES_REP_ID are fields in S_REP_ANALYSIS. I am trying to parse SALES_REP_NAME into last name and first name. SALES_REP_NAME is an A20V field, SALES_REP_ID is an A15V field.

What am I doing wrong?
Thank you very much
 
Posts: 24 | Registered: April 19, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
you have created a field named lastn in your define and not lastnm


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Reply With QuoteReport This Post
Member
posted Hide Post
oops..
Thanks.I am very embarrassed. I thought I checked and overchecked it, but now I realize that I was checking within GETTOK statement.
Thanks again.
 
Posts: 24 | Registered: April 19, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.