Here’s the deal.
I’m an AppleScript newbie. Have played around with the “elementary” stuff but I have found a useful purpose for a script and don’t grasp everything involved in it just yet.
Here is the situation. I receive a monthly report every month. If I export it from excel, the data is formatted like this:
23002,$350.47 ,$361.27
18th Street Market,
18th St,
N Little Rock AR 72554,
,
50366,$0.00 ,$5.40
88 Lone Elm Inc,
11920 Old 4388 Rd,
Rawdy AR 75042,
,
26887,"$1,091.15 “,”$1,528.78 "
Alabama State Prod,
c/o June Hersey,
P O Box 58855,
Dothan AR 36822,
,
This is the way I want it formatted:
23002,$350.47 ,$361.27,18th Street Market,18th St,N Little Rock, AR, 72554,
50366,$0.00 ,$5.40,88 Lone Elm Inc,11920 Old 4388 Rd,Rawdy, AR,75042,
26887,"$1,091.15 “,”$1,528.78,Alabama State Prod,c/o June Hersey,P O Box 58855,Dothan, AR, 36822,
Is this possible to do in Applescript or should I look at something else?
Thanks for your help.