StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1123508
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-07-14T04:59:50.673
FavoriteCount
0
LastActivityDate
2009-07-17T11:41:33.540
LastEditDate
2009-07-17T11:41:33.540
LastEditorUserId
432987
OwnerUserId
432987
ParentId
1046646
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You don't need to create a file before opening it for access. You can just do <pre><code>set theFile to (theFolder & "thefile.txt")as string set openFile to open for access theFile with write permission </code></pre> Of course if the file exists it will overwrite it. You could use <pre><code>set thefile to choose file name with prompt "name the output file" </code></pre> 'choose file name' returns a path without creating a file, and it asks the user if they want to overwrite if the file exists. You can also use 'return' to put a line break in like so, it makes the code a bit neater: <pre><code>write fileName & return to openFile </code></pre> <hr> Of course if you want a simple and more elegant way of doing it, the command is where you need to be. <pre><code>ls>thefile.txt </code></pre> In this example the '>' writes the output from the ls (list directory) command to a file. You can run this from within an applescript <pre><code>set thePosixDrectory to posix path of file thedirectory of app "Finder" set theposixResults to posix path of file theresultfile of app "Finder" do shell script ("ls \"" & thePosixDrectory & "\">\"" & theposixResults & "\"")as string </code></pre> the posix path stuff is to turn applescript style <code>directory:paths:to your:files</code> into unix style <code>/directory/paths/to\ your/files</code>. Note that the shell script that actually gets run will look like: <pre><code>ls "/some/directory/path/">"/some/file/path.txt" </code></pre> the quotes are there to stop spaces or other funky characters from confusing the shell script. To stop the quotes from being read as quotes in the applescript the backslash was used to "escape" them. You can also use single quotes, for more readable code thusly: do shell script ("ls '" & thePosixDrectory & "'>'" & theposixResults & "'")as string which will appear in the shell like <pre><code> ls '/some/directory/path/'>'/some/file/path.txt' </code></pre> HTH
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMac user needs some folder help with applescript. SFW
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USstib
UserOwnerUserId
1. USstib
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.