Jump to content

Inserting tab character into text calculation field


This topic is 7403 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I need to create a calculation field that contains a TAB character. The calculation field takes text data from three fields and concastenates it.

The need is to be able to drag and drop the calculation field contents into Excel and have the contents placed into adjoining row cells. Exporting the three fields creates a file with TAB characters but I do not want to solve the problem this way.

Can anyone advise me as to the correct text string that creates a TAB character?

Link to comment
Share on other sites

quote:

Originally posted by John Browning:

I need to create a calculation field that contains a TAB character. The calculation field takes text data from three fields and concastenates it.

The need is to be able to drag and drop the calculation field contents into Excel and have the contents placed into adjoining row cells. Exporting the three fields creates a file with TAB characters but I do not want to solve the problem this way.

Can anyone advise me as to the correct text string that creates a TAB character?

In Layout mode, select the text tool and click, then type a tab character. Select all, which copies the invisible tab character to the clipboard, and go to define fields, open the calc field you are going to export and paste the tab character in the correct place in your text string or concatenation. I works like a charm, but the disadvantage is that if you forget that the tab character is there you will probably mistake it for a single space later.

By the way, if the tab character is to be inserted between two field names in you calculation, be sure to enclose it between quote marks.

Link to comment
Share on other sites

quote:

Originally posted by Moon Mullins:

In Layout mode, select the text tool and click, then type a tab character. Select all, which copies the invisible tab character to the clipboard, and go to define fields, open the calc field you are going to export and paste the tab character in the correct place in your text string or concatenation. I works like a charm, but the disadvantage is that if you forget that the tab character is there you will probably mistake it for a single space later.

By the way, if the tab character is to be inserted between two field names in you calculation, be sure to enclose it between quote marks.

A way around both of these problems is to create a calculated field called Tab and make it equal to the tab character. This way you can simply insert this field into your text and you will be able to see that it is a tab.

Link to comment
Share on other sites

quote:

Originally posted by CaptKurt:

A way around both of these problems is to create a calculated field called Tab and make it equal to the tab character. This way you can simply insert this field into your text and you will be able to see that it is a tab.

Capt Kurt,

Great technique. Why didn't I think of that?

Moon

Link to comment
Share on other sites

This topic is 7403 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.