Hi,
I have a fixed width flat file which has 1 as the first char and E as the last character. Some of the records have a carriage return /line feeds .
how do I remove them?
Let me know.
Thanks
VSK (8 Replies)
:confused: hi all,
i have csv file with three comma separated columns
i/p file
First_Name, Address, Last_Name
XXX, "456 New albany \n newyork, Unitedstates \n 45322-33", YYY\n
ZZZ, "654 rifle park \n toronto, canada \n 43L-w3b", RRR\n
is there any way i can remove \n (newline) from... (10 Replies)
Hi all,
I know this is **awfully** general but.....
I have a script which does, basically...
for file in `find command`; do
some stuff
more stuff
echo '.\c'
done
I want to output the '.' char just to give an idea of progress. However, it works fine for a while and then I... (2 Replies)
Hi gurus
I am stripping lots of email addresses from a file with this
grep "^To" file.log |awk '{print "1,"$2}' > recipients.out
file.log looks something like this:
oasndfoasnosf
To: person@email.co.uk
lsdfjosd
sdlfnmsopdfwer
dtlghodrgn
To: person2@emailsss.com
sldfnsdf
I... (5 Replies)
Hi,
I have a .properties file that a read in some values in an .sh file but everytime I put it out on the server it fails.
If I copy and paste the values of the .properties file on my local machine to the .properties file on the server it works just fine. Someone mentioned to see if it has
dos... (3 Replies)
Hi everyone,
I'm very new to using sed, run through some tutorials and everything but I've hit a problem that I'm unable to solve by myself.
I need to remove all linefeeds that are followed by a particular character (in this case a semicolon). So basically, all lines starting with a semicolon... (5 Replies)
I would like to remove carriage returns/line feeds in a text file, but in a specific cadence:
Read first line (Header Line 1), remove cr/lf at the end (replace it with a space ideally);
Read the next line (Line of Text 2), leave the cr/lf intact;
Read the next line, remove the cr/lf;
Read... (14 Replies)
I have a file as below
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
2345|FirstName2|MiddleName3|LastName4|
Add1 || ADD2|
234|000000000
OUTPUT :
... (1 Reply)
Discussion started by: styris
1 Replies
LEARN ABOUT PHP
ifx_prepare
IFX_PREPARE(3) 1 IFX_PREPARE(3)ifx_prepare - Prepare an SQL-statement for executionSYNOPSIS
resource ifx_prepare (string $query, resource $link_identifier, [int $cursor_def], mixed $blobidarray)
DESCRIPTION
Prepares a $query for later use with ifx_do(3).
For "select-type" queries a cursor is declared and opened. Non-select queries are "execute immediate".
For either query type the number of (estimated or real) affected rows is saved for retrieval by ifx_affected_rows(3).
If the contents of the TEXT (or BYTE) column allow it, you can also use ifx_textasvarchar(1) and ifx_byteasvarchar(1). This allows you to
treat TEXT (or BYTE) columns just as if they were ordinary (but long) VARCHAR columns for select queries, and you don't need to bother with
blob id's.
With ifx_textasvarchar(0) or ifx_byteasvarchar(0) (the default situation), select queries will return BLOB columns as blob id's (integer
value). You can get the value of the blob as a string or file with the blob functions (see below).
PARAMETERS
o $query
- The query string.
o $link_identifier
- The link identifier.
o $cursor_def
- This optional parameter allows you to make this a scroll and/or hold cursor. It's a bitmask and can be either IFX_SCROLL,
IFX_HOLD, or both or'ed together.
o $blobidarray
- If you have BLOB (BYTE or TEXT) columns in the query, you can add a $blobidarray parameter containing the corresponding "blob
ids", and you should replace those columns with a "?" in the query text.
RETURN VALUES
Returns a valid result identifier for use by ifx_do(3), or FALSE on errors.
SEE ALSO ifx_do(3).
PHP Documentation Group IFX_PREPARE(3)