02-17-2013
Data Normalization
Hi, there
Need help on rearranging the data.
I have data in the following format.
LAC
=
040
DN
=
24001001
EQN
=
920-
2-
0-
1
CAT
=
MS
OPTRCL
=
3
TRARSTR
=
ACTTRACL
TRACLACT
TRACLMOD
LNATT
=
PB
COS
=
CLIP
Immediate row before the symbol "=" is like Column heading. The rows after "=" are like corresponding values.
I need to rearrange the data as follows.
LAC|DN|EQN|CAT|OPTRCL|TRARSTR|LNATT|COS
040|24001001|920- 2- 0- 1|MS|3|ACTTRACL TRACLACT TRACLMOD|PB|CLIP
Please help me out.
Thanks
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
i willbe very much grateful to u if u help me out..
if i simply connect pbx machine to printer by serial port RS232 then we find this view:
But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies
2. Shell Programming and Scripting
I have created simple shell script
#!/bin/sh
echo `date`; echo "Start ....
find . -mtime +95 -print > /tmp/files.txt
for file in `cat /tmp/files.txt`
do
echo "copying file - $file"
/usr/local/bin/scp -p -P 2222 $file remote.hostname:/file/path
echo "copid file -... (3 Replies)
Discussion started by: ynilesh
3 Replies
3. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent.
E.g : username empid
------------------------
sri 123
to
username,empid
sri,123
Thanks,
Hema:confused: (2 Replies)
Discussion started by: Hemamalini
2 Replies
4. Shell Programming and Scripting
My input file:
data_5 Ali 422 2.00E-45 102/253 140/253 24
data_3 Abu 202 60.00E-45 12/23 140/23 28
data_1 Ahmad 256 7.00E-45 120/235 140/235 22
data_4 Aman 365 8.00E-45 15/65 140/65 20
data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies
5. Shell Programming and Scripting
Hi All, I am having a file having below three lines or maybe more than 3 lines. The first line will be always constant.
### Line 1 ####
Transformation||Transformation Mapplet Name||Transformation Group||Partition Index||Transformation Row ID||Error Sequence||Error Timestamp||Error UTC... (4 Replies)
Discussion started by: satyaranjon
4 Replies
6. Shell Programming and Scripting
Hi
I have a file with
chr22_190_200 XXY 0 0
chr22_201_210 XXY 0 30
chr22_211_220 XXY 3 0
chr22_221_230 XXY 0 0
chr22_231_240 XXY 5 0
chr22_241_250 ABC 0 0
chr22_251_260 ABC 22 11
... (12 Replies)
Discussion started by: Diya123
12 Replies
7. Shell Programming and Scripting
I made my explanation precise in the CODE below.
I can do this manually. But is there a way to automate this?
If I give 4 or 10 or any number of inputs. It should calculate the CODE and print the different outputs with normalization value ?
some thing like script.sh input1 input2 input3 input4... (12 Replies)
Discussion started by: quincyjones
12 Replies
8. Shell Programming and Scripting
Hi All,
I was wondering how I can convert each line in an input file where fields are separated by variable width spaces into a CSV file. Below is the scenario what I am looking for.
My Input data in inputfile.txt
19 15657 15685 Sr2dReader 107.88 105.51... (4 Replies)
Discussion started by: vharsha
4 Replies
9. Shell Programming and Scripting
Hi!
I have a pretty complex job - at least for me!
i have two csv-files with meassurement-data:
fileA
...... (2 Replies)
Discussion started by: IMPe
2 Replies
LEARN ABOUT PHP
normalizer
NORMALIZER(3) 1 NORMALIZER(3)
The Normalizer class
INTRODUCTION
Normalization is a process that involves transforming characters and sequences of characters into a formally-defined underlying represen-
tation. This process is most important when text needs to be compared for sorting and searching, but it is also used when storing text to
ensure that the text is stored in a consistent representation.
The Unicode Consortium has defined a number of normalization forms reflecting the various needs of applications:
oNormalization Form D (NFD) - Canonical Decomposition
o Normalization Form C (NFC) - Canonical Decomposition followed by Canonical Composition
o Normalization Form KD (NFKD) - Compatibility Decomposition
o Normalization Form KC (NFKC) - Compatibility Decomposition followed by Canonical Composition
The different forms are defined in terms of a set of transformations on the text, transformations that are expressed by both an algorithm
and a set of data files.
CLASS SYNOPSIS
Normalizer
Normalizer
Methods
o publicstatic bool Normalizer::isNormalized (string $input, [string $form = Normalizer::FORM_C])
o publicstatic string Normalizer::normalize (string $input, [string $form = Normalizer::FORM_C])
PREDEFINED CONSTANTS
The following constants define the normalization form used by the normalizer:
o Normalizer::FORM_C ( integer) - Normalization Form C (NFC) - Canonical Decomposition followed by Canonical Composition
o Normalizer::FORM_D ( integer) -Normalization Form D (NFD) - Canonical Decomposition
o Normalizer::FORM_KC ( integer) - Normalization Form KC (NFKC) - Compatibility Decomposition, followed by Canonical Composition
o Normalizer::FORM_KD ( integer) - Normalization Form KD (NFKD) - Compatibility Decomposition
o Normalizer::NONE ( integer) -No decomposition/composition
o Normalizer::OPTION_DEFAULT ( integer) -Default normalization options
SEE ALSO
o Unicode Normalization
o Unicode Normalization FAQ
o ICU User Guide - Normalization
o ICU API Reference - Normalization
PHP Documentation Group NORMALIZER(3)