Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
can anybody tell me what I´m doing wrong with this statement:
Load
BaseItem,
Len (BaseItem) as BaseItemLength,
'Sensor' as BaseItemDesc1,
'G-Series' as BaseItemDesc2,
mid(BaseItem, 1, 2) as Design,
'Standard rod version' as HousingType,
mid(BaseItem, 3, 1) as DESIGN_OP,
'' as MAGNET_TYPE,
'' as MAGNET_TYPE_DESC,
mid(BaseItem, 4, 4) as LENGTH,
mid(BaseItem, 8, 1) as LENGTH_DESC,
mid(BaseItem, 9, 3) as Connection_Type,
if(mid(BaseItem,9,1 = 'D', '',
if(mid(BaseItem,9,1 = 'M', '',
if(mid(BaseItem,9,3 = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00', '',
(mid(BaseItem, 10, 2)))))))) as CableLenght,
mid(BaseItem, 12, 1) as Options,
mid(BaseItem, 13, 6) as POS_OUT
Resident dProductsLud
Where (mid(BaseItem, 1, 2) = 'GH');
I just don´t see it where I´m doing the mistake for field CableLenght. Many thanks for your help in advance!!!
Hi Carolin,
Try to unpack your statement, as I understood you meant :
if(mid(BaseItem,9,1) = 'D', '',
if(mid(BaseItem,9,1) = 'M', '',
if(mid(BaseItem,9,3) = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00', '',
(mid(BaseItem, 10, 2))))) as CableLenght,
You didn't close the brackets in mid()
And you ain't allowed to do that
mid(BaseItem,9,3) = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00'
Andrei
Hi Carolin,
Try to unpack your statement, as I understood you meant :
if(mid(BaseItem,9,1) = 'D', '',
if(mid(BaseItem,9,1) = 'M', '',
if(mid(BaseItem,9,3) = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00', '',
(mid(BaseItem, 10, 2))))) as CableLenght,
You didn't close the brackets in mid()
And you ain't allowed to do that
mid(BaseItem,9,3) = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00'
Andrei
In below line of statement you did mistake
if(mid(BaseItem,9,3 = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00','',
your mid function is not correct also so many conditions i suggest use match for this if there are many condition.
Hi Caroline,
if
(mid(BaseItem,9,1 = 'D', '',
missing closing bracket
(mid(BaseItem,9,1)= 'D', '',
and so on?
Small typo in the name as well
if(mid(BaseItem,9,1 = 'D', '',
if(mid(BaseItem,9,1 = 'M', '',
if(mid(BaseItem,9,3 = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00', '',
(mid(BaseItem, 10, 2)))))))) as CableLenght,
mid(BaseItem,9,3 ... you have missed the ) of closure (also in next mid...)
Hope it helps
Hi Carolin Borchert ,
'' as MAGNET_TYPE,
'' as MAGNET_TYPE_DESC,
what is this in your script?
this is wrong in u r script.
Thank you
There are many mistakes in the script like
1.mid function using in if mid(BaseItem, 12, 1) but not clearly define,
2. Many conditions like 'RB1','RB2','FM1','FM2','RR8' with or which is not clearlly define
3. Closing brackets not apply correctly
Here is your complete load statement
Load
BaseItem,
Len (BaseItem) as BaseItemLength,
'Sensor' as BaseItemDesc1,
'G-Series' as BaseItemDesc2,
mid(BaseItem, 1, 2) as Design,
'Standard rod version' as HousingType,
mid(BaseItem, 3, 1) as DESIGN_OP,
'' as MAGNET_TYPE,
'' as MAGNET_TYPE_DESC,
mid(BaseItem, 4, 4) as LENGTH,
mid(BaseItem, 8, 1) as LENGTH_DESC,
mid(BaseItem, 9, 3) as Connection_Type,
if(mid(BaseItem,9,1) = 'D', '',
if(mid(BaseItem,9,1) = 'M', '',
if(Match(mid(BaseItem,9,3), 'RB1', 'RB2', 'FM1', 'FM2', 'RR8', 'RR4', 'RR5', 'RR6', 'RRH', 'FD1', 'FD2', 'K00'), '',(mid(BaseItem, 10, 2))))) as CableLenght,
mid(BaseItem, 12, 1) as Options,
mid(BaseItem, 13, 6) as POS_OUT
Resident dProductsLud
Where (mid(BaseItem, 1, 2) = 'GH');
with new update.