@Isini function

Hi Cristian and welcome to the site.

One way you could get a syntax error is if the field does not exist.  Are you sure that the SUPPLIER field exists and that it is a character field?

Brian

Hi Cristi,

Just a thought, which language are you using?  The seperator is different depending on the language.  I think for French and German it is the ";", so try replacing the "," with a ";" and see if that works.

Brian

Hi Cristi,

This is strange.  When it gives you the syntax error where does it show you the error is?

Also can you go into the IDEAScript editor and paste this script in and run it.  The message box should show what you should be using as a list separator.  Another things, can you go into your regional settings and let me know which language you are using that might also help. 

Public Const LOCALE_SLIST = &HC             '  list item separator
Public Const LOCALE_SDECIMAL = &HE          '  decimal separator
Public Const LOCALE_SDATE = &H1D            '  date separator
Public Const LOCALE_STIME = &H1E            '  time separator

Public Const LOCALE_SYSTEM_DEFAULT& = &H800
Public Const LOCALE_USER_DEFAULT& = &H400

Dim sListSeparator As String
Dim sDecimal As String
Dim sDateSeparator As String
Dim sTimeSeparator As String

Declare Function GetLocaleInfo Lib "kernel32" Alias "GetLocaleInfoA" (ByVal Locale As Long, ByVal LCType As Long, ByVal lpLCData As String, ByVal cchData As Long) As Long
Sub Main
                Call populateLocalVariables()
               
                MsgBox "List Separator: " & sListSeparator
End Sub

Function populateLocalVariables()
                sListSeparator = ReadLocaleInfo(LOCALE_SLIST )
                sDecimal = ReadLocaleInfo(LOCALE_SDECIMAL )
                sDateSeparator = ReadLocaleInfo(LOCALE_SDATE )
                sTimeSeparator = ReadLocaleInfo(LOCALE_STIME )
End Function

'*****************************************************************************************************************
'* VB function found at http://www.xtremevbtalk.com/showthread.php?t=162703
'* will return the regional setting based on the constant sent to it.
'*****************************************************************************************************************

Public Function ReadLocaleInfo(ByVal lInfo As Long) As String
   
                    Dim sBuffer As String
                    Dim rv As Long
                   
                    sBuffer = String$(256, 0)
                    rv = GetLocaleInfo(LOCALE_USER_DEFAULT, lInfo, sBuffer, Len(sBuffer))
                   
                    If rv > 0 Then
                        ReadLocaleInfo = Left$(sBuffer, rv - 1)
                    Else
                        ReadLocaleInfo = ""
                    End If
End Function

Ok, thanks for checking.  Another thought.  Did you copy and paste this equation in or did you type it in from scratch?  If you did a copy and paste may be try deleting it and retyping it in using the IDEA defaults.

Right now I am at a loss what to suggest.  Do you have a maintenance contract with IDEA?  If so I would contact your IDEA distributor for help.  Can you also check your regional settings and not your language settings as they could be different.  So in the control panel under the region and language which format are you using?