sqlbi
SSC Eights!
Points: 901
More actions
September 24, 2010 at 1:42 pm
#142857
Im importing source file which is pipe delimited, after importing it i see for of the column has data along with Pipe symbol
Like this
3000|
200|
how to eliminate these before i import into my table?
Thanks
September 24, 2010 at 2:49 pm
#1227252
got solution. i added one more column in the flat source this eliminated the pipe.. now everything is importing without pipe at end
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply