06-29-2009
insert pipes for existing and non-existing records
I have a source file like this,
L4058S462 34329094 F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690
L4058S462 34329094 F51020141FIRST CLEARING, LLC A/C 3432-9094
L4058S462 34329094 F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6
L4058S462 34329094 F51040141VALBO 81892 SWEDEN AIRMAIL 000000000
L4058S462 34329094 F51090141 0000 0
L4058T155 86374984 F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690
L4058T155 86374984 F51020141FIRST CLEARING, LLC A/C 8637-4984
L4058T155 86374984 F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN
L4058T155 86374984 F510401412801 MARKET STREET SAINT LOUIS MO 63103
Data in Red color is one data set,blue is other data set.
This is a multi-record data, means there are atmost 12 different records for each account(color), which can be identified by Bolded characters.
I need to put pipes in between all existing and non-existing records of particular account, like this,
L4058S462 34329094 F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690|L4058S462 34329094 F51020141FIRST CLEARING, LLC A/C 3432-9094|L4058S462 34329094 F51030141JOHAN HOLMQVIST YVSTANGSVAGEN 6|L4058S462 34329094 F51040141VALBO 81892 SWEDEN AIRMAIL 000000000|||||L4058S462 34329094 F51090141 0000 0|||
L4058T155 86374984 F51010141TK1070000443L4058T155 86374984 0232384840 4 182 5690|L4058T155 86374984 F51020141FIRST CLEARING, LLC A/C 8637-4984|L4058T155 86374984 F51030141CONFIDENTIAL & CONFIDENTIAL JT TEN|L4058T155 86374984 F510401412801 MARKET STREET SAINT LOUIS MO 63103||||||||
I need to put pipes for existing and non-existing records as well.
Thanks for the help.
Last edited by saravanamr; 06-29-2009 at 02:45 AM..
10 More Discussions You Might Find Interesting
1. Programming
I have an existing C module that already built libudf.so
Now I have modify this module to call a third party software function (which is new.so), and re build to target to libudf.so
I compiled that includes all header files of third party software.
Linking to new.so is also good,
But when... (0 Replies)
Discussion started by: baosoccer
0 Replies
2. Shell Programming and Scripting
Hi. Thanks for any help with this. I'm not new to programming but I am new to shell programming. I need a script that will
1. execute 'df -k' and return the volume names with specific text
2. surround each line of the above results in opening and closing xml tags
3. insert the results of step... (5 Replies)
Discussion started by: littlejon
5 Replies
3. Shell Programming and Scripting
I want to look into a folder to see if there are any folders within it. If there are, I need to check inside each folder to see if it contains a .pdf file
So
If /myserver/myfolder/
contains a folder AND that folder conatins a .pdf file
do X
Else
do Z
I may have multiple folders and... (4 Replies)
Discussion started by: crowman
4 Replies
4. Shell Programming and Scripting
Hi all,
I need to insert new text and change existing text in a file. For that I used the below line in the command line and got the expected output.
sed '$a\
hi...
' shell > shell1
But I face problem when using the same in script. It is throwing the error as,
sed: command garbled:... (4 Replies)
Discussion started by: iamgeethuj
4 Replies
5. Shell Programming and Scripting
Hi ,
I need some inputs on how to open a file (file.txt) and parse the text example aaa of the file and bbb of the file and add the text zzzz once i parse (aaa and bbb) and followed by the remaining of the text as it is in the file using perl programming.
Thanks in advance (3 Replies)
Discussion started by: madhul2002
3 Replies
6. Solaris
Pre: no gpasswd/adduser
there is just usermod can be used, also there is no -a option for usermod.
How should I add a user into a group? (4 Replies)
Discussion started by: a2156z
4 Replies
7. Shell Programming and Scripting
I have a file with 50,000 records in it, i have a requirement to use the same 50,000 records and add them 4 times to the same file to make a total of 200,000 records. I was wondering how to do this using ksh. Any help is greatly appreciated. (2 Replies)
Discussion started by: vpv0002
2 Replies
8. UNIX for Dummies Questions & Answers
Evening all !
I would like to ask your expertise on how to accomplish the following ;
I have 2 lists, and would like each line from list2 to be appended to each line in list1, resulting in list3 ;
List1;
alpha
beta
charlie
List2;
one
two
three (4 Replies)
Discussion started by: TAPE
4 Replies
9. Shell Programming and Scripting
I have a file which has lines that end with a plus (+) sign. I would like to get the next line appended to the one with the plus. For example
bla bla bla bla bla +
blip blip blip
would become
bla bla bla bla bla blip blip blip
However not all lines end with a plus sign . I would... (2 Replies)
Discussion started by: bombcan
2 Replies
10. Shell Programming and Scripting
deleted (2 Replies)
Discussion started by: ust3
2 Replies
acct(1M) acct(1M)
NAME
acct: acctdisk, acctdusg, accton, acctwtmp, closewtmp, utmp2wtmp - overview of accounting and miscellaneous accounting commands
SYNOPSIS
file] file]
[file]
reason
DESCRIPTION
Accounting software is structured as a set of tools (consisting of both C programs and shell procedures) that can be used to build account-
ing systems. The shell procedures, described in acctsh(1M), are built on top of the C programs.
Connect time accounting is handled by various programs that write records into the The programs described in acctcon(1M) convert this file
into session and charging records which are then summarized by (see acctmerg(1M)).
Process accounting is performed by the HP-UX system kernel. Upon termination of a process, one record per process is written to a file
(normally The programs in acctprc(1M) summarize this data for charging purposes; is used to summarize command usage (see acctcms(1M)).
Current process data can be examined using (see acctcom(1M)).
Process accounting and connect time accounting (or any accounting records in the format described in acct(4)) can be merged and summarized
into total accounting records by (see the format in acct(4)). is used to format any or all accounting records (see acctsh(1M)).
reads lines that contain user ID, login name, and number of disk blocks, and converts them to total accounting records that can be merged
with other accounting records.
reads its standard input (usually from and computes disk resource consumption (including indirect blocks) by login. Only files found under
login directories (as determined from the password file) are accounted for. All files under a login directory are assumed to belong to
that user regardless of actual owner. If is given, records consisting of those file names for which charges no one are placed in file (a
potential source for finding users trying to avoid disk charges). If is given, file is the name of the password file. This option is not
needed if the password file is (See diskusg(1M) for more details.)
turns process accounting off if the optional file argument is omitted. If file is given, it must be the name of an existing file, to which
the kernel appends process accounting records (see acct(2) and acct(4)).
writes a utmp record to its standard output if the option is not used. If the option is used, writes a record to The record contains the
current time and a string of characters that describe the reason for writing the record. A record type of is assigned (see utmp(4) and
utmps(4)). The string argument reason must be 11 or fewer characters, numbers, or spaces if option is not used. Otherwise, it must be 63
or fewer characters, numbers, or spaces. For example, the following are suggestions for use in reboot and shutdown procedures, respec-
tively:
writes a record, for each user currently logged in, to the file This program is invoked by runacct to close the existing file before creat-
ing a new one.
writes a record, for each user currently logged in, to the file This program is invoked by runacct to initialize the newly created file.
FILES
Holds all accounting commands listed in section(1M) of this manual.
Current process accounting file.
Used for converting login name to user ID
Login/logoff history file.
New login/logoff history database.
SEE ALSO
acctcms(1M), acctcom(1M), acctcon(1M), acctmerg(1M), acctprc(1M), acctsh(1M), diskusg(1M), fwtmp(1M), runacct(1M), acct(2), acct(4),
utmp(4). utmps(4), wtmps(4).
STANDARDS CONFORMANCE
acct(1M)