How to code a forced tab in a CF?

[Rich S]

I'm stuck: I want to use a pipe symbol "|" to represent a forced tab character (Ctrl + Tab in Windows, Option+Tab in Mac) in a Let statement (to be used in text block-related calcs in a solution) but I just can't seem to nail it. How do I code that?

TIA for your help!

[comment]

Do you mean:

Let ( [

| = Char (9)

...

];

variableA & | & variableB

)

[Rich S]

Not quite, Mr. C.

Just as an example, say the current calc for the text block is:

Field1_text & " " & Field2_text & " " Field3_text

...where between the quotation marks is a forced tab. Also, the text block has tab marks/positions that aren't a fixed distance from each other character-wise.

So instead of having a blank space between the quotation marks I want a pipe symbol so I _know_ there's a forced tab between the fields (and that a forced tab is inserted between the fields.) Maybe the calc would look like this:

Field1_text & "|" & Field2_text & "|" Field3_text

...or this?

Field1_text & | & Field2_text & | Field3_text

[comment]

So where is the "not quite" part?

Instead of:

Field1_text & "" & Field2_text & "" Field3_text

write:

Let ( 

| = ""

;

Field1_text & | & Field2_text & | Field3_text

)

or (in version 10 and later):

Let ( 

| = Char(9)

;

Field1_text & | & Field2_text & | Field3_text

)