09-03-2013
Hi ,
Sorry for the confusion. Below is my sample source data and expected output.
Source Data
HTML Code:
Data| 12345|U|76834|123
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |0
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |1
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |2
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |3
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |4
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |5
Expected Output
HTML Code:
Data| 12345U|76834123
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |0
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |1
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |2
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |3
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |4
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |5
Regards,
Mora.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I need to know how I change the spaces by _ in folders and filder founded by find
ex.
find . -name "* *" -exec echo {} \;
./test space
./test space/new file.txt
./test space/new file
./test space/untitled folder
./test space/untitled folder/new fileruben
./Backup/backup/Image... (6 Replies)
Discussion started by: ruben.rodrigues
6 Replies
2. Shell Programming and Scripting
Hai masters,
If a file contains content of 2000 lines,
from which i need to remove the first n characters or first n spaces from each line of the file.
If suppose to remove n characters or first n spaces from a single line means, just use the command nx.
But from the above scenario,... (9 Replies)
Discussion started by: ecearund
9 Replies
3. Shell Programming and Scripting
Hi,
i have the log attached. Actually i want the long space just become 1 space left
like this :
Rgds, (12 Replies)
Discussion started by: justbow
12 Replies
4. Shell Programming and Scripting
I'd like a sed command to replace every other space in my file.
File:
0 1 0 3 0 2 0 5
Want:
01 03 02 05
Does anyone have any ideas? (9 Replies)
Discussion started by: peanuts48
9 Replies
5. Shell Programming and Scripting
I need to write a Bash script to process a data file that is in this format:
1 A B C D E
2 F G "H H" I J
As you can see, the data is delimited by a space, but there are also some fields that contain spaces and are surrounded by double-quotes. An example of that is "H H".
I wrote... (7 Replies)
Discussion started by: RickS
7 Replies
6. UNIX for Dummies Questions & Answers
I would like to know how to replace a space delimiter with a ^_ (\037) delimiter and a double quote delimiter while maintaining the spaces inside the double quotes. The double quote delimiter is only used on text fields.
I'd prefer a one-liner, but could handle a function or script that accepts... (4 Replies)
Discussion started by: SteveDWin
4 Replies
7. Shell Programming and Scripting
Basically , i want to delete strings of a particular pattern from the flat file which is " | " pipe delimited.
Below are the valid formats :
1) AAA (0) 111-111-111, AAA, BB
2) AAA (0) 111-111-1111;X, AAA, BB
original flat file example :
|ABC ABC XHAMK|AAA (0) 111-111-111, AAA,... (3 Replies)
Discussion started by: Ravi_007
3 Replies
8. Shell Programming and Scripting
Hi All,
i have file name like below
ABC_065224_123456_123456_your_130413_163005.txt
ABC_065224_123456_MAIN_20130413_163005.txt
ABC_065224_123456_123456_MAIN_130413_163005.txt
ABC_065224_123456_123456_434567_MAIN_130413_163005.txt
i need to find out the number of characters in the filed... (6 Replies)
Discussion started by: dssyadav
6 Replies
9. Shell Programming and Scripting
Hello,
I would need to replace a delimiter in a flat file using.I would like to replace the semicolon (";") but only if it was contained in a string between quotes. For example:
Original flat file example:
abc;abc;"abc;abc";cd;"ef;ef";abc
aa;bb;"aa";cc;"ddd;eee";ff
Desired output:... (9 Replies)
Discussion started by: bartleby
9 Replies
10. Programming
I can find and replace text when the delimiters are unique. What I cannot do is replace text using two NON-unique delimiters:
Ex.,
"This html code <text blah >contains <garbage blah blah >. All tags must go,<text > but some must be replaced with <garbage blah blah > without erasing other... (5 Replies)
Discussion started by: bedtime
5 Replies
LEARN ABOUT OPENSOLARIS
fmlcut
fmlcut(1F) FMLI Commands fmlcut(1F)
NAME
fmlcut - cut out selected fields of each line of a file
SYNOPSIS
fmlcut -clist [filename]...
fmlcut -flist [-dchar] [-s] [filename]...
DESCRIPTION
The fmlcut function cuts out columns from a table or fields from each line in filename; in database parlance, it implements the projection
of a relation. fmlcut can be used as a filter; if filename is not specified or is -, the standard input is read. list specifies the fields
to be selected. Fields can be fixed length (character positions) or variable length (separated by a field delimiter character), depending
on whether -c or -f is specified.
Note: Either the -c or the -f option must be specified.
OPTIONS
list A comma-separated list of integer field numbers (in increasing order), with optional - to indicate ranges. For example: 1,4,7;
1-3,8; -5,10 (short for 1-5,10); or 3- (short for third through last field).
-clist If -c is specified, list specifies character positions (for instance, -c1-72 would pass the first 72 characters of each line).
Note: No space intervenes between -c and list.
-flist If -f is specified, list is a list of fields assumed to be separated in the file by the default delimiter character, TAB, or by
char if the -d option is specified. For example, -f1,7 copies the first and seventh field only. Lines with no delimiter charac-
ters are passed through intact (useful for table subheadings), unless -s is specified. Note: No space intervenes between -f and
list. The following options can be used if you have specified -f.
-dchar If -d is specified, char is the field delimiter. Space or other characters with special meaning to FMLI must be quoted.
Note: No space intervenes between -d and char . The default field delimiter is TAB.
-s Suppresses lines with no delimiter characters. If -s is not specified, lines with no delimiters will be passed through
untouched.
EXAMPLES
Example 1 Getting login IDs and names
The following example gets the login IDs and names.
example% fmlcut -d: -f1,5 /etc/passwd
Example 2 Getting the current login name
The next example gets the current login name.
example% `who am i | fmlcut -f1 -d" "`
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
fmlgrep(1F), attributes(5)
DIAGNOSTICS
fmlcut returns the following exit values:
0 when the selected field is successfully cut out
2 on syntax errors
The following error messages may be displayed on the FMLI message line:
ERROR: line too long
A line has more than 1023 characters or fields, or there is no new-line character.
ERROR: bad list for c/f option
Missing -c or -f option or incorrectly specified list. No error occurs if a line has fewer fields than the list calls for.
ERROR: no fields
The list is empty.
ERROR: no delimiter
Missing char on -d option.
NOTES
fmlcut cannot correctly process lines longer than 1023 characters, or lines with no newline character.
SunOS 5.11 5 Jul 1990 fmlcut(1F)