Search Results

Tried setting the line size using myriad commands. However I keep getting the error message 'linesize option not a valid number' which is really weird since I am giving 400 which is definitely a...

Thanks for that Carlo. I'm however stuck because echo $sqloutput doesn't return anything except a '>'

Furthermore, I can't seem to get out of that prompt

Hello all

I have a query (SQL) that returns a rather long field from an Oracle database. The field in question is defined on 400 characters but all these 400 cannot be displayed by the echo...

Thanks a lot in2nix4life:b::)
This works the best for me since ls -l on its own returns too much info. where as I want just the file name.

The find command appends unwanted info. as well.

I...

Hello

I've got a certain no. of files in a directory whose names I'm reading and redirecting into a temporary text file using the command below:

ls -l | grep ^- | awk '{print $9}'However,...

Again... works like a charm.. Thanks a lot

That was exactly it. With just the semicolon the command failed and I thus though maybe Corona had left the semi colon after awk inadvertently.

Now that I've put the semicolon within quotes, it...

Hello Corona

Thank you for your reply. Here are more details:

Command used:

awk -F '{ for(N=1; N<=NF; N++) sub(/^[ \r\n\t]*$/, "", $N); } 1' OFS=";" file1 > file2
Output:...

Hello Corona

Your command does not seem to work. I admit I'm pretty new to UNIX so I copied it as it is only substituting input file and output file.

Is there anything else that needs to be...

Here is the content of the file:

AAA;1; ; ; ; ;XXX
BBB;2; ; ; ; ;YYY Code tags for code, please.

Did you mean the command?
sed -i 's/;[[:space:]]*;/;;/g' <filename>
If so it didn't work? FYI. originally i was depicting the space with literally a space or ' ' and so the command took the form:...

Greetings all

I have a delimited text file (the delimiter is ';') where certain fields consist of many blanks e.g. ; ; and ; ;

Before I separate the data I need to eliminate these blanks...

Thanks guys.
The loop definition by Scrutinizer and the mv command by Thobias together helped.

Much appreciated

Hello

I have a folder with around a 100 files. Some of these files have an extension of .DAT.csv and the others are simply .DAT
I need to rename all those files ending in .DAT.csv to .DAT. I...