Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to to create new files from exciting filed that look like that: (123,1213,ffgfg,ddw....) - commas between the values
when I loaded from the DB I got this error:
The following error occurred:
Unexpected token: '',
IF(entryKey = '', expected one of: ',', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...
this is my code:
IF(entryKey = 'IPL',SubField(entryValue,',', 1)) as HeadSN,
IF(entryKey = 'IPL',SubField(entryValue,',', 2)) as Mode,
IF(entryKey = 'IPL',SubField(entryValue,',', 3)) as Application,
IF(entryKey = 'IPL',SubField(entryValue,',', 4)) as PresetType,
IF(entryKey = 'IPL',SubField(entryValue,',', 5)) as SkinType,
IF(entryKey = 'IPL',SubField(entryValue,',', 6)) as CI1,
IF(entryKey = 'IPL',SubField(entryValue,',', 7)) as CI2,
IF(entryKey = 'IPL',SubField(entryValue,',', 8)) as CI3,
IF(entryKey = 'IPL',SubField(entryValue,',', 9)) as Filter,
IF(entryKey = 'IPL',SubField(entryValue,',', 10)) as LightGuide,
IF(entryKey = 'IPL',SubField(entryValue,',', 11)) as Chiller,
IF(entryKey = 'IPL',SubField(entryValue,',', 12)) as PulseType,
IF(entryKey = 'IPL',SubField(entryValue,',', 13)) as T1,
IF(entryKey = 'IPL',SubField(entryValue,',', 14)) as D1,
IF(entryKey = 'IPL',SubField(entryValue,',', 15)) as T2,
IF(entryKey = 'IPL',SubField(entryValue,',', 16)) as D2,
IF(entryKey = 'IPL',SubField(entryValue,',', 17)) as T3,
IF(entryKey = 'IPL',SubField(entryValue, ',', 18)) as Energy,
IF(entryKey = 'IPL',SubField(entryValue, ',', 19)) as Energy1A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 20)) as Energy2A',
IF(entryKey = 'IPL',SubField(entryValue, ',', 21)) as Energy3A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 22)) as Current,
IF(entryKey = 'IPL',SubField(entryValue, ',', 23)) as Current1A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 24)) as Current2A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 25)) as Current3A,
IF(entryKey = 'IPL',SubField(entryValue, ',', 26)) as HeadFactor,
IF(entryKey = 'IPL',SubField(entryValue, ',', 27)) as LastPulses,
IF(entryKey = 'IPL',SubField(entryValue, ',', 28)) as User
;
Can you please explain to me what this error means and how i can avoid it ?
Looks like just a syntax issue. if you remove the single quote at the end of Energy2A does this resolve your issue?
IF(entryKey = 'IPL',SubField(entryValue, ',', 20)) as Energy2A',