script load shows error missing' ) 'bracket,need help please.

[#1]

Hi all,

I kindly request your help to resolve the below issue.

I have attached an application which has 2 fields in the script.but here the reload gives an error as 'missing a bracket")" 'I have checked the brackets of the if statement which are proper to my knowledge.Please can someone check the script and let me know what is missing.

Because of this the key words as,from are not highlighted also ???

regards,

sahana

[phaneendra_kunc · Accepted solution]

it is because of at the end you are trying to load URL with wrong format...

you just have single quotes around just on TEST.

try adding single quotes to entire text.

'all your URL text'

[sasikanth]

HI sahana

Error in last IF statement

( wildmatch(Counterparty,'*NOBLE RESOURCES INTERNATIONAL PT*','*TAMATAMA*','*BARA MITRA*')>=1,

'TEST' https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor, Counterparty)))))))))) as Counterparty1

in the above single quotes are there only for TEST, see below

Load like below

LOAD valRef,
if( wildmatch(Counterparty,'*PT ATLAS RESOURCES*')>=1,'ATLAS',
if( wildmatch(Counterparty,'*BERAU*','*MAPLE*')>=1,'BERAU',
if( wildmatch(Counterparty,'*COCKATOO*')>=1,'COCKATOO',
if( wildmatch(Counterparty,'*PLACEHOLDER*')>=1 & WildMatch([Noble Contract ID],'*ILFS*')>=1,'ILFS',
if( wildmatch(Counterparty,'PT ASMIN KOALINDO TUHUP')>=1,'AKT OFFTAKE',
if( wildmatch(Counterparty,'ASTON COAL 2 PTY LTD')>=1,'ASTON',
if( wildmatch(Counterparty,'LEDJADJA COAL (PTY) LTD')>=1,'RES GEN',
if( wildmatch(Counterparty,'*BLUESCOPE*')>=1,'BLUESCOPE',
if( wildmatch(Counterparty,'*YANCOAL*')>=1,'YANCOAL CMA',
if( wildmatch(Counterparty,'*NOBLE RESOURCES INTERNATIONAL PT*','*TAMATAMA*','*BARA MITRA*')>=1,
'TEST https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor', Counterparty)))))))))) as Counterparty
FROM

(ooxml, embedded labels);

[#4]

hi Phaneendra,

thanks a lot

[crusader_]

Hi,

The problem is in this string, not in brackets:

'TEST'https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor

I don't know what did you want but if you change to

'TEST'&'https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor'

Andrei