Re: A "Load from" question.

Alice Lam · 1998-10-02T10:17:23Z

Hi, You can also edit the datafile to insert a blank space between the two consecutive pipes and to insert a blank space to the pipe at the beginning of the line. This will work. In vi or sed, use: g/^|/s// |/;g/||/s/| |/g Suhas Tembe wrote: Hi Guys, Let me tell you what exactly I am looking for : I have a temp table "temp_table" with say 3 columns as ; col1 char(2); col2 char(2); col3 char(2); I also have a delimited (|) flat file with 3 columns & I have to load data from the flat file into this "temp_table". The flat file looks like this : ab||cd --- line 1 |ab|cd --- line 2 ab|cd|| --- line 3 I load data into the "temp_table" as follows : load from "flat_file.txt" insert into temp_table; Now, when I do this, row # 1 in the table would…

Posted in 1998

Topics: General Discussion

Alice Lam — Fri, 02 Oct 1998 18:17:23 +0800 — source: Informix-list mailing list archive (1991-1998)

<HTML> Hi, You can also edit the datafile to insert a blank space between the two consecutive pipes and to insert a blank space to the pipe at the beginning of the line. This will work. In vi or sed, use: g/^|/s// |/;g/||/s/| |/g   Suhas Tembe wrote: <BLOCKQUOTE TYPE=CITE>Hi Guys, Let me tell you what exactly I am looking for : I have a temp table "temp_table" with say 3 columns as ; col1  char(2); col2  char(2); col3  char(2); I also have a delimited (|) flat file with 3 columns & I have to load data from the flat file into this "temp_table". The flat file looks like this : ab||cd       ---  line 1 |ab|cd       ---  line 2 ab|cd||      ---  line 3 I load data into the "temp_table" as follows : load from "flat_file.txt" insert into temp_table; Now, when I do this, row # 1 in the table would like : col1 = ab col2 = null col3 = cd Similarly, row # 2 & row # 3 as : col1 = null col2 = ab col3 = cd col1 = ab col2 = cd col3 = null As you can see, a "null" is inserted into the column(s) if there is no data. (Note : There is no space between the pipes in the flat file). My question is, what would I have to do if I wanted "spaces" & not "nulls" to be inserted into the table. ( I don't want to give an "update" statement for every column in the table). Any help is appreciated. Thanks in advance. Suhas -------------------------------------------------------- Name  : Suhas Tembe E-mail: <stembe@arrowshirt.com> Date  : 09/28/98 Time  : 17:45:14 Place : Atlanta, Georgia. --------------------------------------------------------</BLOCKQUOTE>  </HTML>