Error while loading script

[#1]

Dear All

I am uploading an excel sheet which contains many data header starting with "["

for ex: [SPRJ] GPRO Involvement.

If I remove the character "[" manually then it loads the script.

The report coming out from the system contains starting character as "[".

Please suggest a solution to load the script with data header [SPRJ] GPRO Involvement

Best Regards

Rahul Kale

[its_anandrjs]

Hi,

It is because there is [ bracket start and end i suggest you if you load data with Explicit load and the in the load script rename the column name it works for you in this case if there is field like [SPRJ] GPRO loaded and then you rename it.

Regards,

Anand

[hic · Accepted solution]

Explicit load would work, but it is not necessary.

Load "[SPRJ] GPRO" From ...

will work fine. I.e. use double quotes instead of brackets to quote the field.

HIC

[#4]

Thanks Henric