removing space

Shell Programming and Scripting
1

US76132M1027|NASDAQ Capital Market|NASDAQ Capital

Hi I want to remove the leading space ,i have a file full of lines with this space pls help me

2

I cannot tell from your sample, but this removes a leading space on each line of a file

sed '/^ //' file > newfile
3

Hi
It is throwing an error Unrecognized command: /^ //.
Otherwise is there any option in ISQL to control the output formatting.

I am getting lines with leading spaces as a result od my ISQL query

4

use this:

sed 's/^ //g' <inputfile >outputfile

or

sed '/^ /d' <inputfile >outputfile

5

Hi
I tried this time i had no errors but not worked as well.
Please help me out

6

Try this:

sed -e 's/^[ \t]*//' inputfile

If it does not work, please let us know your system configuration
uname -a
or dump out the man page for sed

7

doing it in SQL: use the trim() function or equivalent, if there is. also look for rtrim(), ltrim() etc