Nice.
Why did I think that CFML used:
variable[1]
....but required quotes here:
variable["one"]
....Was that *ever* the case?
On Tue, Nov 25, 2008 at 1:05 PM, Peter Boughton <[EMAIL PROTECTED]> wrote:
> >How would some of you take this text file and parse it into a structure?
>
> I might do something like the code below.
>
> Specific points in comparison to other response:
> - Uses cfsavecontent not a multi-line cfset
> - Strips off unwanted stuff before looping, instead of cfif inside loop.
> - Does Positions[Name] instead of Positions["#Name#"]
> But also has other simplifications.
>
> (Ideally I'd use reMatch instead of reReplace, but this way will run on
> CF7.)
>
> ---
>
> <cfsavecontent variable="InputText">options (direct=true, errors=999999)
> load data
> into table raw_i
> append
> (record_id position(1:1) CHAR,
> process_mt position(2:3) CHAR,
> process_yr position(4:5) CHAR,
> *snip*
> summary_cd position(121:124) CHAR,
> file_date position(125:144) DATE "DD-MON-YYYY HH24:MI:SS",
> file_name position(*) CHAR TERMINATED BY X'0A'</cfsavecontent>
>
> <cfset InputText = ListRest(ListRest(InputText,'('),'(') />
>
> <cfset Positions = StructNew()>
>
> <cfloop index="CurRow" list="#InputText#" delimiters="#Chr(10)#">
> <cfset Name = ListFirst(CurRow,' ')/>
> <cfset Pos = rereplace(CurRow,'^.*position\(([^)]+)\).*$','\1')/>
>
> <cfset Positions[Name] = StructNew()/>
> <cfset Positions[Name].Start = ListFirst(Pos,':')/>
> <cfset Positions[Name].End = ListLast(Pos,':')/>
> </cfloop>
>
> ---
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315900
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
