I am having file :
This file contains only 3 fields delimeted by "|". Last field is a decsription filed and it contains character "|". Due to this my output if breaking in 4 fields. I need to replace the last "|" from description fields "FUNG SIU TO |CLEMENT" and make it "FUNG SIU TO _CLEMENT".
Can some one guide how to do this using AWK or Sed?
---------- Post updated at 02:07 AM ---------- Previous update was at 02:01 AM ----------
Actual file may be like that :
1|24xx|x96|wewewewewe|Aps (ueasTng) Ltd(00101|2500000)|001012561|558 |NYL|GB |G179300844|1012561038 |Orriva P|LC|GB |O718483442|Y
This is one record and here field no 2 (24xx|x96 ),field no 4(Aps (ueasTng) Ltd(00101|2500000)), and field no. 11(Orriva P|LC) will be having '|' appened. Fields in Red contains the '|'. Each field has fixed length.
---------- Post updated at 03:06 AM ---------- Previous update was at 03:05 AM ----------
Hi Srini
Awesome. But My actual case is little different.
Actual file may be like that :
This is one record and here field no 2 (24xx|x96 ),field no 4(Aps (ueasTng) Ltd(00101|2500000)), and field no. 11(Orriva P|LC) will be having '|' appened. Fields in Red contains the '|'. Each field has fixed length.
Last edited by Don Cragun; 05-27-2014 at 05:13 AM..
Reason: get rid of italics in CODE segment
This is not a little different. There is a HUGE difference between changing all "|" characters after the first 3 on a line to "_" characters and changing an unknown number of "|" characters in the middle of a line to some other unspecified character(s).
What are the exact field widths for this new file format (or what is the format of the file that specifies the file format for the file(s) you want to process)? Are embedded "|" characters all supposed to be changed to "_", or is a different character used in some fields? Do all fields need to be checked? If not, how will your script know which fields should be checked?
Sorry, that description doesn't help either. You say the third field is 3 chars long, but your line holds 4 chars: X96 . Same for field 7. And between field 8 and 9 an entire field is missing: GB in your line is not reflected. So which one should we rely on?
BTW - can't you address the problem at the root and persuade the generating application to use different field separators?
I'd like to put paragraph breaks \n\n randomly between 5 - 10 occurrences of the dot character (.), for an entire text file. How to do that?
In other words, anywhere between every 5 -10 sentences, a new paragraph will generate. There are no other uses of the (.) except for sentence breaks in... (11 Replies)
Hi All
It's me again with another huge txt files. :confused:
What I have:
- I have 33 huge txt files in a folder.
- I have thousands of line in this txt file which contain many the letter "x" in them.
- Some of them have more than one "x" character in the line.
What I want to achieve:... (8 Replies)
Hello everyone
Sorry I have to add another sed question. I am searching a log file and need only the first 2 occurances of text which comes after (note the space) "string " and before a ",". I have tried
sed -n 's/.*string \(*\),.*/\1/p' filewith some, but limited success. This gives out all... (10 Replies)
Hi,
My input has much more lines, but few of them are below
pin(IDF) {
direction : input;
drc_pinsigtype : signal;
pin(SELDIV6) {
direction : input;
drc_pinsigtype : ... (3 Replies)
Hi All,
I'm trying to write a ksh script to parse a file. When the "\" character is encountered, it should be removed and the next line should be concatenated with the current line. For example...
this is a test
line #1\
should be concatenated with line #2\
and line number 3
when this... (3 Replies)
Hi All,
I am facing a strange situation and want to find why it is occuring . When i convert the whole line into Hexadecimal character i can find the junk value after new line (\n) . If i look in binary mode it is not visible.
PLease let me know how possible the junk character is added... (1 Reply)