How to delete <TAB> from text field

bagindorbagindor Member Posts: 2
hi, im importing data from .txt /.csv using dataport

text1{
text2
text3

etc



when i import it to text field it looks like this: ' text2' , ' text3' .how to delete this tab?

I set <<"><TAB>> in FieldStartDelimeter in dataport settings, didnt work; <TAB> too.

i ve tried functions

Table.Text:=DELCHR(Table.Text,'<>=');

Table.Text:=DELCHR(Table.Text, '<>=', '/t');

Table.Text:=DELCHR(Table.Text,'<>=', '<TAB>');

Table.Text:=DELCHR(Table.Text,'<>=', ' ');

Table.Text:=DELCHR(Table.Text,'<>=', ' ');

but nothing works :(

Comments

  • krikikriki Member, Moderator Posts: 9,112
    variable : TheTab as text[1];
    TheTab := 'x';
    TheTab[1] := 9; //TAB
    Table.Text:=DELCHR(Table.Text,'<>=',TheTab);
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.