Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: Dealing with UTF-8 in BRAINscript

  1. #21

    Default

    I tried with Unidode as well but still it's not working.

  2. #22
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    185

    Default

    At first I thought it was just data in a field and not the field name itself. I don't think you're going to be able to read this without manipulating the fieldnames.

    Here's an idea - you might be able to use headerRow="2" to skip the header and then have some logic to rename fields back using inputFields(1). Have a look at this reading a simple Excel and bypassing the header row.

    Code:
    node:Excel_File
    bretype:core::Excel File
    editor:sortkey=5d012dbf08020e2a
    output:@48cf6cd2305e5f95/=
    prop:File={{^FileName^}}
    prop:UseSystemLocale=false
    prop:WorkbookSpec=<<EOX
    <workbook>
    <sheet index="1" headerRow="2" dataStartRow="2" />
    </workbook>
    EOX
    editor:XY=350,380
    end:Excel_File
    
    node:Filter_3
    bretype:core::Filter
    editor:sortkey=5d013ade07242fe9
    input:@40fd2c74167f1ca2/=Excel_File.48cf6cd2305e5f95
    output:@40fd2c7420761db6/=
    prop:Script=<<EOX
    _inputFields = inputFields(1)
    
    emit _inputFields[0] as "Field1"
    
    EOX
    editor:XY=450,380
    end:Filter_3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •