Import a Text File into 1 Field

3 messages Options
Embed this post
Permalink
coolcat

Import a Text File into 1 Field

Reply Threaded More More options
Print post
Permalink
Hi folks,

I would like to be able to import a text file (varied text with  
returns) into 1 record and place the contents into 1 text field.  
Right now it creates separate records for each return char.

Without altering the text file - how can I get all contents into 1  
text field in 1 records?

I imagine that I can import into a temp file - creating many records  
then loop through the file and copy each record into the destination  
on the main file....

Anything easier?


Thanks,
[hidden email]





_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Ralph Learmont

Re: Import a Text File into 1 Field

Reply Threaded More More options
Print post
Permalink
Getting a text file into a field can use the "Import from a folder  
method"...   Nominate a folder for the purpose.  Within it include  
your single text file, nothing else.  From Filemaker, use the "Import  
Records" script step, nominate "Text-files", then map the source file  
into your target field.

Hope that helps.

Regards
Ralph Learmont


On 04/11/2009, at 8:03 AM, [hidden email] wrote:

> Hi folks,
>
> I would like to be able to import a text file (varied text with
> returns) into 1 record and place the contents into 1 text field.
> Right now it creates separate records for each return char.
>
> Without altering the text file - how can I get all contents into 1
> text field in 1 records?
>
> I imagine that I can import into a temp file - creating many records
> then loop through the file and copy each record into the destination
> on the main file....
>
> Anything easier?
>
>
> Thanks,
> [hidden email]
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
coolcat

Re: Import a Text File into 1 Field

Reply Threaded More More options
Print post
Permalink

On Nov 3, 2009, at 7:28 PM, Ralph Learmont wrote:

> Getting a text file into a field can use the "Import from a folder  
> method"...   Nominate a folder for the purpose.  Within it include  
> your single text file, nothing else.  From Filemaker, use the  
> "Import Records" script step, nominate "Text-files", then map the  
> source file into your target field.

worked like a charm - thanks



>
> Hope that helps.
>
> Regards
> Ralph Learmont
>
>
> On 04/11/2009, at 8:03 AM, [hidden email] wrote:
>
>> Hi folks,
>>
>> I would like to be able to import a text file (varied text with
>> returns) into 1 record and place the contents into 1 text field.
>> Right now it creates separate records for each return char.
>>
>> Without altering the text file - how can I get all contents into 1
>> text field in 1 records?
>>
>> I imagine that I can import into a temp file - creating many records
>> then loop through the file and copy each record into the destination
>> on the main file....
>>
>> Anything easier?
>>
>>
>> Thanks,
>> [hidden email]
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au



Thanks,
[hidden email]





_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au