Export with variable length tabs

[larosche]

Hey!

I am trying to export records from my database with defined blank areas in each line. Currently I am using text export with tab delimiters.

For example;

1234 name number anothernumber

I know that I can limit an field to a set size using left(1234,4) that sets the first field to 4 characters.

How do I set the spaces between the fields?

Say I want 2 spaces from the "1234" and the "name" fields

then I want 4 spaces from the "name" field to the "number" field.

Thanks for the help,

RAD DAD

[Lee Smith]

HI larosche,

I'm not sure I understand you completely. If you are exporting your file as a "Tab Delimited Text" file, then there will be Tabs between your fields and a "Return" between your records when viewed in a Text Editor such as BBedit or TextPad.

If you are creating a Calculation Field Concatenating your fields to then export that field, then you need to use the " " and your different fields (i.e. Field A & " " & Field B & " " & Field C)

Note, there are four spaces inbetween the quotes shown.

HTH

Lee

[larosche]

Lee,

Your suggestion was the key I needed. I concatonated the fields using a single field and exported the field by itself. I was able to use variable spaces between the fields I wanted to export.

In other words I wanted

exported field = field1 & " " & field2 & " " & field

Thanks for the help!

Ed