The file should have 4 fields to load into a database. The file may have cr, lf, or end of line characters.
What I want to see as output is
Code:
1|2|3|4
a|b|c|d
1|23|4
a|b|c|d
I have tried
Code:
BEGIN {FS="|";break_flag = 0;field_count=4}
{
#print NF
delc=gsub(/\|/,"|",$0)
print delc
if (NF == 4 )
{
print $0
}
else if (delc != 3)
{
#gsub("\"","")
gsub(/\r/,"")
printf("%s|",$0)
}
}
What I want is that if the line does not have 4 fields, continue reading until you get 4 fields and print them without cr, lf etc only | as the field separator
Thanks,
Tim
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by vgersh99; 12-04-2013 at 01:39 PM..
Reason: code tags, please!
Hi,
I have a file namely 'inputs' The values inside the file are like this and seperated by a '|'.
mani|21|CSE
How can I extract the values from this file without the '|' symbol.
Thanks in advance. (1 Reply)
I need some assistance, I am writing a script in bash.
I want to do two things:
1/. I want to replace the LF at the end of the RFH Ø ¸MQSTR ¸ so I can process the file record by record using a while loop.
2/. I want to extract two fields from each record, they are identified with... (1 Reply)
Dear All
I have a file like this
112534554
446538656
444695656
225696966
226569744
228787874
113536566
443533535
222564552
115464656
225445345
225533234
I want to cut the file into different parts where the first two columns are '11' . The first two columns will be either... (3 Replies)
Is there any way to print all the string till we get a space and a number and store it a variable
for eg we have string java.io.IOException: An existing connection was forcibly closed by the remote host 12
All I want is to store "java.io.IOException: An existing connection was forcibly closed... (13 Replies)
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Hi Gurus,
Have a file seperated by "~" and no of fields is 104. When i try to run awk, it erros out.
awk: record `B~A31~T24_STF~~~2009...' has too many fields
Any idea how can i extract a specific filed with this many fields in a row.
Kindly help (3 Replies)
Hi
I was going through the below thread
https://www.unix.com/shell-programming-scripting/48535-how-count-number-fields-record.html
I too have something similar requirement as specified in this thread but the number of columns in my case can be very high, so I am getting following error.
... (3 Replies)
Hi All,
I have a file as below:
abc.txt
******************************
* HEADER DESCRIPTION
******************************
*Supplier: Prism
Customer: MNI -NIGERIA
Quantity: 2
Type: PLUG-IN
Profile: 70.00
*Subscription: Generic... (5 Replies)
Hi,
How to print the number of fields in each record with the line number?
Lets saw I have
3212|shipped|received|
3213|shipped|undelivered|
3214|shipped|received|delivered
I tried the code
awk -F '|' '{print NF}'
This gives me ouput as
3
3
4 (5 Replies)
Hi,
Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account.
$ head -500 x.txt y.txt
==> x.txt <==
TEST01 APP_USER_PROFILE
USER03 APP_USER_PROFILE
TEST02 APP_USER_EXP_PROFILE
TEST04 APP_USER_PROFILE
USER01 ... (3 Replies)
Discussion started by: newbie_01
3 Replies
LEARN ABOUT HPUX
setresuid
setresuid(2) System Calls Manual setresuid(2)NAME
setresuid, setresgid - set real, effective, and saved user and group IDs
SYNOPSIS DESCRIPTION
sets the real, effective and/or saved user ID of the calling process.
If the current real, effective or saved user ID is equal to that of a user having appropriate privileges, sets the real, effective and
saved user IDs to ruid, euid, and suid, respectively. Otherwise, only sets the real, effective, and saved user IDs if ruid, euid, and suid
each match at least one of the current real, effective, or saved user IDs.
If ruid, euid, or suid is leaves the current real, effective or saved user ID unchanged.
sets the real, effective and/or saved group ID of the calling process.
If the current real, effective or saved user ID is equal to that of a user having appropriate privileges, sets the real, effective, and
saved group ID to rgid, egid, and sgid, respectively. Otherwise, only sets the real, effective and saved group ID if rgid, egid, and sgid
each match at least one of the current real, effective or saved group ID.
If rgid, egid, or sgid is leaves the current real, effective or saved group ID unchanged.
Security Restrictions
Some or all of the actions associated with this system call require the privilege (CHSUBJIDENT). Processes owned by the superuser will
have this privilege. Processes owned by other users may have this privilege, depending on system configuration.
See privileges(5) for more information about privileged access on systems that support fine-grained privileges.
RETURN VALUE
Upon successful completion, and return 0; otherwise, they return -1 and set to indicate the error.
ERRORS
and fail if any of the following conditions are encountered:
ruid, euid, or suid (rgid, egid, or sgid) is not a valid user (group) ID.
None of the conditions above are met.
AUTHOR
and were developed by HP.
SEE ALSO exec(2), getuid(2), setuid(2), privileges(5).
setresuid(2)
12-04-2013
