Field name with carriage return

[#1]

I am importing about 100 Excel spreadsheets. Some of the field names have carriage returns in them. I can import them with an "*" but how do you reference the field name in script? They work fine in objects. Is there a way of referencing them by field number, for example? There is also some inconsistancy in the worksheet names. Can you you reference worksheets by their sheet number?

Vous pouvez me répondre en français si vous êtes plus à l'aise.

[Miguel_Angel_Baeyens]

Hope that goes fine Kevin. Let us know in any case.

[#3]

I have the same problem as Kevin. I have let QlikView generate the load statement yet it still gives a 'Field not found' error on a field with a linefeed in it. Any help would be much appreciated.

[boorgura]

Not sure if you found any solution for this issue?

I was trying to access a field with Carriage return in the field name from an excel file and I have no issue with it.

Can you please post a sample file?

[#5]

I finally used explicit field names to import the files as per your suggestion. I was having a problem with columns being inconsistent but I this has been fixed. I still haven't found a way of using field names with carriage returns. They work fine in objects but there is no way to reference them in script. This is an example of one of my field names:

[Master

Project ID]

[boorgura]

Ok - I think I missed one of the things I wanted to ask.

When you say the field names have a carriage return, in the excel i am using,

the carriage return is placed using ALT+Enter, within the same cell.

Is your source file something different??

[#7]

Yes, the headers in question in my sheets have been created using Alt+Enter which creates the Chr(10) character (line feed) rather than Chr(13) (carriage return). I don't know if that would make a difference but given we've both used Alt+Enter I suspect not.