Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to call a string by string from a file to use in for loop?
Top Forums Shell Programming and Scripting How to call a string by string from a file to use in for loop? Post 303003831 by zaxxon on Thursday 21st of September 2017 07:50:20 AM
Old 09-21-2017
Else you could do something like this:
Code:
awk -v q=\' '
{
     s ? s=s ORS q $0 q : s=q $0 q
}
END{
     printf("select * from table where name in (%s);\n", s)
}
' ORS=, infile

Output:
Code:
select * from table where name in ('3" - 11" DCBA-1234','5"-8" ABC MNOP-3765','8"-16" LMNOP ABCD-0302','ABC XYZ JKLM-1212','XYZ-1673');

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

search string in a file and retrieve 10 lines including string line

Hi Guys, I am trying to write a perl script to search a string "Name" in the file "FILE" and also want to create a new file and push the searched string Name line along with 10 lines following the same. can anyone of you please let me know how to go about it ? (8 Replies)
Discussion started by: sukrish
8 Replies

2. Shell Programming and Scripting

replace (sed?) a single line/string in file with multiple lines (string) from another file??

Can someone tell me how I can do this? e.g: Say file1.txt contains: today is monday the 22 of NOVEMBER 2010 and file2.txt contains: the 11th month of How do i replace the word NOVEMBER with (5 Replies)
Discussion started by: tuathan
5 Replies

3. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies

4. Shell Programming and Scripting

grep exact string from files and write to filename when string present in file

I am attempting to grep an exact string from a series of files within a directory and append that output to the filename when it is present in the file. I've been after this all day with no luck. Thanks for your help in advance :wall:. (4 Replies)
Discussion started by: JC_1
4 Replies

5. Shell Programming and Scripting

Recursive search for string in file with Loop condition

Hi, Need some help... I want to execute sequence commands, like below test1.sh test2.sh ...etc test1.sh file will generate log file, we need to search for 'complete' string on test1.sh file, once that condition success and then it should go to test2.sh file, each .sh scripts will take... (5 Replies)
Discussion started by: rkrish123
5 Replies

6. Shell Programming and Scripting

Search a string in a text file and add another string at the particular position of a line

I am having a text file which is having more than 200 lines. EX: 001010122 12000 BIB 12000 11200 1200003 001010122 2000 AND 12000 11200 1200003 001010122 12000 KVB 12000 11200 1200003 In the above file i want to search for string KVB and add/replace... (1 Reply)
Discussion started by: suryanarayana
1 Replies

7. Shell Programming and Scripting

Search a string in a text file and add another string at the end of line

Dear All I am having a text file which is having more than 200 lines. EX: 001010122 12000 BIB 12000 11200 1200003 001010122 2000 AND 12000 11200 1200003 001010122 12000 KVB 12000 11200 1200003 In the above file i want to search for string KVB... (5 Replies)
Discussion started by: suryanarayana
5 Replies

8. UNIX for Beginners Questions & Answers

Search a string and display its location on the entire string and make a text file

I want to search a small string in a large string and find the locations of the string. For this I used grep "string" -ob <file name where the large string is stored>. Now this gives me the locations of that string. Now how do I store these locations in a text file. Please use CODE tags as... (7 Replies)
Discussion started by: ANKIT ROY
7 Replies

9. Shell Programming and Scripting

Use while loop to read file and use ${file} for both filename input into awk and as string to print

I have files named with different prefixes. From each I want to extract the first line containing a specific string, and then print that line along with the prefix. I've tried to do this with a while loop, but instead of printing the prefix I print the first line of the file twice. Files:... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

10. Shell Programming and Scripting

Replace string of a file with a string of another file for matches using grep,sed,awk

I have a file comp.pkglist which mention package version and release . In 'version change' and 'release change' line there are two versions 'old' and 'new' Version Change: --> Release Change: --> cat comp.pkglist Package list: nss-util-devel-3.28.4-1.el6_9.x86_64 Version Change: 3.28.4 -->... (1 Reply)
Discussion started by: Paras Pandey
1 Replies

LEARN ABOUT DEBIAN

tokens

TOKENS(1)						       AFS Command Reference							 TOKENS(1)

NAME

       tokens, tokens.krb - Displays the issuer's tokens

SYNOPSIS

       tokens [-help]

       tokens [-h]

       tokens.krb [-help]

       tokens.krb [-h]

DESCRIPTION

       The tokens command displays all tokens (tickets) cached on the local machine for the issuer. AFS server processes require that their
       clients present a token as evidence that they have authenticated in the server's local cell.

       The (mostly obsolete) tokens.krb command is the same as tokens except that it also displays the user's Kerberos v4 ticket cache.

OPTIONS

       -help
	   Prints the online help for this command. All other valid options are ignored.

OUTPUT

       The output lists one token for each cell in which the user is authenticated. The output indicates the

       o User's AFS UID, if it is available for display.

       o Server for which the token is valid (normally, afs).  This includes a cell specification.

       o Day and time the token expires.

       The output of the Kerberos version of this command, tokens.krb, also reports the following about the Kerberos ticket-granting ticket: the
       ticket owner, which Kerberos ticket-granting service that issued the ticket (for example, "krbtgt.ABC.COM"), and ticket's expiration date.

       The string "--End of list--" appears at the end of the output. If the user is not authenticated in any cell, this line is all that appears.

EXAMPLES

       The following example shows the output when the issuer is not authenticated in any cell.

	  % tokens
	  Tokens held by the Cache Manager:

	     --End of list--

       The following example shows the output when the issuer is authenticated in ABC Corporation cell, where he or she has AFS UID 1000.

	  % tokens
	  Tokens held by the Cache Manager:

	  User's (AFS ID 1000) tokens for afs@abc.com [Expires Jan 2 10:00]
	     --End of list--

       The following example shows the output when the issuer is authenticated in the ABC Corporation cell, the State University cell, and the XYZ
       Company cell. The user has different AFS UIDs in the three cells. Tokens for last cell are expired:

	  % tokens
	  Tokens held by the Cache Manager:

	  User's (AFS ID 1000) tokens for afs@abc.com [Expires Jan 3 10:00]
	  User's (AFS ID 4286) tokens for afs@stateu.edu [Expires Jan 3 1:34]
	  User's (AFS ID 22) tokens for afs@xyz.com [>>Expired<]
	     --End of list--

       The following example shows the output when the issuer uses the tokens.krb version of the command after authenticating in the ABC
       Corporation cell using the klog.krb command.

	  % tokens.krb
	  Tokens held by the Cache Manager:

	  User's (AFS ID 1000) tokens for afs@abc.com [Expires Jan 31 00:09]
	  User smiths tokens for krbtgt.ABC.COM@abc.com [Expires Jan 31 00:09]
	     --End of list--

PRIVILEGE REQUIRED

       None

SEE ALSO

       klog(1), unlog(1)

COPYRIGHT

       IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.

       This documentation is covered by the IBM Public License Version 1.0.  It was converted from HTML to POD by software written by Chas
       Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.

OpenAFS 							    2012-03-26								 TOKENS(1)
All times are GMT -4. The time now is 12:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy