multiple field separators in script

[#1]

I have the following issue:

My input file has two record separators, fields 1 to n are separated by '&', and n to last are separated by tab. Is there an option to easily load the entire table in one load statement?

regards,

Hellmar

[hectorgarcia]

hellmar can you post an example please about how looks your original data ?

Hector

[#3]

like this:

(see attachment)

[rwunderlich]

You could load it using tab as a delim. All the & delimited fields would wind up in the first field. Parse those in a preceeding load using subfield(F1, '&',n).

LOAD
 subfield(F1,1) as netmindsid,
 subfield(F1,2) as ext_ref,
 etc...
;
LOAD
 [netmindsid&ext_ref&aid_seq&atyp_seq&aid1&aid2&aid3&aid4&aid5&atyp1&atyp2&atyp3&atyp4&atyp5&starttime&s_viewtime&s_depth&aid_last&atyp_last] as F1,
 Sessions,
 Clicks,
 StartClicks,
 EndClicks,
 ViewTime,
 AvgViewTimePerClick,
 AvgViewTimePerSession,
 AvgClicksPerSession,
 SessionClicks,
 SessionViewTime,
 SessionAvgViewTimePerClick,
 SessionAvgViewTimePerSession,
 SessionAvgClicksPerSession
FROM sample.txt (ansi, txt, delimiter is '\t', embedded labels, msq);

-Rob