Does anyone know how to sèpecify the tab character as the list separator
(ASCII 9)?
--
Stefano Gatto

Stefano Gatto <(E-Mail Removed)> wrote:

>Does anyone know how to sèpecify the tab character as the list separator
>(ASCII 9)?

What application are you talking about?

--
Tim Slattery
MS MVP(DTS)
(E-Mail Removed)
http://members.cox.net/slatteryt

Depends on the application. Did you try looking it up in Help for the app?

Stefano Gatto wrote:

> Does anyone know how to sèpecify the tab character as the list separator
> (ASCII 9)?

Windows XP.
--
Stefano Gatto


"Bob I" wrote:

> Depends on the application. Did you try looking it up in Help for the app?
>
> Stefano Gatto wrote:
>
> > Does anyone know how to sèpecify the tab character as the list separator
> > (ASCII 9)?
>
>

Windows XP is an Operating system. Applications are programs, try
explaining what you are trying to do.

Stefano Gatto wrote:

> Windows XP.

Ok. I wish to change the list separator character from the comma to the TAB
character. This character is (re)used by Excel when it exports/imports data
in text format, and in many other places. It is recommended that the List
Separator is not the same as the Decimal Separator, for obvious reasons.
Because Europeans use the comma as Decimal Separator, they usually choose the
semi-colon as the List Separator in their system...

You can change Windows List Separator in:

Start / Settings / Control Panel / Regional and Language Options / Customize
/ Numbers tab / List Separator field.

As you may notice this field may contain up to 3 characters. What I wish is
to have a TAB character in there.

I just thought of changing it in the registry directly (you can enter binary
codes there) but I do not know the key...
--
Thank you for your help.

Stefano Gatto


"Bob I" wrote:

> Windows XP is an Operating system. Applications are programs, try
> explaining what you are trying to do.
>
> Stefano Gatto wrote:
>
> > Windows XP.
>
>

Stefano Gatto <(E-Mail Removed)> wrote:

>Ok. I wish to change the list separator character from the comma to the TAB
>character. This character is (re)used by Excel when it exports/imports data
>in text format, and in many other places. It is recommended that the List
>Separator is not the same as the Decimal Separator, for obvious reasons.
>Because Europeans use the comma as Decimal Separator, they usually choose the
>semi-colon as the List Separator in their system...
>
>You can change Windows List Separator in:
>
>Start / Settings / Control Panel / Regional and Language Options / Customize
>/ Numbers tab / List Separator field.

Have you tried

\t

--
Tim Slattery
MS MVP(DTS)
(E-Mail Removed)
http://members.cox.net/slatteryt

In Excel, it is selected on a per file basis, and the Windows List
Separator "setting" has no effect. You Export a Tab delimited file ot
you Import and select Tab as the delimiter. Simple as that. For what
it's worth commas are used as both the thousands and the list separator
in the US, but if you truly want to change that in Regions then Open
Wordpad, insert a tab, copy it and paste it into Regional List separator
box.

Stefano Gatto wrote:
> Ok. I wish to change the list separator character from the comma to the TAB
> character. This character is (re)used by Excel when it exports/imports data
> in text format, and in many other places. It is recommended that the List
> Separator is not the same as the Decimal Separator, for obvious reasons.
> Because Europeans use the comma as Decimal Separator, they usually choose the
> semi-colon as the List Separator in their system...
>
> You can change Windows List Separator in:
>
> Start / Settings / Control Panel / Regional and Language Options / Customize
> / Numbers tab / List Separator field.
>
> As you may notice this field may contain up to 3 characters. What I wish is
> to have a TAB character in there.
>
> I just thought of changing it in the registry directly (you can enter binary
> codes there) but I do not know the key...

I tried \t, but it uses ASCII 0 as delimiter, not ASCII 9.

Good to know this anyway.

Thank you for the suggestion.

--
Stefano Gatto


"Tim Slattery" wrote:

> Stefano Gatto <(E-Mail Removed)> wrote:
>
> >Ok. I wish to change the list separator character from the comma to the TAB
> >character. This character is (re)used by Excel when it exports/imports data
> >in text format, and in many other places. It is recommended that the List
> >Separator is not the same as the Decimal Separator, for obvious reasons.
> >Because Europeans use the comma as Decimal Separator, they usually choose the
> >semi-colon as the List Separator in their system...
> >
> >You can change Windows List Separator in:
> >
> >Start / Settings / Control Panel / Regional and Language Options / Customize
> >/ Numbers tab / List Separator field.
>
> Have you tried
>
> \t
>
> --
> Tim Slattery
> MS MVP(DTS)
> (E-Mail Removed)
> http://members.cox.net/slatteryt
>

It works! Many thanks.

To tell you the truth, I did not know what my colleague who asked for this
exactly wanted it for... Anyway the major drawback is that he will need to
use that same character to separate arguments in Excel functions... and just
this aspect may have fatal consequences. From my perspective this was
interesting enough per sè and I am going to tell my colleague to use the "TAB
delimited export" functionality in case this is what he wanted.

Note that your suggestion is perfect for the TAB character, but not for
other characters Wordpad would not handle, e.g. ASCII 00.
--
Stefano Gatto


"Bob I" wrote:

> In Excel, it is selected on a per file basis, and the Windows List
> Separator "setting" has no effect. You Export a Tab delimited file ot
> you Import and select Tab as the delimiter. Simple as that. For what
> it's worth commas are used as both the thousands and the list separator
> in the US, but if you truly want to change that in Regions then Open
> Wordpad, insert a tab, copy it and paste it into Regional List separator
> box.
>
> Stefano Gatto wrote:
> > Ok. I wish to change the list separator character from the comma to the TAB
> > character. This character is (re)used by Excel when it exports/imports data
> > in text format, and in many other places. It is recommended that the List
> > Separator is not the same as the Decimal Separator, for obvious reasons.
> > Because Europeans use the comma as Decimal Separator, they usually choose the
> > semi-colon as the List Separator in their system...
> >
> > You can change Windows List Separator in:
> >
> > Start / Settings / Control Panel / Regional and Language Options / Customize
> > / Numbers tab / List Separator field.
> >
> > As you may notice this field may contain up to 3 characters. What I wish is
> > to have a TAB character in there.
> >
> > I just thought of changing it in the registry directly (you can enter binary
> > codes there) but I do not know the key...
>
>