03-25-2008
I tried FTPing in the binary format by using type binary on ftp prompt but still the file is being FTPed with the junk character. Also after executing the command :1,$s/\^Ò//gp in vi editor, i am getting the following error "ex: 0602-071 No match exists for the substitute pattern."
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have a file with one of the following lines, when opened with vi
33560010686GPT£120600GBPGBP10082007DS
In the above line, I want to get rid of the junk character before the £ (pound sysmbol).
When I tried copying £ from windows and copy in unix vi, it prints as £ and I tried pattern replace... (2 Replies)
Discussion started by: nskworld
2 Replies
2. Shell Programming and Scripting
Hi
set filename "./GopiRun.sh"
if } err] {
writeLog "error in exec "
writeLog $a
} else {
writeLog $a
}
The above code will execute a file GopiRun.sh,and will log the output of the exec to a file.
The problem is the file has lot of junk character in it,how to avoid it.
The... (2 Replies)
Discussion started by: nathgopi214
2 Replies
3. Shell Programming and Scripting
Hi Team,
I have a file having size greater than 1 GB. What i want to do is to check if it contains any JUNK character (ie any special charater thats not on the key board stroke). This file has 532 column & seperated with ^~^.
I have found some solution from the file, but it is for a... (4 Replies)
Discussion started by: Amit.Sagpariya
4 Replies
4. Shell Programming and Scripting
Hi All
I have a rather unusual problem, which i have not faced till now. I have a script which exports some paths to a text file. The script runs fine but when i check the output file i can see some junk characters ^M appended at end of lines and random places. I am not able to figure... (4 Replies)
Discussion started by: raghu_shekar
4 Replies
5. UNIX Desktop Questions & Answers
I wanted to remove junk char in my csv. :mad:
Input file format:
"17","9986782190","0","D","2"
"17","9900918331","0","D","2"
"13","9986782194","0","A","2"
Output file format
9986782190
9900918331
9986782194
And one more thing all the time "13"," this will be different Ex: . (2 Replies)
Discussion started by: Siddartha
2 Replies
6. Shell Programming and Scripting
Hello,
I have two .sql files which I transferred from Windows to Unix (Linux Enterprise Linux Server release 5.3).I want to ensure that these two files have no junk characters in them.How do I do it in the simplest possible way?
Many thanks
DJ (1 Reply)
Discussion started by: Digjoy83
1 Replies
7. Shell Programming and Scripting
Dear ALL,
How to remove junk charecter ^M from unix file i am using sun solaris unix.
I already tried few commands
:%s/^M//g
:%s/r//g
but it didnt helped me.
Any help appriciated.
Thanks
Ripudaman
Please view this code tag video for how to use code tags when posting code... (5 Replies)
Discussion started by: ripudaman.singh
5 Replies
8. Shell Programming and Scripting
Hi
I want to know how to see junk character in a file.
i am not able to see junk character using vi or cat command.
below is the junk char . which i see in host file
10.178.14.67▒▒▒ ac01sp02-vip
actually it should be like this
10.178.14.67 ac01sp02-vip
i am using secure CRT... (11 Replies)
Discussion started by: scriptor
11 Replies
9. Emergency UNIX and Linux Support
Hello All,
I have issues in unix file when I loaded that to database and do select * from table where description like '%'+char(13)+'%' on it I am able to get records. I tried to view the file in unix it is all having blank character which I think is all non ascii which I am not able view.... (11 Replies)
Discussion started by: arunkumar_mca
11 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I have a issue that we are getting Junk characters from source and i am not able to load that records to Database.
Line breakers
Junk Characters (Â and different every time)
Japanese Characters
Every time I am using grep command and awk -F "\007" to find them and delete that... (1 Reply)
Discussion started by: spradeep86
1 Replies
LEARN ABOUT PHP
pg_unescape_bytea
PG_UNESCAPE_BYTEA(3) PG_UNESCAPE_BYTEA(3)
pg_unescape_bytea - Unescape binary for bytea type
SYNOPSIS
string pg_unescape_bytea (string $data)
DESCRIPTION
pg_unescape_bytea(3) unescapes PostgreSQL bytea data values. It returns the unescaped string, possibly containing binary data.
Note
When you SELECT a bytea type, PostgreSQL returns octal byte values prefixed with '' (e.g. 32). Users are supposed to convert
back to binary format manually.
This function requires PostgreSQL 7.2 or later. With PostgreSQL 7.2.0 and 7.2.1, bytea values must be cast when you enable multi-
byte support. i.e. INSERT INTO test_table (image) VALUES ('$image_escaped'::bytea); PostgreSQL 7.2.2 or later does not need a cast.
The exception is when the client and backend character encoding does not match, and there may be multi-byte stream error. User must
then cast to bytea to avoid this error.
PARAMETERS
o $data
- A string containing PostgreSQL bytea data to be converted into a PHP binary string.
RETURN VALUES
A string containing the unescaped data.
EXAMPLES
Example #1
pg_unescape_bytea(3) example
<?php
// Connect to the database
$dbconn = pg_connect('dbname=foo');
// Get the bytea data
$res = pg_query("SELECT data FROM gallery WHERE name='Pine trees'");
$raw = pg_fetch_result($res, 'data');
// Convert to binary and send to the browser
header('Content-type: image/jpeg');
echo pg_unescape_bytea($raw);
?>
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.5.1 | |
| | |
| | A warning is thrown if the input string is |
| | invalid. |
| | |
+--------+---------------------------------------------------+
SEE ALSO
pg_escape_bytea(3), pg_escape_string(3).
PHP Documentation Group PG_UNESCAPE_BYTEA(3)