12-16-2008
want to remove separators from file
Hi,
I have huge file,
head -1 filneame gives,
I just want to remove "##colsep##" from the file, and also want to count the no. of fileds present, as in
Output shld be in newfile as TRADE_KEY,TRADE_DATE
and total no. of fileds separated by these comma's
TRADE_KEY##colsep##TRADE_DATE_TIME##colsep##TRANS_TYPE_CD##colsep##ACCOUNT_KEY##colsep##LOCAL_CURREN CY_AMOUNT##colsep##LOCAL_CURRENCY_CD##colsep##ORIGINAL_CURRENCY_AMOUNT##colsep##ORIGINAL_CURRENCY_CD ##colsep##TRADE_QUANTITY##colsep##SETTLE_DATE_TIME##colsep##ORDER_ENTRY_DATE_TIME##colsep##PRODUCT_K EY##colsep##TRADE_PRICE##colsep##COMMISSION##colsep##IS_CORRECT##colsep##IS_CANCEL##colsep##CORRECTI ON_TYPE##colsep##EXCHANGE_CD##colsep##IS_SOLICITED##colsep##EXECUTING_REPRESENTATIVE_KEY##colsep##AG G_UNIT##colsep##CAPACITY##colsep##ORDER_ID##colsep##ORIGINAL_ORDER_ID##colsep##LOCAL_CURRENCY_NET_AM OUNT##colsep##ORIGINAL_CURRENCY_NET_AMOUNT##colsep##BUSINESS_DATE##colsep##COUNTERPARTY_ACCOUNT_KEY# #colsep##COUNTERPARTY_CATEGORY_CD##colsep##AVERAGE_PRICE_IND##colsep##SOURCE_SYSTEM_CD##colsep##DESK ##colsep##REGION##colsep##ACCRUED_INTEREST##colsep##CURRENCY_EXCHANGE_RATE##colsep##PRODUCT_TYPE_COD E##colsep##SEDOL_CODE##colsep##COUNTERPARTY_ACCOUNT_LABEL##colsep##TRADE_TYPE##colsep##PROP_ACCOUNT# #colsep##DERIVATIVE_TYPE##colsep##PORTFOLIO
Any script shell,awk,perl would do, please help as soon as possible,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have some huge files that are produced daily from a production system written in basic (really). The files are fixed width records, 512 bytes, with newline field separators, newlines if the field is null, and trailing newlines for null fields. The data in the fields can be any ascii... (0 Replies)
Discussion started by: vtischuk@yahoo.
0 Replies
2. Shell Programming and Scripting
I need to print the second field of a file, taking spaces, tab and = as field separators.
; for 16-bit app support
MAPI=1
CMC=1
CMCDLLNAME32=mapi32.dll
CMCDLLNAME=mapi.dll
MAPIX=1
MAPIXVER=1.0.0.1
OLEMessaging=1
asf=MPEGVideo
asx=MPEGVideo
ivf=MPEGVideo
m3u=MPEGVideo (2 Replies)
Discussion started by: PamPam
2 Replies
3. Shell Programming and Scripting
I have a file with content as shown below.
cat t2 :
100,100,"X",1234,"12A",,,"ab,c"
Comma is the field seperator, however string fields will be within double quotes and comma within double quotes should not be treated as field seperator.
I am trying to replace this field seperator to a... (7 Replies)
Discussion started by: mk1216
7 Replies
4. Shell Programming and Scripting
Hi, Gurus,
I have a file like
1 234, 345, 456
2 345, 456, 345
I want to use awk with multipe separator ( one is comma, another is space)print out $1, $3 which should be:
1, 345
2, 456
but I don't know how to put space as separator with another separator.
Thanks in advance (7 Replies)
Discussion started by: ken002
7 Replies
5. UNIX Desktop Questions & Answers
Hi Guys,
I have small dilemma which I could do with a little help solving . I currently have text HDD S.M.A.R.T report which I have pasted below:
smartctl 5.39 2008-10-24 22:33 (openSUSE RPM)
Copyright (C) 2002-8 by Bruce Allen, http://smartmontools.sourceforge.net
Device: COMPAQ... (2 Replies)
Discussion started by: bikerben
2 Replies
6. UNIX for Dummies Questions & Answers
I have files such as
n02-z30-dsr65-terr0.25-dc0.008-16x12drw-run1.cmd
I am wondering if it is possible to define two field separators "-" and "."
for these strings so that $7 is run1. (5 Replies)
Discussion started by: kristinu
5 Replies
7. UNIX for Advanced & Expert Users
vi uses dash and space as word separators. is there any way to exclude dash from word separators ?
This is required to work with the symbols generated by ctags exe. when symbol contain a "-" ,vi tags fails to locate that even though symbol is generated properly.
For example Symbol -... (3 Replies)
Discussion started by: cabhi
3 Replies
8. Shell Programming and Scripting
Hi,
I'm trying to parse a text file which uses commas as field separators. Fields are double quoted, and may themselves contain commas, like this:
"1","John Smith","London","123"
"2","Mary Robertson","Horsham, Sussex","456"
This causes problems for the following command
cut -d","... (7 Replies)
Discussion started by: sven44
7 Replies
9. Shell Programming and Scripting
I try to trim a FTP log using awk, but the escape sequences does not work the way I want it.
Input data Wed 3Oct10 21:48:00 - (002117) Sent file d:\ftp\home\tools\htmake.rar successfully (48.2 kB/sec - 40997 Bytes)
Wed 3Oct10 22:25:46 - (002118) Sent file d:\ftp\files\main\oct\camera1... (4 Replies)
Discussion started by: Jotne
4 Replies
10. Shell Programming and Scripting
How do I use multiple field separators in awk?
I know that if I use awk -F"", both a and b will be field separators. But what if I need two field separators that both are longer than one letter?
If I want the field separators to be "ab" and "cd", I will not be able to use awk -F"". The ... (2 Replies)
Discussion started by: locoroco
2 Replies
LEARN ABOUT DEBIAN
xowish
xowish(1) XOTcl Applications xowish(1)
__________________________________________________________________________________________________________________________________________________
NAME
xowish - Graphical shell containing object-oriented scripting language XOTcl
SYNOPSIS
xowish ?fileName arg arg ...?
_________________________________________________________________
DESCRIPTION
xowish is a shell-like application that reads XOTcl commands from its standard input or from a file and evaluates them. In addition to xot-
clsh it provides graphical user interface support for TK widgets.
XOTcl (XOTcl, pronounced exotickle) is an object-oriented scripting language based on MIT's OTcl. It is intended as a value added replace-
ment for OTcl.
Scripting languages, like Tcl, are designed for glueing components together, provide features like dynamic extensibility and dynamic typing
with automatic conversion, that make them well suited for rapid application development.
The basic object system of XOTcl is adopted from OTcl. The object system enables us to define objects, classes, and meta-classes. Classes
are special objects with the purpose of managing other objects. ``Managing'' means that a class controls the creation and destruction of
its instances and that it contains a repository of methods accessible for the instances. Every object may be enhanced with object-specific
methods. XOTcl supports single and multiple inheritance. All relationships in XOTcl, including class and superclass relationships, are com-
pletely dynamic and can be introspected. Through method chaining without explicit naming of the intended method, ambiguities in name reso-
lution of methods are avoided. This way a shadowed method can be ``mixed into'' the execution of the current method.
XOTcl combines the ideas of scripting and object-orientation in a way that preserves the benefits of both of them. It is equipped with sev-
eral new language functionalities that help building and managing complex systems. We added the following support:
Dynamic Object Aggregations, to provide dynamic aggregations through nested namespaces (objects).
Nested Classes, to reduce the interference of independently developed program structures.
Assertions, to reduce the interface and the reliability problems caused by dynamic typing and, therefore, to ease the combination of many
components.
Meta-data, to enhance self-documentation of objects and classes.
Per-object mixins, as a means to improve flexibility of mixin methods by giving an object access to several different supplemental classes,
which may be changed dynamically.
Per-class mixins, as a means to improve flexibility of mixin methods to a class, all instances of the class have access to the mixed in
methods like for multiple inheritance, but without the need of intersection classes.
Filters as a means of abstractions over method invocations to implement large program structures, like design patterns.
Dynamic Component Loading XOTcl integrates the Tcl package loading with architectrual support for integration with object-oriented con-
structs. Moreover, it provides tracking/tracing of component loading.
KEYWORDS
argument, interpreter, prompt, script file, shell
XOWish xowish(1)