Hi Gurus,
I have a text file on the application server which is tab-delimited. When reading it using OPEN DATASET it show # character where the tab is. Is there any command to remove the #? Its representing every tab it comes across as #. Is there a way to read the file so that every tab is recognised as a new field (column)?
In my case, if the next field after a tab is blank, The data is truncated into the next field in the internal table. It doesn't leave the field (column) blank in the internal table.
So please 2 things. How to remove the # character from the file read from the application server so that it treats it as a new field and how can i make sure that if a column is left blank in the file read, it is also left blank when reading it into the internal table instead of just truncating eveything into the next available field in the internal table.
Basically, I want the file to look the same like it is in the text file. Any field left blank in the text file should be left blank in the internal table and not just use the next available field and treat the next tab as a new column field instead of representing it it #.
example: if my text file is like this --
a bc def 12345 567890
a bc ghik 12345 567890
I want the file to be read into the internal table exactly like that.
But in my case, the file looks like this in the internal table --
a|#b|c#d|ef##|12345|#56789
I want it to look like this
a|bc|def| |12345|567890
I want the blank filed to be left blank too in the internal table and the # is not there too.
I cannot use GUI_UPLOAD because I'm readin
Thanks in Advance.