Sponsored Content
Full Discussion: Columns to rows
Top Forums UNIX for Beginners Questions & Answers Columns to rows Post 303040660 by Roopensingh on Sunday 3rd of November 2019 01:49:18 PM
Old 11-03-2019
Syntax error

Thank you RudiC why does it throw error what am I missing in this.
Code:
[root@sandbox-hdp test]# awk -F, ' NR < 6 {PRFX = PRFX DL $2 DL = FS T[NR] = $0 next } NR == 6 {for (i=1; i<6; i++) print PRFX, T[i] } {print PRFX, $0 } ' OFS=, fil1.csv                                                                 
awk: cmd. line:1:  NR < 6 {PRFX = PRFX DL $2 DL = FS T[NR] = $0 next } NR == 6 {for (i=1; i<6; i++) print PRFX, T[i] } {print PRFX, $0 }                                                                                                  
awk: cmd. line:1:                               ^ syntax error                                                                                                                                                                            
awk: cmd. line:1:  NR < 6 {PRFX = PRFX DL $2 DL = FS T[NR] = $0 next } NR == 6 {for (i=1; i<6; i++) print PRFX, T[i] } {print PRFX, $0 }                                                                                                  
awk: cmd. line:1:                                          ^ syntax error

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

# of rows and columns

Hi, Does anyone know the command to know the # of rows and columns for a file? thanks (3 Replies)
Discussion started by: kylle345
3 Replies

2. Shell Programming and Scripting

Columns into rows

Hi, Let me know how to achieve the below requirment Input: ======== BEGIN DSSUBRECORD Name "DOC_NO_2" SqlType "-5" Precision "0" Scale "0" Nullable "0" END DSSUBRECORD BEGIN DSSUBRECORD Name "FROM_LOC" ... (1 Reply)
Discussion started by: Ramya_1104
1 Replies

3. Shell Programming and Scripting

Rows into columns?

I have a file thats space delimited that looks something like this: Joe Smith jsmith 43234 bill1;bill2;read;read2;schedule Andy Summers asummers 11232 bill1;read Beth McConnel bmconnel 43443 read;read2;schedule;bill Susan Fowler sfowler 09332 bill1;read;schedule I need to... (8 Replies)
Discussion started by: regexnub
8 Replies

4. Shell Programming and Scripting

rows to columns

Hi Friends, I have a input file as below. how to convert rows to columns? Friday:recharge 3861140 Monday:recharge 4036228 Saturday:recharge 3996376 Sunday:recharge 3777749 Thursday:recharge 3858537 Tuesday:recharge 4047045 Wednesday:recharge 3954798 desinred output Sunday ... (3 Replies)
Discussion started by: suresh3566
3 Replies

5. Shell Programming and Scripting

Rows into Columns

Input File vCenter Servers: 172.28.173.207: vCenter Server connectivity status: Accessible ESX servers: Name: nyp-vhst1001-at.hq.nt.life.com IP address: 10.34.36.11 Virtual machines: Name:nyp-bbmds-at Ip address: 172.28.173.139 ... (1 Reply)
Discussion started by: greycells
1 Replies

6. Shell Programming and Scripting

Rows to Columns

Hi Guru's, I have a requirement where i need to convert rows to column based on a key column. Input: Account_id|Trip_Org|Trip_Dest|City|Hotel_Nm 123|DFW|CHI|Dallas|Hyatt 123|LAS|LPA|Vegas|Hyatt Palace Output:... (6 Replies)
Discussion started by: rakesh5300
6 Replies

7. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

8. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies

9. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

10. Shell Programming and Scripting

Rows to columns

Hi, I have a text file with records as below Service Contract: Account Type: Client Number: Group Number: Account Currency: I want to print 2nd,3rd and 5th as a separate column, like -> Account Type: ,Client Number: ,Account Currency: How can I do that? (1 Reply)
Discussion started by: dsid
1 Replies
RUNKIT_SANDBOX(3)							 1							 RUNKIT_SANDBOX(3)

Runkit_Sandbox - Runkit Sandbox Class -- PHP Virtual Machine

	Instantiating  the  Runkit_Sandbox  class  creates a new thread with its own scope and program stack. Using a set of options passed to the
       constructor, this environment may be restricted to a subset of what the primary interpreter can do and provide a safer environment for exe-
       cuting user supplied code.

       Note

	      Sandbox  support	(required for runkit_lint(3), runkit_lint_file(3), and the Runkit_Sandbox class) is only available as of PHP 5.1.0
	      or specially patched versions of PHP 5.0, and requires that thread safety be enabled. See the README file  included  in  the  runkit
	      package for more information.

SYNOPSIS
void Runkit_Sandbox::__construct ([array $options]) DESCRIPTION
CONSTRUCTOR
$options is an associative array containing any combination of the special ini options listed below. o $safe_mode - If the outer script which is instantiating the Runkit_Sandbox class is configured with safe_mode = off, then safe_mode may be turned on for the sandbox environment. This setting can not be used to disable safe_mode when it's already enabled in the outer script. o $safe_mode_gid - If the outer script which is instantiating the Runkit_Sandbox class is configured with safe_mode_gid = on, then safe_mode_gid may be turned off for the sandbox environment. This setting can not be used to enable safe_mode_gid when it's already disabled in the outer script. o $safe_mode_include_dir - If the outer script which is instantiating the Runkit_Sandbox class is configured with a safe_mode_include_dir, then a new safe_mode_include_dir may be set for sandbox environments below the currently defined value. safe_mode_include_dir may also be cleared to indicate that the bypass feature is disabled. If safe_mode_include_dir was blank in the outer script, but safe_mode was not enabled, then any arbitrary safe_mode_include_dir may be set while turning safe_mode on. o $open_basedir -$open_basedir may be set to any path below the current setting of open_basedir. If open_basedir is not set within the global scope, then it is assumed to be the root directory and may be set to any location. o $allow_url_fopen - Like $safe_mode, this setting can only be made more restrictive, in this case by setting it to FALSE when it is previously set to TRUE o $disable_functions - Comma separated list of functions to disable within the sandbox sub-interpreter. This list need not contain the names of the currently disabled functions, they will remain disabled whether listed here or not. o $disable_classes - Comma separated list of classes to disable within the sandbox sub-interpreter. This list need not contain the names of the cur- rently disabled classes, they will remain disabled whether listed here or not. o $runkit.superglobal - Comma separated list of variables to be treated as superglobals within the sandbox sub-interpreter. These variables will be used in addition to any variables defined internally or through the global runkit.superglobal setting. o $runkit.internal_override - Ini option runkit.internal_override may be disabled (but not re-enabled) within sandboxes. Example #1 Instantiating a restricted sandbox <?php $options = array( 'safe_mode'=>true, 'open_basedir'=>'/var/www/users/jdoe/', 'allow_url_fopen'=>'false', 'disable_functions'=>'exec,shell_exec,passthru,system', 'disable_classes'=>'myAppClass'); $sandbox = new Runkit_Sandbox($options); /* Non-protected ini settings may set normally */ $sandbox->ini_set('html_errors',true); ?> ACCESSING VARIABLES
All variables in the global scope of the sandbox environment are accessible as properties of the sandbox object. The first thing to note is that because of the way memory between these two threads is managed, object and resource variables can not currently be exchanged between interpreters. Additionally, all arrays are deep copied and any references will be lost. This also means that references between interpreters are not possible. Example #2 Working with variables in a sandbox <?php $sandbox = new Runkit_Sandbox(); $sandbox->foo = 'bar'; $sandbox->eval('echo "$foo "; $bar = $foo . "baz";'); echo "{$sandbox->bar} "; if (isset($sandbox->foo)) unset($sandbox->foo); $sandbox->eval('var_dump(isset($foo));'); ?> The above example will output: bar barbaz bool(false) CALLING PHP FUNCTIONS
Any function defined within the sandbox may be called as a method on the sandbox object. This also includes a few pseudo-function language constructs: eval(3), include(3), include_once(3), require(3), require_once(3), echo(3), print(3), die(3), and exit(3). Example #3 Calling sandbox functions <?php $sandbox = new Runkit_Sandbox(); echo $sandbox->str_replace('a','f','abc'); ?> The above example will output: fbc When passing arguments to a sandbox function, the arguments are taken from the outer instance of PHP. If you wish to pass arguments from the sandbox's scope, be sure to access them as properties of the sandbox object as illustrated above. Example #4 Passing arguments to sandbox functions <?php $sandbox = new Runkit_Sandbox(); $foo = 'bar'; $sandbox->foo = 'baz'; echo $sandbox->str_replace('a',$foo,'a'); echo $sandbox->str_replace('a',$sandbox->foo,'a'); ?> The above example will output: bar baz CHANGING SANDBOX SETTINGS
As of runkit version 0.5, certain Sandbox settings may be modified on the fly using ArrayAccess syntax. Some settings, such as $active are read-only and meant to provide status information. Other settings, such as $output_handler may be set and read much like a normal array offset. Future settings may be write-only, however no such settings currently exist. Sandbox Settings / Status Indicators PHP Documentation Group RUNKIT_SANDBOX(3)
All times are GMT -4. The time now is 05:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy