Can I skip first 2 rows in my csv file while loading data from csvfile to disk using .Q.fsRegardsShiv
X-Mailer: Apple Mail (2.935.3)On 27.05.2009, at 16:20, Siva Gudavalli wrote:>> Can I skip first 2 rows in my csv file while loading data from csv> file to disk using .Q.fs>> Regards> Shivthe full right argument to 0: can be (filename; offsetintothefile; bytestoread)see:https://code.kx.com/trac/wiki/QforMortals2/i\_o#Parsing-File-Recordsso you can roll your own solution
When I run it without .Q.fs it is working fine, but not with it! I am not able to use it along with .Q.fs. How this offsetintothefilein .Q.fs works.>From wiki I learnt that .Q.fs loops over a file and grabs convenientsized lumps of complete records from my very big csv file and load iton disk. So will it offset into the data in memory or will it offsetinto the data in file?RegardsShivOn May 27, 7:35?pm, Simon Garland <si…> wrote:> On 27.05.2009, at 16:20, Siva Gudavalli wrote:>>>> > Can I skip first 2 rows in my csv file while loading data from csv> > file to disk using .Q.fs>> > Regards> > Shiv>> the full right argument to 0: can be (filename; offsetintothefile; ?> bytestoread)>> see:https://code.kx.com/trac/wiki/QforMortals2/i_o#Parsing-File-Records>> so you can roll your own solution</si…>
X-Mailer: Apple Mail (2.935.3)the offset is a parameter to 0:/1: - 1: is the primitive used within .Q.fs (which is a utility function)if you want functionality not provided by .Q.fs you’ll have to modify it yourselfthe 1: call in .Q.fs is reading a rolling 131000 window over the disk datait’s using 1: to be able to work out where the line-ends (“\n”) areOn 28.05.2009, at 11:09, Siva Gudavalli wrote:>> When I run it without .Q.fs it is working fine, but not with it!>> I am not able to use it along with .Q.fs. How this offsetintothefile> in .Q.fs works.>> From wiki I learnt that .Q.fs loops over a file and grabs convenient> sized lumps of complete records from my very big csv file and load it> on disk. So will it offset into the data in memory or will it offset> into the data in file?>> Regards> Shiv>>> On May 27, 7:35 pm, Simon Garland <si…> wrote:>> On 27.05.2009, at 16:20, Siva Gudavalli wrote:>>>>>>>>> Can I skip first 2 rows in my csv file while loading data from csv>>> file to disk using .Q.fs>>>>> Regards>>> Shiv>>>> the full right argument to 0: can be (filename; offsetintothefile;>> bytestoread)>>>> see:https://code.kx.com/trac/wiki/QforMortals2/i_o#Parsing-File- >> Records>>>> so you can roll your own solution</si…>
i am looking into q.k for the utility function ur talking about!let me see if i can skip rows (using offsetinthefile flag) by creatinga new function similar to .Q.fsthanks a lot for help..On May 28, 2:20?pm, Simon Garland <simon.garl…> wrote:> the offset is a parameter to 0:/1: - 1: is the primitive used ?> within .Q.fs (which is a utility function)> if you want functionality not provided by .Q.fs you’ll have to modify ?> it yourself>> the 1: call in .Q.fs is reading a rolling 131000 window over the disk ?> data> it’s using 1: to be able to work out where the line-ends (“\n”) are>> On 28.05.2009, at 11:09, Siva Gudavalli wrote:>>>>>> > When I run it without .Q.fs it is working fine, but not with it!>> > I am not able to use it along with .Q.fs. ?How this offsetintothefile> > in .Q.fs works.>> > From wiki I learnt that .Q.fs loops over a file and grabs convenient> > sized lumps of complete records from my very big csv file and load it> > on disk. So will it offset into the data in memory or will it offset> > into the data in file?>> > Regards> > Shiv>> > On May 27, 7:35 pm, Simon Garland <si…> wrote:> >> On 27.05.2009, at 16:20, Siva Gudavalli wrote:>> >>> Can I skip first 2 rows in my csv file while loading data from csv> >>> file to disk using .Q.fs>> >>> Regards> >>> Shiv>> >> the full right argument to 0: can be (filename; offsetintothefile;> >> bytestoread)>> >> see:https://code.kx.com/trac/wiki/QforMortals2/i_o#Parsing-File-> >> Records>> >> so you can roll your own solution- Hide quoted text ->> - Show quoted text -</si…></simon.garl…>
X-Mailer: Apple Mail (2.935.3).Q.fs is the utility function I was talking about which uses 1:if you want other - similar - behaviour you’ll have to write your ownOn 28.05.2009, at 14:18, Siva Gudavalli wrote:>> i am looking into q.k for the utility function ur talking about!> let me see if i can skip rows (using offsetinthefile flag) by creating> a new function similar to .Q.fs>> thanks a lot for help..>> On May 28, 2:20 pm, Simon Garland <simon.garl…> wrote:>> the offset is a parameter to 0:/1: - 1: is the primitive used>> within .Q.fs (which is a utility function)>> if you want functionality not provided by .Q.fs you’ll have to modify>> it yourself>>>> the 1: call in .Q.fs is reading a rolling 131000 window over the disk>> data>> it’s using 1: to be able to work out where the line-ends (“\n”) are>>>> On 28.05.2009, at 11:09, Siva Gudavalli wrote:>>>>>>>>>>>>> When I run it without .Q.fs it is working fine, but not with it!>>>>> I am not able to use it along with .Q.fs. How this >>> offsetintothefile>>> in .Q.fs works.>>>>> From wiki I learnt that .Q.fs loops over a file and grabs convenient>>> sized lumps of complete records from my very big csv file and load >>> it>>> on disk. So will it offset into the data in memory or will it offset>>> into the data in file?>>>>> Regards>>> Shiv>>>>> On May 27, 7:35 pm, Simon Garland <si…> wrote:>>>> On 27.05.2009, at 16:20, Siva Gudavalli wrote:>>>>>>> Can I skip first 2 rows in my csv file while loading data from csv>>>>> file to disk using .Q.fs>>>>>>> Regards>>>>> Shiv>>>>>> the full right argument to 0: can be (filename; offsetintothefile;>>>> bytestoread)>>>>>> see:https://code.kx.com/trac/wiki/QforMortals2/i_o#Parsing-File->>>> Records>>>>>> so you can roll your own solution</si…></simon.garl…>