1. Forum
  3. T24 Technical Discussions
  5. jBASE / TAFC
  7. Exclude the Multi value field Language on SAVING EVAL output

Exclude the Multi value field Language on SAVING EVAL output

  • silvergem
  • silvergem's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
4 years 8 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
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?
Attachments:

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
4 years 8 months ago #22655 by 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)"
Cheers
VK
The following user(s) said Thank You: silvergem

Please Log in or Create an account to join the conversation.

  1. Forum
  3. T24 Technical Discussions
  5. jBASE / TAFC
  7. Exclude the Multi value field Language on SAVING EVAL output
Time to create page: 0.074 seconds