Importing CVS file contents to 1 field

[fed]

I am wondering if there is a way to import the contents of a CVS file into 1 field, much in the same way you can import the contents of a txt file into a field.

Thank you,

Fed

[Lee Smith]

I’m wondering why? Usually it’s the opposite. 

[fed]

Its complicated. Has to do with billing verification and logs. 

Can it be done? 

[Lee Smith]

Strip all of the delimiters out of the .cvs file using a text editor?

Without seeing the text, it is hard for me to see what you are doing.

[doughemi]

Open the .csv as a new FM file name Utility. Create a calculation field in Utility named Join and make the calc

f1 & "," & f2 & "," & ... & fn// where n is the number of fields in the converted .csv  .

Relate  the utility file to your main table by an X relationship.

Set your target field (by script or auto-enter) to List(Utility::Join). Note that you cannot make your target field a calc field.

 

EDIT:  If it were me, I'd parse the data in the Utility table and import just the necessary fields into my main table.

Edited April 2, 2016 by doughemi

[comment]

20 hours ago, fed said:

much in the same way you can import the contents of a txt file into a field.

How exactly can you do that?

--
P.S. If you really need to insert the contents of a text file into a text field (and I would also ask why this is necessary), then it I believe it would best to use either a plugin or an OS-level script.

Edited April 2, 2016 by comment

[fed]

I'll just copy and paste. I've been doing that for 4 years now.  But the number of files have been increasing and I'm up to 20 now. It takes a bit of effort and concentration to get it right.

Thanks anyhow. 

[comment]

2 hours ago, fed said:

I'll just copy and paste. I've been doing that for 4 years now.  But the number of files have been increasing and I'm up to 20 now. It takes a bit of effort and concentration to get it right.

Pardon my being blunt, but this is ridiculous. If you want to automate the process, then do so. Solving this using AppleScript (seeing you're on OS X) or a plugin such as Base Elements (free) is trivial. If you want to give up, then give up and don't whine about it.

[fed]

I'm not whining.  I was just stating that I was giving up on. FMP solution, rather than just abandoning the thread without notice.  I figured that was the right way to proceed. Sorry if that did not come through.

Thanks for the suggestions, I'll try applescripts and check out Base Elements. 

Edited April 3, 2016 by fed