Tab delimited text file using a Dataport

Apricot · 2006-10-19

Hi there,

Whats's the best way to get a Tab delimited text file using a dataport. For example the output from an Item table should look like this

Item No Description Unit Price Qty in Hand
123344 RubberCap 1.20 36

Thanks in advance

Apricot

nunomaia · 2006-10-19

A you referring using <TAB> in FieldStartDelimiter ?

Alex_Chow · 2006-10-19

Also, you have to make sure that the FieldStartDelimiter and FieldEndDelimiter is set as <None>

Apricot · 2006-10-19

hi, Thanks

I tried putting <None> in FieldStartDelimiter and FieldEndDelimiter, this helped to get the fields with no separator, which is good but I still can't get a TAB(basically space) between the fields.

It created output like this

10000ASSETS0

What I'm looking for is

10000 ASSETS 0

Thanks Guys

A

Savatage · 2006-10-19

FieldSeparator

Use this property to define the string that is to be used to separate fields.

<None> that there will no be FieldSeparator
<NewLine> any combination of CR and LF characters
<CR/LF> CR followed by LF
<CR> CR alone
<LF> LF alone
<TAB> Tabulator alone
Other strings the literal string entered

The strings in the table above must be entered literally, that is: the < and > characters must be entered. These special strings can be combined and can also be mixed with other characters.

The default is , (a comma).

CR refers to the character with ASCII value 13
LF refers to the character with ASCII value 10

DenSter · 2006-10-19

<TAB> in the FieldSeparator property, including the < and the >. I don't know if this is a different value in other languages, but you can hit F1 from the property and you will see the values you can use.

Apricot · 2006-10-19

Ya, it worked, Thanks a lot guys-

Tab delimited text file using a Dataport

Comments

Categories