Forum Discussion

fox252's avatar
fox252
Frequent Visitor
4 years ago
Solved

Unexpected/ Strange Column References

Hello,   I'm experiencing a weird occurrence with column references. The source file comes from an internal reporting portal as .xls ( I know, not ideal). As seen in the Excel screen shot, there ar...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    In your Excel, put following formula

    =CODE(RIGHT(A1,1)) 

    where A1 is that cell header.

    You should get the answer - 10

    Character 10 is line break character in Excel. This is simulated by pressing ALT+Enter at the end of the line to go to next line.

    Hence, if yout type Yearly and press ALT+ENTER, you will go to next line and type Revenue.

    You will see following in place of Yearly Revenue

    Yearly
    Revenue

     

    The official name of Character 10 is Line Feed, hence in PQ, you need to write lf.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Looks like you used 1 in place of small case L in #(lf)...Could you check this out?

  • fox252's avatar
    fox252
    Frequent Visitor
    4 years ago

    It was in fact an "l" as opposed to "1", they look awfully similar in PQ pane.

     

    The bigger question though is why that suffix on col name?

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Most Valuable Professional
      4 years ago

      In your Excel, put following formula

      =CODE(RIGHT(A1,1)) 

      where A1 is that cell header.

      You should get the answer - 10

      Character 10 is line break character in Excel. This is simulated by pressing ALT+Enter at the end of the line to go to next line.

      Hence, if yout type Yearly and press ALT+ENTER, you will go to next line and type Revenue.

      You will see following in place of Yearly Revenue

      Yearly
      Revenue

       

      The official name of Character 10 is Line Feed, hence in PQ, you need to write lf.