- Forum
- T24 Technical Discussions
- jBASE / TAFC
- Exclude the Multi value field Language on SAVING EVAL output
Exclude the Multi value field Language on SAVING EVAL output
- silvergem
- Topic Author
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 267
- Thank you received: 21
4 years 9 months ago #22653
by silvergem
Exclude the Multi value field Language on SAVING EVAL output was created by silvergem
Im trying to extract the customer name using the code below
The language multi-value was always at 2nd line
How can i extract specific language only on select statement?
SELECT FBNK.CUSTOMER SAVING UNIQUE EVAL "@ID:',':NAME.2:',':NAME.1:',':SHORT.NAME:',':CUST.TYPE"
The language multi-value was always at 2nd line
333288#NI##LUNETTERIE OPHTALMOL SPECIALISEE#LUNETTERIE OPHTALMOL SPECIALISEE
(LUNETTERIE SUPER VISION)
170519#I#ADRIEN KETANI#ADRIEN KETANI#ADRIEN
216458#I#ROSELORE WILLIAM#ROSELORE#WILLIAM
How can i extract specific language only on select statement?
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
4 years 9 months ago #22655
by VK
Cheers
VK
Replied by VK on topic Exclude the Multi value field Language on SAVING EVAL output
Language #1
UNIQUE EVAL "@ID:',':FIELD(NAME.2,@VM,1):',':FIELD(NAME.1,@VM,1):',':FIELD(SHORT.NAME,@VM,1)"
UNIQUE EVAL "@ID:',':FIELD(NAME.2,@VM,1):',':FIELD(NAME.1,@VM,1):',':FIELD(SHORT.NAME,@VM,1)"
Cheers
VK
The following user(s) said Thank You: silvergem
Please Log in or Create an account to join the conversation.
- Forum
- T24 Technical Discussions
- jBASE / TAFC
- Exclude the Multi value field Language on SAVING EVAL output
Time to create page: 0.077 seconds