Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Removing pipe and space in a file Post 303024828 by arunkumar_mca on Wednesday 17th of October 2018 01:59:46 PM
Old 10-17-2018
Removing pipe and space in a file

Hi ,

I have a file which is like below. The file record is separated by | as delimiter. I want to remove the first and last | in the file and also I want to remove the spaces in the columns.

Code:
Original File
|3464114      |10     | REPORT|CA| 1|0|4825400|0|213167|  939396524|

Expected:
3464114|10|REPORT|CA|1|0|4825400|0|213167|939396524


I tried below sed and getting the | delimited removed from first and last . But I need to remove space too. For some reason I am not getting expected out on big file with the below command:-
Code:
#sed -n '/^| */{s///;s/ *| */|/g;p;}'  file.out > format.out


Last edited by rbatte1; 10-22-2018 at 12:56 PM.. Reason: Added ICODE tags round the delimeter for clarity and corrected spelling
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing Space at the end of file

Hi.... I have a situation...I have a data file...that has space(an extra row with no data) at the end of file. I am trying to remove that spaces only if the file has a space at the end of file and if there is no space I don't want to do anything. Can you please help me in this regards. ... (4 Replies)
Discussion started by: rkumar28
4 Replies

2. Shell Programming and Scripting

Help needed in removing intermediate segments from a pipe delimited segment file

Hi, I just stuckup in doing some regular expressions on a file. I have data which has multiple FHS and BTS segments like: FHS|12121|LOCAL|2323 MSH|10101|POTAMAS|2323 PID|121221|THOMAS|DAVID|23432 OBX|2342|H1211|3232 BTS|0000|MERSTO|LIABLE FHS|12121|LOCAL|2323 MSH|10101|POTAMAS|2323... (3 Replies)
Discussion started by: naren_0101bits
3 Replies

3. UNIX for Dummies Questions & Answers

replacing space with pipe(delimiter)

Hello All, I have a file with thousands of records: eg: |000222|123456987|||||||AARONSON| JOHN P|||PRIMARY |P |000111|567894521|||||||ATHENS| WILLIAM k|||AAAA|L Expected: |000222|123456987|||||||AARONSON| JOHN |P|||PRIMARY |P |000111|567894521|||||||ATHENS| WILLIAM |k|||AAAA|L I... (6 Replies)
Discussion started by: OSD
6 Replies

4. Shell Programming and Scripting

Removing blank lines from comma seperated and space seperated file.

Hi, I want to remove empty/blank lines from comma seperated and space seperated files Thanks all for help (11 Replies)
Discussion started by: pinnacle
11 Replies

5. Shell Programming and Scripting

removing extra double quotes between pipe dilimeter

I have a flat file sample like this - "COURSE"|"ddddd " " dddd"|"sssddd sdsdsdsdx" dddddddd ffffff "aaaaa" dddddddd ffffff sdsdsd"|"xxxxxxx"| "COURSE"|"ffff " " bbbb"|"lllll"| The delimiter is pipe character (|) and the text are enclosed in double quotes... (5 Replies)
Discussion started by: vishalzone
5 Replies

6. Shell Programming and Scripting

How to convert a space delimited file into a pipe delimited file using shellscript?

Hi All, I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted... AA ATIU2345098809 009697 005374 BB ATIU2345097809 005445 006518 CC ATIU9685098809 003215 003571 DD... (7 Replies)
Discussion started by: nithins007
7 Replies

7. Shell Programming and Scripting

Removing blank space in file

TT0000013101257 | JCJMMUJMMUB018 ... (0 Replies)
Discussion started by: sususa
0 Replies

8. Shell Programming and Scripting

Fixed with file- removing leading zeros and adding the space

Hi All, i have a fixed width file , where each line is 3200 length. File: 1ABC 1111 2222 3333 000012341 1001 2ABC 1111 2222 3333 000012342 1002 3ABC 1111 2222 3333 000112343 1003 1DEF 5555 4444 9696 000012344 1004 2DEF 5555 2323 8686 000012345 1005 3DEF 5555 1212 7676 000012346 1006 ... (1 Reply)
Discussion started by: mechvijays
1 Replies

9. Shell Programming and Scripting

Removing duplicate lines on first column based with pipe delimiter

Hi, I have tried to remove dublicate lines based on first column with pipe delimiter . but i ma not able to get some uniqu lines Command : sort -t'|' -nuk1 file.txt Input : 38376KZ|09/25/15|1.057 38376KZ|09/25/15|1.057 02006YB|09/25/15|0.859 12593PS|09/25/15|2.803... (2 Replies)
Discussion started by: parithi06
2 Replies

10. Shell Programming and Scripting

Space in input filename with pipe

Hello, Normally below script works, could you please comment out what could be the reason of failure if there are spaces in input filename: script.sh #!/bin/bash cd /home/hts/.hts/tvh/ file="$1 $2 $3 $4" read -d $'\x04' name < "$file" /usr/bin/ffmpeg -i ""$name"" -vcodec copy -preset... (1 Reply)
Discussion started by: baris35
1 Replies
fattach(3C)															       fattach(3C)

NAME
fattach() - attach a STREAMS file descriptor to an object in the file system name space SYNOPSIS
DESCRIPTION
The function attaches the fd file descriptor to an object in the file system name space designated by path. fd specifies an open file descriptor to a STREAMS device or STREAMS-based pipe. path specifies the pathname of an existing object in the file system. A STREAMS device or pipe can be attached to more than one node in the file system name space. In other words, a STREAMS device or pipe is allowed to have several associated names. Until the STREAMS device or pipe is detached from the node (with fdetach(3C) or fdetach(1M)), all opera- tions on path will act on the STREAMS device or pipe instead of the file system object path. The stream's attributes (see the stat(2) reference page) are set according to the following scheme: o The group ID, user ID, times, and permissions are set to those of path. o The size as well as the device number are set to those of the STREAMS device or pipe designated by the fd parameter. Note that although the attributes of the STREAMS device or pipe may change (see the chmod(2) reference page), the attributes of the underlying file system object path will not be changed. o The number of links is set to 1. RETURN VALUE
Upon successful completion, the function returns a value of 0 (zero). Otherwise, it returns a value of -1, and is set to indicate the error. ERRORS
If any of the following conditions occurs, the function sets to the value that corresponds to the condition. [EACCES] Although the user is the owner of path, the user has no write permissions for it. [EBADF] The fd parameter is an invalid file descriptor. [EBUSY] The existing object specified by the path parameter is already mounted or has a file descriptor attached to it. [EFAULT] The path parameter points to a location outside of the allocated address space of the process. [EINVAL] The fd parameter does not refer to a STREAMS device or STREAMS-based pipe. [ELOOP] When path was translated, too many symbolic links were found. [ENOENT] path does not exist. [ENOTDIR] The directory portion of the path parameter does not exist. [ENAMETOOLONG] The size of a pathname component is longer than when is in effect, or the pathname length is longer than [EPERM] The current effective user ID is not the owner of the existing object specified by the path parameter. SEE ALSO
fdetach(3C), isastream(3C), chmod(2), stat(2), fdetach(1M), streamio(7). STANDARDS COMPLIANCE
fattach(3C)
All times are GMT -4. The time now is 02:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy