sorry for the confusion and the mess created by me.
I have only the xls file which has this data
Code:
column1 column2 column3 column4
16 jan 1994 _alia1 22 chennai
17 jan 1994 _alia2 22 chennai
18 jan 1994 _alia3 22 chennai
19 jan 1994 _alia4 22 chennai
Underscores means spaces. so there is only one leading space before the data in column 2 and the position of the space is shown above.
and i want to remove space from the second column to make it look like below:
Code:
column1 column2 column3 column4
16 jan 1994 alia1 22 chennai
17 jan 1994 alia2 22 chennai
18 jan 1994 alia3 22 chennai
19 jan 1994 alia4 22 chennai
Hey ,
I have a file and it's having spaces for some of the fields in it. Like the one below. I want to remove the spaces in them through out the file. The spaces occur randomly and i can't say which field is having space. So please help. Here is sample file with spaces after 5th field. (3 Replies)
I'm currently writing my sql results to a file and they have trailing spaces after each field. I want to get rid of these spaces and I'm using this code:
TVXTEMP=$(echo $TVXTEMP|sed -e 's/\ //g')
It doesn't work though. I'm not familiar with sedscript, and the other codes I've found online... (6 Replies)
hi
i have a file which store some data.the contents of my file is
data1:data2
data3:data4
i have a script which read this file
correct="$(cat /root/sh | cut -d: -f1)"
i used this syntax..please help me which syntax is used to remove blank spaces..then how to read this file.. (1 Reply)
hey,
I have this file:
ATOM 2510 HG12 VAL 160 8.462 15.861 1.637
ATOM 2511 HG13 VAL 160 9.152 14.510 0.725
ATOM 2512 CG2 VAL 160 6.506 16.579 -0.088
ATOM 2513 HG21 VAL 160 5.499 16.421 -0.478
ATOM 2514 HG22 VAL 160 6.417 16.984 ... (4 Replies)
Hi,
I have a text as below
test1 test2 test3\
test4 test5 test6 test7
newtest1 newtest2\
newtest3 newtest4 newtest5
And need this to be replaces to
test1 test2 test3 test4 test5 test6 test7
newtest1 newtest2 newtest3 newtest4 newtest5
So my requirement is to remove the EOL... (5 Replies)
hiii i have a file that contains spaces in the begining of a file till the middle the from there the txt would appear. hw can i remove those spaces and bring the text to the begining portion
file1
text starts from here (12 Replies)
I have a file which contains data such as that shown below. How do i remove all the blcnak spaces, before, during and at the end of each line in one command?
300015, 58.0823212, 230.424728
300016, 58.2276459, 229.141602
300017, 58.7590027, 226.960846
... (9 Replies)
Hi friends,
I have a file1.txt
1 | a | 4757634 | jund jdkj | erhyj
2 | a | 4757634 | jnd jdkj | rhje hjrhwj
i have used tr -d '\040' to remove the spcaes
output file
cat file1.txt | tr -d '\040'
1|a|4757634|jundjdkj|erhyj... (5 Replies)
Hi All,
The output file contains data as below.
"20141023","CUSTOMER" ,"COMPANY" ,"IN0515461" ,"" ,"JOSHUA"
There are spaces in between the ending " and ,. The number of spaces is random.
How can I remove that from the file so that the final output is:... (4 Replies)
I've tried various solutions to move a file name with spaces and nothing seems to work. I need to take a date as input, prepend it to a filename with spaces then remove the spaces and mv the file to the new name.
#!/bin/ksh
#
if (( $# != 1 ))
then
echo "Usage: `basename $0` <DATE> "
... (5 Replies)
Discussion started by: w_s_s
5 Replies
LEARN ABOUT PHP
mcrypt_generic
MCRYPT_GENERIC(3) 1 MCRYPT_GENERIC(3)mcrypt_generic - This function encrypts dataSYNOPSIS
string mcrypt_generic (resource $td, string $data)
DESCRIPTION
This function encrypts data. The data is padded with " " to make sure the length of the data is n * blocksize. This function returns the
encrypted data. Note that the length of the returned string can in fact be longer than the input, due to the padding of the data.
If you want to store the encrypted data in a database make sure to store the entire string as returned by mcrypt_generic, or the string
will not entirely decrypt properly. If your original string is 10 characters long and the block size is 8 (use mcrypt_enc_get_block_size(3)
to determine the blocksize), you would need at least 16 characters in your database field. Note the string returned by mdecrypt_generic(3)
will be 16 characters as well...use rtrim($str, " ") to remove the padding.
If you are for example storing the data in a MySQL database remember that varchar fields automatically have trailing spaces removed during
insertion. As encrypted data can end in a space (ASCII 32), the data will be damaged by this removal. Store data in a tinyblob/tinytext (or
larger) field instead.
PARAMETERS
o $td
- The encryption descriptor. The encryption handle should always be initialized with mcrypt_generic_init(3) with a key and an IV
before calling this function. Where the encryption is done, you should free the encryption buffers by calling
mcrypt_generic_deinit(3). See mcrypt_module_open(3) for an example.
o $data
- The data to encrypt.
RETURN VALUES
Returns the encrypted data.
SEE ALSO mdecrypt_generic(3), mcrypt_generic_init(3), mcrypt_generic_deinit(3).
PHP Documentation Group MCRYPT_GENERIC(3)
10-06-2014
