Mistake in Statement

[carolin01]

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!!!

[crusader_ · Accepted solution]

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

[its_anandrjs]

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.

[#4]

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

[alexandros17]

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

[#6]

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

[its_anandrjs]

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

[its_anandrjs]

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.