Sponsored Content
Full Discussion: How to format String in ksh
Top Forums Shell Programming and Scripting How to format String in ksh Post 302578622 by CarloM on Friday 2nd of December 2011 04:05:39 AM
Old 12-02-2011
Try
Code:
awk -F, '{printf "%30s%30s%30s\n", $1, $2, $3}' inputfile > outputfile

(or %-30s if you want them left-justified)

EDIT: A ksh solution:
Code:
while IFS=, read aa bb cc
do
   printf "%30s%30s%30s\n" $1 $2 $3
done < inputfile > outputfile


Last edited by CarloM; 12-02-2011 at 05:13 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to format number/string in ksh

Hi, How to format a number in ksh. For example x=RANDOM $$ I want x to be of 20 digits long, so if x = 12345 I want it to be left paded with 15 zeros. Thanks. (2 Replies)
Discussion started by: GNMIKE
2 Replies

2. Shell Programming and Scripting

format decimal in ksh

hi all, in ksh, how do i format a decimal number (e.g 3381.19) to integer (e.g 3381). This number is average time response for server in millisec and i wanted to display it in a more readable format i.e in seconds without any decimals. thanks in advance. (2 Replies)
Discussion started by: cesarNZ
2 Replies

3. Shell Programming and Scripting

String format in KSH script

Hello, I am attempting to format the output of my unix ksh script. Currently looks like ... FTP TO HR : Down FTP FROM HR 4011a : Up FTP FROM HR 4019a : Down FTP FROM HR : Down Would like the status to be aligned as follows: ... (4 Replies)
Discussion started by: dvella
4 Replies

4. UNIX for Dummies Questions & Answers

Converting binary file to readable format in Ksh

In Unix/Ksh, when I try to look inside a file it says that the file may be a binary file and if I want to see it anyway. When i say 'yes', it shows me the content filled with unreadable symbols (looks like binary). Is there a command that I can run from the Unix prompt to convert/translate that... (3 Replies)
Discussion started by: arthurs
3 Replies

5. Shell Programming and Scripting

How to format sql result as amount - ksh

I am currently returning an sql result with a number value that I want to format as an amount. The sql runs smoothly on its own, but when run inside my ksh script an error is encountered: ERROR at line 3: ORA-01481: invalid number format model My sql is -- select distinct ... (6 Replies)
Discussion started by: avillanueva
6 Replies

6. Shell Programming and Scripting

change output format using ksh

I have a script that reaches out to several systems and pulls back infomation in serveral files. I would like to take the infomation returned and reformat it so I can export it to excel. Below is current output: File1:item1:abc=1 File1:item2:efg File2:item1:ab=1 File2:item2:efg... (3 Replies)
Discussion started by: oldman2
3 Replies

7. Shell Programming and Scripting

Read format problem in ksh script

I have ksh script reading file like while read -r line do echo $line sleep 1 #process_file $line done<$file_nm I want to write this line to another file after some manuplation.Put $line giving me line after changing line format(space removed).Please help me how can i read line by... (3 Replies)
Discussion started by: Mandeep
3 Replies

8. Shell Programming and Scripting

ksh scripting- array format

Hi Everyone, I have a ksh script that queries a database. The query output looks like this: $queryResult = echo ${queryResult} = name1 echo ${queryResult} = age1 echo ${queryResult} = name2 echo ${queryResult} = age2 ... I need to insert those values into a new array that would... (2 Replies)
Discussion started by: practitioner
2 Replies

9. UNIX for Dummies Questions & Answers

Covert textfile to pdf format in ksh UNIX

Dear Friends, Is there anyway we can convert the textfile to pdf file. I have used mv a.txt a.pdf command but dont able open the file in pdf. Plz advice . (2 Replies)
Discussion started by: i150371485
2 Replies

10. Shell Programming and Scripting

Need to filter string between specific string in ksh

My argument has data as below. 10.9.9.85 -rwxr-xr-x user1 2019-10-15 17:40 /app/scripts/testingscr5.scr 127869538 -rwxr-xr-x user1 2019-10-15 17:40 /app/scripts/testingscr56scr 127869538 ....... (note all these between lines will start with hyphen '-' ) -rwxr-xr-x user1 2019-10-15 17:40... (3 Replies)
Discussion started by: mohtashims
3 Replies
CUBRID_PCONNECT(3)							 1							CUBRID_PCONNECT(3)

cubrid_pconnect - Open a persistent connection to a CUBRID server

SYNOPSIS
resource cubrid_pconnect (string $host, int $port, string $dbname, [string $userid], [string $passwd]) DESCRIPTION
Establishes a persistent connection to a CUBRID server. cubrid_pconnect(3) acts very much like cubrid_connect(3) with two major differences. First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, port, dbname and userid. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (cubrid_close(3) or cubrid_disconnect(3) will not close links established by cubrid_pconnect(3)). This type of link is therefore called 'persistent'. PARAMETERS
o $host -Host name or IP address of CUBRID CAS server. o $port -Port number of CUBRID CAS server (BROKER_PORT configured in $CUBRID/conf/cubrid_broker.conf). o $dbname -Name of database. o $userid -User name for the database. o $passwd -User password. RETURN VALUES
Connection identifier, when process is successful. FALSE, when process is unsuccessful. EXAMPLES
Example #1 cubrid_connect(3) example <?php printf("%-30s %s ", "CUBRID PHP Version:", cubrid_version()); printf(" "); $conn = cubrid_pconnect("localhost", 33000, "demodb", "dba"); if (!$conn) { die('Connect Error ('. cubrid_error_code() .')' . cubrid_error_msg()); } $db_params = cubrid_get_db_parameter($conn); while (list($param_name, $param_value) = each($db_params)) { printf("%-30s %s ", $param_name, $param_value); } printf(" "); $server_info = cubrid_get_server_info($conn); $client_info = cubrid_get_client_info(); printf("%-30s %s ", "Server Info:", $server_info); printf("%-30s %s ", "Client Info:", $client_info); printf(" "); $charset = cubrid_get_charset($conn); printf("%-30s %s ", "CUBRID Charset:", $charset); cubrid_disconnect($conn); ?> The above example will output: CUBRID PHP Version: 9.1.0.0001 PARAM_ISOLATION_LEVEL 3 LOCK_TIMEOUT -1 MAX_STRING_LENGTH 1073741823 PARAM_AUTO_COMMIT 1 Server Info: 9.1.0.0212 Client Info: 9.1.0 CUBRID Charset: iso8859-1 SEE ALSO
cubrid_connect(3), cubrid_connect_with_url(3), cubrid_pconnect_with_url(3), cubrid_disconnect(3), cubrid_close(3). PHP Documentation Group CUBRID_PCONNECT(3)
All times are GMT -4. The time now is 08:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy