How to remove extra chacracter in exported files

When I export data in DBF ot TXT formats for FMP 5 I get extra characters.
They look like little squares and they show up in Excel and different text
editors. (I tried to paste a sample into this post but they dissapeared)

I don't know what they are but I am guessing extended ASCII and or some sort
of control characters. They don't show up in the original Filemaker
datafile and they only seem to be in feilds that I paste into FMP.

Does anyone know how I can get rid of them?

Thanks!!!!!

[Rob van den Brink]

Hi,

I know these characters, and as I understand them, those are translated in
FileMaker as a return (linefeed).

If you export fields that have nog return in them, you loose these squares
as well...

With kind regards,


Rob van den Brink

> From: <mojotogo@sbcglobal.net>
> Organization: SBC [url]http://yahoo.sbc.com[/url]
> Newsgroups: comp.databases.filemaker
> Date: Thu, 28 Aug 2003 13:47:49 GMT
> Subject: How to remove extra chacracter in exported files
>
>
> When I export data in DBF ot TXT formats for FMP 5 I get extra characters.
> They look like little squares and they show up in Excel and different text
> editors. (I tried to paste a sample into this post but they dissapeared)
>
> I don't know what they are but I am guessing extended ASCII and or some sort
> of control characters. They don't show up in the original Filemaker
> datafile and they only seem to be in feilds that I paste into FMP.
>
> Does anyone know how I can get rid of them?
>
> Thanks!!!!!
>
>
>

[John B.]

in article BB74A5E4.2BD8%bridgeteley@ihug.com.au, Bridget Eley at
[email]bridgeteley@ihug.com.au[/email] wrote on 8/28/03 1:40 PM:

> It is the VT character (vertical tabulation, control-K on a Mac)

Incidentally, the ASCII number for the Vertical Tab character is ASCII 11.

John

> and it
> represents the way filemaker exports return characters within a text field
> to a tab delimited text file, a process which itself uses the CR character
> (carriage return or hard return) as a means to delimit records.
>
> I don't know if you can get rid of them in the export process, but you can
> certainly get rid of them in a good text editor, just copy the character,
> paste it into the find field, enter a CR into the replace field then click
> replace all. NB: This will necessarily prevent the text being used in
> further tab delimited imports or operations.
>
> Bridget Eley
>
> in article 9Kn3b.35215$Vx2.15295990@newssvr28.news.prodigy.co m,
> [email]mojotogo@sbcglobal.net[/email] at [email]mojotogo@sbcglobal.net[/email] wrote on 28/8/03 11:47 PM:
>

>>
>> When I export data in DBF ot TXT formats for FMP 5 I get extra characters.
>> They look like little squares and they show up in Excel and different text
>> editors. (I tried to paste a sample into this post but they dissapeared)
>>
>> I don't know what they are but I am guessing extended ASCII and or some sort
>> of control characters. They don't show up in the original Filemaker
>> datafile and they only seem to be in feilds that I paste into FMP.
>>
>> Does anyone know how I can get rid of them?
>>
>> Thanks!!!!!
>>
>>
>>

>

Is there any way to use the TRIM function to remove the VT character
(vertical tabulation / ASCII 11)

I can't figure out how to enter this "little box" character into a calulated
function on a PC

Any ideas?


"John B." <John@SingingWood.com> wrote in message
news:BB73BF55.A3C3%John@SingingWood.com...

> in article BB74A5E4.2BD8%bridgeteley@ihug.com.au, Bridget Eley at
> [email]bridgeteley@ihug.com.au[/email] wrote on 8/28/03 1:40 PM:
>

> > It is the VT character (vertical tabulation, control-K on a Mac)

>
> Incidentally, the ASCII number for the Vertical Tab character is ASCII 11.
>
> John
>

> > and it
> > represents the way filemaker exports return characters within a text

field

> > to a tab delimited text file, a process which itself uses the CR

character

> > (carriage return or hard return) as a means to delimit records.
> >
> > I don't know if you can get rid of them in the export process, but you

can

> > certainly get rid of them in a good text editor, just copy the

character,

> > paste it into the find field, enter a CR into the replace field then

click

> > replace all. NB: This will necessarily prevent the text being used in
> > further tab delimited imports or operations.
> >
> > Bridget Eley
> >
> > in article 9Kn3b.35215$Vx2.15295990@newssvr28.news.prodigy.co m,
> > [email]mojotogo@sbcglobal.net[/email] at [email]mojotogo@sbcglobal.net[/email] wrote on 28/8/03 11:47

PM:

> >

> >>
> >> When I export data in DBF ot TXT formats for FMP 5 I get extra

characters.

> >> They look like little squares and they show up in Excel and different

text

> >> editors. (I tried to paste a sample into this post but they

dissapeared)

> >>
> >> I don't know what they are but I am guessing extended ASCII and or some

sort

> >> of control characters. They don't show up in the original Filemaker
> >> datafile and they only seem to be in feilds that I paste into FMP.
> >>
> >> Does anyone know how I can get rid of them?
> >>
> >> Thanks!!!!!
> >>
> >>
> >>

> >

>

[Rob van den Brink]

It looks to me that you could use a substitute statement in order to replace
it with another symbol, say pipeline (|).

use:

Insert calculated result(select, <name textfield>, Substitute(<name
textfield, "¶", "|")

Place it in a loop before exporting and make sure you replace the "|" within
the program you use after FileMaker.

Met vriendelijke groet,

Rob van den Brink

Appoint Holding
Stationsplein 45
NL-3013 AK Rotterdam
tel. 010 281 1711
fax. 010 281 1789
mob 06 55 70 40 52

[url]http://www.appoint.nl[/url]

Amsterdam, Rotterdam, Den Haag, Maarssen, Den Bosch
* Media * Business * IT * Communicatie * Employability *

***************************** DISCLAIMER *******************************
This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Appoint Holding B.V. and / or one of her subsidiary companies
rules out every liability resulting from any electronic transmission.
************************************************** ********************

> From: <mojotogo@sbcglobal.net>
> Organization: SBC [url]http://yahoo.sbc.com[/url]
> Newsgroups: comp.databases.filemaker
> Date: Fri, 29 Aug 2003 06:13:54 GMT
> Subject: Remove VT character with TRIM function ? ? ? ? ?
>
> Is there any way to use the TRIM function to remove the VT character
> (vertical tabulation / ASCII 11)
>
> I can't figure out how to enter this "little box" character into a calulated
> function on a PC
>
> Any ideas?
>
>
> "John B." <John@SingingWood.com> wrote in message
> news:BB73BF55.A3C3%John@SingingWood.com...

>> in article BB74A5E4.2BD8%bridgeteley@ihug.com.au, Bridget Eley at
>> [email]bridgeteley@ihug.com.au[/email] wrote on 8/28/03 1:40 PM:
>>

>>> It is the VT character (vertical tabulation, control-K on a Mac)

>>
>> Incidentally, the ASCII number for the Vertical Tab character is ASCII 11.
>>
>> John
>>

>>> and it
>>> represents the way filemaker exports return characters within a text

> field

>>> to a tab delimited text file, a process which itself uses the CR

> character

>>> (carriage return or hard return) as a means to delimit records.
>>>
>>> I don't know if you can get rid of them in the export process, but you

> can

>>> certainly get rid of them in a good text editor, just copy the

> character,

>>> paste it into the find field, enter a CR into the replace field then

> click

>>> replace all. NB: This will necessarily prevent the text being used in
>>> further tab delimited imports or operations.
>>>
>>> Bridget Eley
>>>
>>> in article 9Kn3b.35215$Vx2.15295990@newssvr28.news.prodigy.co m,
>>> [email]mojotogo@sbcglobal.net[/email] at [email]mojotogo@sbcglobal.net[/email] wrote on 28/8/03 11:47

> PM:

>>>
>>>>
>>>> When I export data in DBF ot TXT formats for FMP 5 I get extra

> characters.

>>>> They look like little squares and they show up in Excel and different

> text

>>>> editors. (I tried to paste a sample into this post but they

> dissapeared)

>>>>
>>>> I don't know what they are but I am guessing extended ASCII and or some

> sort

>>>> of control characters. They don't show up in the original Filemaker
>>>> datafile and they only seem to be in feilds that I paste into FMP.
>>>>
>>>> Does anyone know how I can get rid of them?
>>>>
>>>> Thanks!!!!!
>>>>
>>>>
>>>>
>>>

>>

>
>