Re: dbload is loading "?"
Sounds like you have a DOS file - as previously suggested, run the file
through dos2unix. If that doesn't work for you (i.e. you don't have it) you
can always:
awk 'BEGIN {RS="\\r"} {printf("%s\\n",$0)}' input.file > output.file
(the output file would be ready to load.)
----- Original Message -----
From: "Philipp Walderdorff" <ph.walderdorff@gmx.at>
To: <informix-list@iiug.org>
Sent: Friday, October 03, 2003 12:01 PM
Subject: Re: dbload is loading "?"
> I am using the very old version INFORMIX-SQL Version 2.10.00B 1984-1987
> on a RedHat LINUX 7.3 and RedHat 6.0
>
> The source-file (file.txt) was created by the austrian health-authority. I
> do not know, on whitch system they created it, but I suppose on
Windows-PC,
> because they use to write textfiles normaly in .doc extension. The file
was
> sent to me per email direct into my LINUX-PC.
>
>
>
> This line is loaded into table medikamente as following:
> 0000388 50ml 155 003M02AC5201
>
>
> PERFORM: Query Next Previous Add Update Remove Table Screen ...
> Searches the active database table. ** 1: medikamente table**
> pharma_nr [0000388]
> preistext [ ]
> menge [50 ]
> mengenart [ml]
> kp [155 ]
> kp_per_unit [3 ]
> atc [M02AC52]
> laufnr [1 ]
> staerke [? ]
> starkdim [ ]
> f [ ]
> kommentar [ ]
>
>
> The column "staerke" had loaded "?"
>
> Why?
>
> he next row:
> 0000922 25St 225 009N05BA04000,01
> 2
> is loaded as the following:
> PERFORM: Query Next Previous Add Update Remove Table Screen ...
> Shows the next row in the Current List. ** 1: medikamente table**
> pharma_nr [0000922]
> preistext [ ]
> menge [25 ]
> mengenart [St]
> kp [225 ]
> kp_per_unit [9 ]
> atc [N05BA04]
> laufnr [0 ]
> staerke [0,01 ]
> starkdim [ ]
> f [2?]
> kommentar [ ]
>
> The column "f" has got a ?
>
> Why? Isn't it the Marker of the end of the line in the source-file?
>
> This "?" is coursing problems with the software, saying unnunderstandable
> signe. So this "?" is not a "?" It must be some other sign. At another
time
> I could read this sign as "^M", but now I cannot manage to reconstruct,
how
> I did that.
> I hope, you have enough information to get an idea, what the problem could
> be.
> Thanks for help.
> Philipp
>
>
sending to informix-list