Information générale
Titre:
Trailing blanks removed
HI,
I have to insert values from a text file that has text values with 1 to several trailling blanks. When I imported the file into Access, It removed the trailling blanks. So, i made a procedure that replaced the blanks by '|'. Then, in pl/sql, I used the folowing command :
T1 := REPLACE(t."Name_1", '|' ,CHR(32));
INSERT INTO TMP_TO_CRR_ADJUST_CUSTNUM VALUES (T1, t."Name_2", TO_NUMBER(t."New_NUM"));
The problem is that the trailing blanks are removed and I NEED THEM. I even used translate in place of REPLACE with the same result.
Is there another way to proceed,
Thank you very much,
Christian Cote
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement