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 9 months ago #22653 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 9 months ago #22655 by VK
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.

Time to create page: 0.077 seconds