Re: [base] raw data files with hyb name in column headings
excellent, thanks, will try that. Nicklas Nordborg writes: > Bob MacCallum wrote: > > Hi, > > > > I'm trying to import some ChipSkipper data into BASE2.6. While configuring > > the raw data importer I see that the files all have different column > > headings, > > incorporating the hybridisation name e.g. for GS_Flags column: > > > > H_CLQ50 11_control 9/GS_Flags > > H_CLQ50 4_Control 2/GS_Flags > > H_PbICLQ50 7_PbI 5/GS_Flags > > H_PbICLQ50 14_PbI 12/GS_Flags > > > > It looks like I might have two options: > > > > 1. preprocess the raw data files with a Perl script to remove the hyb info > >from the column headings > > > > 2. configure the importer to use column numbers rather than names, e.g. > > \12\ > >but I don't know if this works in BASE2. > > Yes, it should work. > > There is also a third option. You can use regular expressions in the > column mappings. I think it should be possible to map a column something > like this: > > \.*GS_Flags\ > > > /Nicklas > > - > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ > ___ > The BASE general discussion mailing list > basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > [EMAIL PROTECTED] -- Bob MacCallum | VectorBase Developer | Kafatos/Christophides Groups | Division of Cell and Molecular Biology | Imperial College London | Phone +442075941945 | Email [EMAIL PROTECTED] - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
Re: [base] raw data files with hyb name in column headings
Bob MacCallum wrote: > Hi, > > I'm trying to import some ChipSkipper data into BASE2.6. While configuring > the raw data importer I see that the files all have different column headings, > incorporating the hybridisation name e.g. for GS_Flags column: > > H_CLQ50 11_control 9/GS_Flags > H_CLQ50 4_Control 2/GS_Flags > H_PbICLQ50 7_PbI 5/GS_Flags > H_PbICLQ50 14_PbI 12/GS_Flags > > It looks like I might have two options: > > 1. preprocess the raw data files with a Perl script to remove the hyb info >from the column headings > > 2. configure the importer to use column numbers rather than names, e.g. \12\ >but I don't know if this works in BASE2. Yes, it should work. There is also a third option. You can use regular expressions in the column mappings. I think it should be possible to map a column something like this: \.*GS_Flags\ /Nicklas - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
[base] raw data files with hyb name in column headings
Hi, I'm trying to import some ChipSkipper data into BASE2.6. While configuring the raw data importer I see that the files all have different column headings, incorporating the hybridisation name e.g. for GS_Flags column: H_CLQ50 11_control 9/GS_Flags H_CLQ50 4_Control 2/GS_Flags H_PbICLQ50 7_PbI 5/GS_Flags H_PbICLQ50 14_PbI 12/GS_Flags It looks like I might have two options: 1. preprocess the raw data files with a Perl script to remove the hyb info from the column headings 2. configure the importer to use column numbers rather than names, e.g. \12\ but I don't know if this works in BASE2. Has anyone else run into this type of problem? cheers, Bob. -- Bob MacCallum | VectorBase Developer | Kafatos/Christophides Groups | Division of Cell and Molecular Biology | Imperial College London | Phone +442075941945 | Email [EMAIL PROTECTED] - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]