Jump to content

Importing CVS file contents to 1 field


fed
 Share

This topic is 2281 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 by doughemi
Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by fed
Link to comment
Share on other sites

This topic is 2281 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.