Jump to content

ChuckL

Members
  • Content Count

    32
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ChuckL

  • Rank
    member
  1. Tominator, Thank you very much for the solution. I'll keep it in mind should I run into more difficulties.
  2. I've downloaded TextWrangler and it does the job just fine, Comment. Thanks very much.
  3. There is only a "return" between the last field of a record and the first field of the next. There is no need for a record "indicator". There are, for example, 5 fields in each record. The app that will be reading the data from this file will read the first 5 values and use them, then read the next 5, etc. This is not a database that I'm creating. It's just a text file for a machine to read data from.
  4. When you have "commas" between the fields (.csv file) it's a "comma-delimited" file. I need to have a "return" between the fields. Excel offers "tab-delimited", "comma-delimited", but no "return-delimited". MS Word offers about the same. My first idea was that I could open a .csv file with Word and then have Word replace the commas with a Return, but Word doesn't offer that. It can replace the commas with a "paragraph mark" but that doesn't come thru as a Return in Notepad on the computer that will be reading data out of this file. -thanks for the comment.
  5. I have an excel file that I need to convert to a "return-delimited" txt file. If I import the file into FM, is there a way to export it as a return-delimited file? (I tried to do it with MS Word, but it exports as "paragraph mark" instead of an actual "return", and the system that will be reading the subsequent txt file does not recognize Word's "paragraph mark" as a Return. Thanks much for any help.
  6. Couldn't find anything on this in searches. It seems like a simple task, but the way I'm thinking seems tedious. The task: I want to compare two lists of file names that should be identical (but aren't) to find out where the first difference occurs. I have table A with a field named "a". Ten thousand records with data (a file name) in field "a", alpha sorted. I have another table, B, with 10,000 records alpha sorted in field "b". The contents of these two tables should be identical. What's a simple way to compare record 1 in A with record 1 in B, etc., to find where they differ? Thanks again, guys.
  7. Thanks Fenton. Haven't had a chance to try that yet, but thanks very much for the info.
  8. Well... now I've got the question that HAD to follow... can I do this (change permissions) to a file on a different computer on the LAN? I dragged the file into Terminal and it gave me /Volumes/username/... Which means I have to already be connected via OS (I think). Is there a way to do it without having to manually connect? Thanks in advance, guys.
  9. You are correct, Fitch... the path starts /Users.. It works! Great! Thanks. And dragging the file into Terminal is a great trick. Thanks for the help. Thank you, Fenton, for your input also. It really is great to be able to come here and get answers to things that have stumped me. ...It's unfortunate that stumping me is not that hard to do... Thanks again.
  10. Thanks. I tried the shell script as shown but I get an error that there is no such file or directory. I suspect I'm not using the right syntax for my mac (OS 10.3.9). I'm saying do shell script "chmod 777 Chuck_HD:Users:chuck:Desktop:POSOE4batch.csv" Where Chuck_HD is the name of the hard drive. Should that work? Thanks a lot for the help.
  11. I'm trying to do almost the same thing... change the permissions of files and folders to 777, read/write access for owner, group, and everyone else. In terminal mode I have to say -R 777. In this shell script here I see only 775. If I just insert the 777 in place of the 775 will that work, or do I need the -R in there for something. Thanks a lot.
  12. Thanks Fenton. This is GREAT! I'm able to display the file fine now. However, I'm not clear on methods to delete that you mention. I created a table with a blank text field and tried exporting that field to the pdf file in order to delete the pdf file. FM didn't like it, said the file was of unknown type or corrupt. I'm working on trying the Temporary path method here in a minute.(I'm using FM Pro 8.5) What happens to files in the Temporary "Path"? Do they get deleted when the application closes, or computer shuts down or what? I think I prefer the concept of the Temporary Path, but at this point I don't understand the first and last lines of the script, and I like to understand what I put in my programs: -set tempPath to POSIX path of (path to temporary items) and -set cell"_gTempFolder" to tempPath Thanks very much... again!
  13. I have a simple table with 2 fields: "Invoice" and "image". "image" is a container field that holds a pdf file (not just a reference). Now that I have this table I can search for the "Invoice" record that holds the pdf file I want to view, select the "image" field, but I how do I get the pdf file to display on the screen. Originally I was storing only the reference in the "image" field, and I could display it by using Goto Field[select/perform]. Now that I'm actually putting the file in the container and not just a reference, it no longer displays. You guys showed how to do it with the reference, I'm hoping you can help me again. Thanks very much.
  14. Thank you both for your replies. Simple is usually better so I tried it (Go to Field[select...]) first and it works great. Thank you very much!
  15. I have a very simple database with records containing only a reference number and a container field with a pdf (reference) in it. I want to use a script to search the file for the reference number, then when it finds it display the pdf file. It looks to me like the Open URL step should open the pdf file, but either I'm reading it wrong or I'm just not getting the syntax for the file path correct (I'm on a mac). No matter what I do it always tries to open a web site. Now, I know that's what you should expect it to do, but the Filemaker help file gives an example of using it to open Notepad to open a text file. I could just have them double-click the container field to have the pdf pop up, but it would be a lot nicer if the pdf would just come up by itself. Seems like this should be a simple thing to do, but I'm not getting it. Thanks for any help.
×
×
  • Create New...

Important Information

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