How to insert quote into a variable

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

Re: How to insert quote into a variable

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" 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
>

Re: How to insert quote into a variable

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

Re: How to insert quote into a variable

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" 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" 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
>>
>

Re: How to insert quote into a variable

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" 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" 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

Re: How to insert quote into a variable

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" 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" 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" 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
>>>
>>
>
>

Re: How to insert quote into a variable

At run time (like called from an import script)
-goto record first
-go to layout whatever
-insert text into field _Global_1; "
-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" 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" 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" 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" 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
>>>>
>>>
>>
>>
>

Re: How to insert quote into a variable

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

"Guy" 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; "
> -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" 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" 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" 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" 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
>>>>>
>>>>
>>>
>>>
>>
>
>