Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell.
Pls help me as its very urgent.
Thanks,
Hema. (1 Reply)
I have file like this
FileA:
abc , "helloworld" , america
def,asia, japan
ghi, africa, ipl
Output Needed:
abc,"helloworld",america
def,asia,japan
ghi,africa,ipl
I would like to implement using awk.
I want to trim each field for its leading and trailing spaces. (7 Replies)
Using awk or sed, I'd like to remove leading spaces after a comma and before a right justified number in field 6. Sounds simple but I can't find a solution. Each field's formatting must stay intact.
Input:
40,123456-02,160,05/24/2012,02/13/1977, 10699.15,0
Output:... (5 Replies)
I have a file with the below content
a = test1
b = test2
a = test3
b= test4
c = test6
b = test5
d = test7
d = test9
Need the output to be as follows
a = test1,test3
b = test2, test5
c = test6
d = test7, test9 (4 Replies)
Hi All,
I am new to shell scripting i am trying to convert the listner.log to csv which can be inturn converted to excel for easy reading.
i used this command
awk '/SID=/ && /HOST=/ && /PORT=/ && /USER=/ {
i=match($0,"SID="); i=i+RLENGTH; h0=substr($0,i);
i=match(h0,")");... (6 Replies)
Hi Experts
I have an escape seperated fields in the unix file. And in the below format file I need to extract the first column. Please help its urgent.
cat -v op.dat | head
24397028^
I want to extract the file in below format ( with only first column )
24397028
2439707
thanks.
... (6 Replies)
Discussion started by: neha_suri06
6 Replies
LEARN ABOUT PHP
transliterator.transliterate
TRANSLITERATOR.TRANSLITERATE(3) 1 TRANSLITERATOR.TRANSLITERATE(3)Transliterator::transliterate - Transliterate a string
Object oriented style
SYNOPSIS
public string Transliterator::transliterate (string $subject, [int $start], [int $end])
DESCRIPTION
Procedural style
transliterator_transliterate (mixed $transliterator, string $subject, [int $start], [int $end])
Transforms a string or part thereof using an ICU transliterator.
PARAMETERS
o $transliterator
- In the procedural version, either a Transliterator or a string from which a Transliterator can be built.
o $subject
- The string to be transformed.
o $start
- The start index (in UTF-16 code units) from which the string will start to be transformed, inclusive. Indexing starts at 0. The
text before will be left as is.
o $end
- The end index (in UTF-16 code units) until which the string will be transformed, exclusive. Indexing starts at 0. The text after
will be left as is.
RETURN VALUES
The transfomed string on success, or FALSE on failure.
EXAMPLES
Example #1
Converting escaped UTF-16 code units
<?php
$s = "u304Au65E9u3046u3054u3056u3044u307Eu3059";
echo transliterator_transliterate("Hex-Any/Java", $s), "
";
//now the reverse operation with a supplementary character
$supplChar = html_entity_decode('𝄞');
echo mb_strlen($supplChar, "UTF-8"), "
";
$encSupplChar = transliterator_transliterate("Any-Hex/Java", $supplChar);
//echoes two encoded UTF-16 code units
echo $encSupplChar, "
";
//and back
echo transliterator_transliterate("Hex-Any/Java", $encSupplChar), "
";
?>
The above example will output something similar to:
1
uD834uDD1E
SEE ALSO
Transliterator::getErrorMessage, Transliterator::__construct.
PHP Documentation Group TRANSLITERATOR.TRANSLITERATE(3)