Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

Links

XODOX
Impressum

#1: How to insert quote into a variable

Posted on 2008-04-15 22:11:32 by Guy

I need to replace all quotes with a null.

This is necessary when importing a tab delimited file that has a few comma's
which ar econverted to a quoted field.

e.g. COPS, Inc. is changed to "COPS, Inc."

In the replace dialog for a script step, I cannot enter the " as the string.
Help.

Guy

--
-------------------------------------------------
Captain Guy
s/v Island Time (Beneteau 352#277)
AICW 845.5
386-689-5088

Report this message

#2: Re: How to insert quote into a variable

Posted on 2008-04-15 22:33:28 by Remi-Noel Menegaux

You may have a special text field put in a one record only table, in which
you put by hand, once, a character copied-pasted from Word. Then you include
that field instead of the """.
Remi-Noel

"Guy" <guy@guym.com> a écrit dans le message de
news:EOidncfUge4rkZjVnZ2dnUVZ_jadnZ2d@earthlink.com...
>I need to replace all quotes with a null.
>
> This is necessary when importing a tab delimited file that has a few
> comma's which ar econverted to a quoted field.
>
> e.g. COPS, Inc. is changed to "COPS, Inc."
>
> In the replace dialog for a script step, I cannot enter the " as the
> string. Help.
>
> Guy
>
> --
> -------------------------------------------------
> Captain Guy
> s/v Island Time (Beneteau 352#277)
> AICW 845.5
> 386-689-5088
>

Report this message

#3: Re: How to insert quote into a variable

Posted on 2008-04-15 22:45:57 by Howard Schlossberg

Guy wrote:
> In the replace dialog for a script step, I cannot enter the " as the string.
> Help.

Try escaping the quote, as in: \"
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance

Report this message

#4: Re: How to insert quote into a variable

Posted on 2008-04-17 21:33:02 by Guy

Easier than that (but you got me thiinking)

at script run time, insert " into a global field, then reference the global
in the replace step.

BTW, escape char does nit work.

Guy


"Remi-Noel Menegaux" <rnmenegaux AT free.fr> wrote in message
news:48051122$0$23028$426a74cc@news.free.fr...
> You may have a special text field put in a one record only table, in which
> you put by hand, once, a character copied-pasted from Word. Then you
> include that field instead of the """.
> Remi-Noel
>
> "Guy" <guy@guym.com> a écrit dans le message de
> news:EOidncfUge4rkZjVnZ2dnUVZ_jadnZ2d@earthlink.com...
>>I need to replace all quotes with a null.
>>
>> This is necessary when importing a tab delimited file that has a few
>> comma's which ar econverted to a quoted field.
>>
>> e.g. COPS, Inc. is changed to "COPS, Inc."
>>
>> In the replace dialog for a script step, I cannot enter the " as the
>> string. Help.
>>
>> Guy
>>
>> --
>> -------------------------------------------------
>> Captain Guy
>> s/v Island Time (Beneteau 352#277)
>> AICW 845.5
>> 386-689-5088
>>
>

Report this message

#5: Re: How to insert quote into a variable

Posted on 2008-04-17 21:45:05 by Howard Schlossberg

Guy wrote:
> BTW, escape char does nit work.

Well, it's entirely possible that, if you are searching, the quotes may
have been curly quotes...in which case searching for straight quotes
won't work. But for straight quotes, searching for "\"" does work.

>
> Guy
>
>
> "Remi-Noel Menegaux" <rnmenegaux AT free.fr> wrote in message
> news:48051122$0$23028$426a74cc@news.free.fr...
>> You may have a special text field put in a one record only table, in which
>> you put by hand, once, a character copied-pasted from Word. Then you
>> include that field instead of the """.
>> Remi-Noel
>>
>> "Guy" <guy@guym.com> a écrit dans le message de
>> news:EOidncfUge4rkZjVnZ2dnUVZ_jadnZ2d@earthlink.com...
>>> I need to replace all quotes with a null.
>>>
>>> This is necessary when importing a tab delimited file that has a few
>>> comma's which ar econverted to a quoted field.
>>>
>>> e.g. COPS, Inc. is changed to "COPS, Inc."
>>>
>>> In the replace dialog for a script step, I cannot enter the " as the
>>> string. Help.
>>>
>>> Guy
>>>
>>> --
>>> -------------------------------------------------
>>> Captain Guy
>>> s/v Island Time (Beneteau 352#277)
>>> AICW 845.5
>>> 386-689-5088
>>>
>
>

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance

Report this message

#6: Re: How to insert quote into a variable

Posted on 2008-04-17 23:50:00 by Remi-Noel Menegaux

Fine, but how exactly do you put by script a " into a global ?
Remember also that 'globals' are 'local' ie attached to each user on a
'shared' DB.
Remi-Noel

"Guy" <guy@guym.com> a écrit dans le message de
news:uv-dnbIaA9rvO5rVnZ2dnUVZ_tqtnZ2d@earthlink.com...
> Easier than that (but you got me thiinking)
>
> at script run time, insert " into a global field, then reference the
> global in the replace step.
>
> BTW, escape char does nit work.
>
> Guy
>
>
> "Remi-Noel Menegaux" <rnmenegaux AT free.fr> wrote in message
> news:48051122$0$23028$426a74cc@news.free.fr...
>> You may have a special text field put in a one record only table, in
>> which you put by hand, once, a character copied-pasted from Word. Then
>> you include that field instead of the """.
>> Remi-Noel
>>
>> "Guy" <guy@guym.com> a écrit dans le message de
>> news:EOidncfUge4rkZjVnZ2dnUVZ_jadnZ2d@earthlink.com...
>>>I need to replace all quotes with a null.
>>>
>>> This is necessary when importing a tab delimited file that has a few
>>> comma's which ar econverted to a quoted field.
>>>
>>> e.g. COPS, Inc. is changed to "COPS, Inc."
>>>
>>> In the replace dialog for a script step, I cannot enter the " as the
>>> string. Help.
>>>
>>> Guy
>>>
>>> --
>>> -------------------------------------------------
>>> Captain Guy
>>> s/v Island Time (Beneteau 352#277)
>>> AICW 845.5
>>> 386-689-5088
>>>
>>
>
>

Report this message

#7: Re: How to insert quote into a variable

Posted on 2008-04-18 03:54:26 by Guy

At run time (like called from an import script)
-goto record first
-go to layout whatever
-insert text into field _Global_1; " <the search string or characters>
-find and replace _Global_1 (no dialog)
-goto record first

so whoever or whever the scrip is run, it happens then.

BTW, I was able to get the escape character to work

Guy




"Remi-Noel Menegaux" <rnmenegaux AT free.fr> wrote in message
news:4807c60b$0$30612$426a74cc@news.free.fr...
> Fine, but how exactly do you put by script a " into a global ?
> Remember also that 'globals' are 'local' ie attached to each user on a
> 'shared' DB.
> Remi-Noel
>
> "Guy" <guy@guym.com> a écrit dans le message de
> news:uv-dnbIaA9rvO5rVnZ2dnUVZ_tqtnZ2d@earthlink.com...
>> Easier than that (but you got me thiinking)
>>
>> at script run time, insert " into a global field, then reference the
>> global in the replace step.
>>
>> BTW, escape char does nit work.
>>
>> Guy
>>
>>
>> "Remi-Noel Menegaux" <rnmenegaux AT free.fr> wrote in message
>> news:48051122$0$23028$426a74cc@news.free.fr...
>>> You may have a special text field put in a one record only table, in
>>> which you put by hand, once, a character copied-pasted from Word. Then
>>> you include that field instead of the """.
>>> Remi-Noel
>>>
>>> "Guy" <guy@guym.com> a écrit dans le message de
>>> news:EOidncfUge4rkZjVnZ2dnUVZ_jadnZ2d@earthlink.com...
>>>>I need to replace all quotes with a null.
>>>>
>>>> This is necessary when importing a tab delimited file that has a few
>>>> comma's which ar econverted to a quoted field.
>>>>
>>>> e.g. COPS, Inc. is changed to "COPS, Inc."
>>>>
>>>> In the replace dialog for a script step, I cannot enter the " as the
>>>> string. Help.
>>>>
>>>> Guy
>>>>
>>>> --
>>>> -------------------------------------------------
>>>> Captain Guy
>>>> s/v Island Time (Beneteau 352#277)
>>>> AICW 845.5
>>>> 386-689-5088
>>>>
>>>
>>
>>
>

Report this message

#8: Re: How to insert quote into a variable

Posted on 2008-04-18 07:50:14 by Remi-Noel Menegaux

Thanks, it looks like an interesting method.
Remi-Noel

"Guy" <guy@guym.com> a écrit dans le message de
news:jNmdnUGP9vDtYprVnZ2dnUVZ_oKhnZ2d@earthlink.com...
> At run time (like called from an import script)
> -goto record first
> -go to layout whatever
> -insert text into field _Global_1; " <the search string or characters>
> -find and replace _Global_1 (no dialog)
> -goto record first
>
> so whoever or whever the scrip is run, it happens then.
>
> BTW, I was able to get the escape character to work
>
> Guy
>
>
>
>
> "Remi-Noel Menegaux" <rnmenegaux AT free.fr> wrote in message
> news:4807c60b$0$30612$426a74cc@news.free.fr...
>> Fine, but how exactly do you put by script a " into a global ?
>> Remember also that 'globals' are 'local' ie attached to each user on a
>> 'shared' DB.
>> Remi-Noel
>>
>> "Guy" <guy@guym.com> a écrit dans le message de
>> news:uv-dnbIaA9rvO5rVnZ2dnUVZ_tqtnZ2d@earthlink.com...
>>> Easier than that (but you got me thiinking)
>>>
>>> at script run time, insert " into a global field, then reference the
>>> global in the replace step.
>>>
>>> BTW, escape char does nit work.
>>>
>>> Guy
>>>
>>>
>>> "Remi-Noel Menegaux" <rnmenegaux AT free.fr> wrote in message
>>> news:48051122$0$23028$426a74cc@news.free.fr...
>>>> You may have a special text field put in a one record only table, in
>>>> which you put by hand, once, a character copied-pasted from Word. Then
>>>> you include that field instead of the """.
>>>> Remi-Noel
>>>>
>>>> "Guy" <guy@guym.com> a écrit dans le message de
>>>> news:EOidncfUge4rkZjVnZ2dnUVZ_jadnZ2d@earthlink.com...
>>>>>I need to replace all quotes with a null.
>>>>>
>>>>> This is necessary when importing a tab delimited file that has a few
>>>>> comma's which ar econverted to a quoted field.
>>>>>
>>>>> e.g. COPS, Inc. is changed to "COPS, Inc."
>>>>>
>>>>> In the replace dialog for a script step, I cannot enter the " as the
>>>>> string. Help.
>>>>>
>>>>> Guy
>>>>>
>>>>> --
>>>>> -------------------------------------------------
>>>>> Captain Guy
>>>>> s/v Island Time (Beneteau 352#277)
>>>>> AICW 845.5
>>>>> 386-689-5088
>>>>>
>>>>
>>>
>>>
>>
>
>

Report this message