Formatting a text file based on newline and delimiter characters
Hi Everybody,
I need some help on formatting the files coming into unix box on the fly.
I get a file some thing like this in a single line.
Code:
ISA^M00^M ^M00^M ^M14^M006929681900 ^M01^M095449419 ^M061130^M2240^MU^M00401^M000003791^M0^MP^M>~GS^MPO^M006929681900^M095449419^M20061130^M2240^M41^MX^M004010~ST^M850^M000000059~BEG^M00^MNE^M11302346F2600^M^M20061130~REF^MIA^M0028910^MTANKO COMPANY~FOB^MPP^MDE^M00300DO~ITD^M^M^M^M^M^M^M^M^M^M^M^M 02% 60 DAYS~DTM^M010^M20061214~TD5^M^M^M^M^MAUTHORIZED CARRIER~
Now all I want is :
1) To identify my delimiter character at 4th position(which is ^M[single character] for this file and it could be varying for other files)
2) Change the delimiter character whatever it is to *(asterisk)
3) To identify my newline character at 105 position(which is a tilde(~) in this file and it could be varying for other files)
4) Break into new line when ever there is a newline character which cud be ~ or any thing else.
5)Finally changed file should look like below :
ISA*00* *00* *14*006929681900 *01*095449419 *061130*2240*U*00401*000003791*0*P*>
GS*PO*006929681900*095449419*20061130*2240*41*X*004010
ST*850*000000059
BEG*00*NE*11302346F2600**20061130
REF*IA*0028910*TANKO COMPANY
FOB*PP*DE*00300DO
ITD************ 02% 60 DAYS
DTM*010*20061214
TD5*****AUTHORIZED CARRIER
6)Also when the script is run on already formatted file like above it should not disturb the file since it is already in perfect shape.
I am new to the shell script and my part of struggle I did by looking threads in this forum but my requirement did not match any
Please help me with the script.
Hi,
I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and... (6 Replies)
Hi All,
I have raw data in the format :-
--------------------------------------------------------------------
NUT070
3 ./opc.sh SQLSCRIPT &SID sysdate.sql 20120105
NUW004
3 ./opc.sh SQLSCRIPT &SID sab_supp.sql
UNUW032
3 ./opc.sh SQLSCRIPT &SID sab_unsupp.sql... (3 Replies)
Hi All,
Just need small help in resolving the special new line character in generated output file.
In one of my shell script I am using following lines to get the spool file (i.e. sfile.txt) and
AAA_XXXX_p111_n222.txt
AAA_YYYY_p111_n222.txt
Here assuming
v_pnum="p111"
v_nid="n222"
... (1 Reply)
Good day ...
Well i do have this project in school, in our Principles Of Operating System Class
We are using Cygwin....
And our project goes like this...
Create a dictionary using cygwin. Display the following menu at the start of
execution
1-add a word in the dictionary # specify... (1 Reply)
Good day ...
Well i do have this project in school, in our Principles Of Operating System Class
We are using Cygwin....
And our project goes like this...
Create a dictionary using cygwin. Display the following menu at the start of execution
1-add a word in the dictionary # specify the... (1 Reply)
My source file is pipe delimeted file with 53 fields.In 33 rd column i am getting mutlple new line characters,dule to that record is breaking into multiple records.
Note : here record delimter also \n
sample Source file with 6 fields :
1234|abc| \nabcd \n bvd \n cde \n |678|890|900\n
... (6 Replies)
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
A text file has 2 fields (Data, Filename) delimited by # as below,
Data,Filename
Row1 -> abc#Test1.xml
Row2 -> xyz#Test2.xml
Row3 -> ghi#Test3.xml
The content in first field has to be written into a file where filename should be considered from second field.
So from... (4 Replies)
The input file is as below
AR,age,marks,roll,section,evin,25,80,456,A,atch,23,56,789,B,eena,24
,78H245,C,Ps,ot,ecessary,hat,ame comes first then age and rest AR
AZ,kevin,25,80,456,A,Satch,23,56,789,Satch,23,56,789,B,Meena,24,78,H245,C,AZ
................
................
I am writting... (8 Replies)
My file has data that looks like below:
more data.txt
I wish to display each string seperated by a delimiter :
Expected output:
I tried the below but I m not getting every split string on a new line.
#!/bin/bash
for i in `sed 's/:/\\n/g' data.txt`;
do
echo -n... (2 Replies)
Discussion started by: mohtashims
2 Replies
LEARN ABOUT ULTRIX
mvaddch
addch(3cur)addch(3cur)Name
addch, waddch, mvaddch, mvwaddch - add character to window
Syntax
#include <cursesX.h>
int addch(ch)
chtype ch;
int waddch(win, ch)
WINDOW *win;
chtype ch;
int mvaddch(y, x, ch)
int y, x;
chtype ch;
int mvwaddch(win, y, x, ch)
WINDOW *win;
int y, x;
chtype ch;
Description
The routine inserts the character into the default window at the current cursor position and the window cursor is advanced. The character
is of the type which is defined in the header file, as containing both data and attributes.
The routine inserts the character into the specified window at the current cursor position. The cursor position is advanced.
The routine moves the cursor to the specified (y, x) position and inserts the character into the default window. The cursor position is
advanced after the character has been inserted.
The routine moves the cursor to the specified (y, x) position and inserts the character into the specified window. The cursor position is
advanced after the character has been inserted.
All these routines are similar to The following information applies to all the routines.
If the cursor moves on to the right margin, an automatic newline is performed. If is enabled, and a character is added to the bottom right
corner of the screen, the scrolling region will be scrolled up one line. If scrolling is not allowed, ERR will be returned.
If is a tab, newline, or backspace, the cursor will be moved appropriately within the window. If is a newline, the routine is called
before the cursor is moved to the beginning of the next line. If newline mapping is off, the cursor will be moved to the next line, but
the x coordinate will be unchanged. If is a tab the cursor is moved to the next tab position within the window. If is another control
character, it will be drawn in the ^X notation. Calling the routine after adding a control character returns the representation of the
control character, not the control character.
Video attributes can be combined with a character by or-ing them into the parameter. This will result in these attributes being set. The
intent here is that text, including attributes, can be copied from one place to another using and For further information, see
The and routines are macros.
Return Values
The and functions return OK on success and ERR on error.
See Alsoclrtoeol(3cur), inch(3cur), scrollok(3cur), standout(3cur), putchar(3s)addch(3cur)
05-10-2007
