I want to set 10 set of strings into a variable where:
removing all spaces within each string
change the delimiter from "|" to ","
Currently, I've the below script like this:
Today I've got an error 0403-029 There is not enough memory available now. while running the tr -d ' ' (delete space characters) so I suspect either I've used too many pipelines or the tr command (translate or delete) itself may eat up the memory.
I'd like to know if there is a way to remove all spaces within each string within the command:
So as to use less pipeline commands thus reduce the memory consumption
Thanks in advance
Paul
Last edited by rbatte1; 05-26-2015 at 01:19 PM..
Reason: Converted numeric/text list to LIST=1 tags and FONT formatting to ICODE tags - added CODE tags too
Hi All,
file_1.txt contains
aaa bbbb hhhh
vvvvv mmmmm iiiii
What i want is to search for the first coloumn of each line using awk.i.e as below:
awk '/aaa/ {printf(<>)}' file_1.txt
The print part (<>) should contain all the values(or coloumns ) in the particular line(here it... (8 Replies)
I want a user to be able to paste in a string like "01 3F 20 1F" and have the script reformat it to "013F201F" to pass it on to the next step.
I was trying to figure it out with awk but wasnt working well.
Never mind, found answer. did not know about tr :) (7 Replies)
Hello All,
I am trying to remove all tabspaces and all blankspaces from my file using sed & awk, but not getting proper code. Please help me out.
My file is like this (<b> means one blank space, <t> means one tab space)-
$ cat file
NARESH<b><b><b>KUMAR<t><t>PRADHAN... (3 Replies)
Hello all,
I want to list the file contents of the directory and number them. I am using la and awk to do it now,
#ls |awk '{print NR "." $1}'
1. alpha
2. beta
3. gamma
The problem I have is that some files might also have some spaces in the filenames.
#ls
alpha beta gamma ... (7 Replies)
How to print the strings within a line between two spaces .
<ns1:providerErrorCode>141</ns1:providerErrorCode> <ns1:providerErrorText>business_rule_exception-Server.404:Cannot proceed because the subscriber with phone number is either suspended or the account has an unpaid... (8 Replies)
When I use:
find . -ls | awk 'BEGIN { OFS = ";"} {print $1,$2,$11}'I get a nice result, yet the files with spaces in it show only the first word and all other characters after the blank space are not printed.
e.g. 'file with a blank space'
is printed
file
'file_with a blank space'
is... (7 Replies)
I have a one-line command,
lsusb | awk '{ $1=""; $2=""; $3=""; $4=""; $5=""; $6=""; print $0 }'
It works, and gives the results I expect, I was just wondering if I am missing some easier way to nullify the first 6 column variables?
Something like,
lsusb | awk '{ $(1-6)=""; print $0 }'
But... (10 Replies)
Hi,
I'm using awk to print columns from a tab delimited text file:
awk '{print " "$2" "$3" $6"}' file
The problem I have is column 6 contains text with spaces etc which means awk only prints the first word.
How can I tell awk to print the whole column content as column 6?
Thanks, (10 Replies)
Discussion started by: keenboy100
10 Replies
LEARN ABOUT DEBIAN
mdb-tables
MDBTools(1)MDBTools(1)NAME
mdb-tables - Get listing of tables in an MDB database
SYNOPSIS
mdb-tables [-S] [-1 | -d delimiter] database
DESCRIPTION
mdb-tables is a utility program distributed with MDB Tools.
It produces a list of tables contained within an MDB database in a format suitable for use in shell scripts.
OPTIONS -S Show system tables. System tables are generally those beginning with 'MSys'
-1 specifies that the tables should be listed 1 per line.
-d delimiter
specifies an alternative delimiter. If no delimiter is specified, table names will be delimited by a tab character, or by newline if
the -1 option was specified.
NOTES ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
HISTORY
mdb-tables first appeared in MDB Tools 0.3.
SEE ALSO gmdb2(1)mdb-export(1)mdb-hexdump(1)mdb-prop(1)mdb-sql(1)mdb-ver(1)mdb-array(1)mdb-header(1)mdb-parsecsv(1)mdb-schema(1)AUTHORS
The mdb-tables utility was written by Brian Bruns.
BUGS
Access allows for tables to have spaces embeded in the table name.
You must specify a delimiter (-d) if you intend on piping the output of mdb-tables to a program such as awk or cut.
0.7 13 July 2013 MDBTools(1)