10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies
2. Shell Programming and Scripting
Hi,
I have a requirement that has 50-60 million records that we need to split a delimited string (Delimeter is newline) into rows.
Source Date:
SerialID UnidID GENRE
100 A11 AAAchar(10)BBB
200 B11 CCCchar(10)DDD(10)ZZZZ
Field 'GENRE' is a string with new line as delimeter and not sure... (5 Replies)
Discussion started by: techmoris
5 Replies
3. Shell Programming and Scripting
Hello,
I have some tab delimited text data that I am processing. The second column looks like,
NAME;pyrimidine-2,4-diol;cpd;2;line;37
I need to clean this up to just the name,
pyrimidine-2,4-diol
All lines have the same format,
NAME;text;cpd;int;line;int followed by tab
I have tried... (6 Replies)
Discussion started by: LMHmedchem
6 Replies
4. Shell Programming and Scripting
I have a unix file text.txt with below content
aaaaa
bbbbbbb
cccccccccc
As of 2013
ddddddddd
eeeeeeeeee
eeeeeeeee
fffffffff
As of 2014
gggggggggggg
hhhhhhhhh
iiiiiiiiiiiiiiii
As of 2016
Now I've to split this file with each file ending with line 'As of' . Please suggest how can I do... (6 Replies)
Discussion started by: Steven77
6 Replies
5. Shell Programming and Scripting
Hi,
I have a very long pipe delimited string. The length of the string could vary. For example:
START|one|two|three|four|five|six|seven
START|one|two|three|four|five|six|seven|eight|nine
START|one|two|three|four
I want to replace in the third occurence of string with another... (9 Replies)
Discussion started by: som.nitk
9 Replies
6. Shell Programming and Scripting
Hi
I have a text file called 'fileA' which contains the follwoing line examples
01:rec1:25,50,75,100
02:rec2:30,60
03:rec3:20,40
I would like to create a new file where each of the comma separated values appears on a new line but prefixed with the first two fields e.g.
01:rec1:25... (3 Replies)
Discussion started by: mackmb
3 Replies
7. Shell Programming and Scripting
Hi
I am trying to figure out the best way to search a long log file and print out certain information.
For example if I had a line in a log file delimited by ampersand
first_name=mike&last_name=smith&zip_code=55555&phone=555-5555&state=ma&city=boston
and I only wanted to search for and... (3 Replies)
Discussion started by: mstefaniak
3 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I'm looking for one liner code for counting number of words in a delimited string..
I know about wc -w ..but if i give wc -w a.txt,b.txt it won't work with delimited sting as it was looking for files with a.txt and b.txt
I know there will be a simple solution..i couldn't... (5 Replies)
Discussion started by: ammu
5 Replies
9. Shell Programming and Scripting
#! /bin/csh
set delimiter = |
foreach i (*)
set str_deli="$i$delimiter"
question: how to retain the value of str_deli so i can build a pipe delimited string?
end (1 Reply)
Discussion started by: jdsignature88
1 Replies
10. Shell Programming and Scripting
I have a string as follows
IS*blahblah
TED~blahblah
etc.
I want to list down only IS and TED
Can someone help me? (24 Replies)
Discussion started by: kumariak
24 Replies