08-10-2010
Franklin52
thanks guys for quick replies.
@Franklin52 : yeah, all Input files are excel files. Its (script provided by you) working fine with " .txt " file but not with excel file, I afraid.
@elbrand : any row value for any column can be empty.
---------- Post updated at 12:44 PM ---------- Previous update was at 12:42 PM ----------
thanks guys for quick replies.
@Franklin52 : yeah, all Input files are excel files. Its (script provided by you) working fine with " .txt " file but not with excel file, I afraid.
@elbrand : any row value for any column can be empty.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Experts,
I need to extract some set of strings one be one using delimiter.
Example:
shellscript.sh|unix.sh|script_file.sh
i need to extract this shellscript.sh,unix.sh,script_file.sh
separately.
I tried but couldn't get. Please help me..
Thanks & Regards :),
Kanda (3 Replies)
Discussion started by: spkandy
3 Replies
2. Shell Programming and Scripting
The typical line of the input file is as follows,
123|abcde|"xyz|mn"|ghelosa|3455hello|
The delimiter is |. I need to change it to another delimiter, say ~. For the above line, the output should be:
123~abcde~xyz|mn~ghelosa~3455hello~
The challenge is when | appears in a field, it... (2 Replies)
Discussion started by: derekxu
2 Replies
3. UNIX for Dummies Questions & Answers
I am trying to extract 'postmaster' from the following string:
PenaltyError:=554 5.7.1 Error, send your mail to postmaster@LOCALDOMAIN
using the following command:
cat /usr/share/assp/assp.cfg | grep ^PenaltyError:= | cut -d '@' -f1 | cut -f8
but it returns:
PenaltyError:=554 5.7.1 Error,... (10 Replies)
Discussion started by: cleanden
10 Replies
4. UNIX for Dummies Questions & Answers
Hello,
Is there a direct command to check if the delimiter in your file is a tab or a space? And how can they be converted from one to another.
Thanks,
G (4 Replies)
Discussion started by: Gussifinknottle
4 Replies
5. Shell Programming and Scripting
I have a file with three fields and field delimiter '|' like:
abc|12:13:45|123
xyz|12:87:32|
qwe|54:21:09
In the file the 1st line has proper data -> abc|12:13:45|123
,the 2nd line doesnt has data for the 3rd field which is okay
, the 3rd line doesnt has data for the 3rd field as well the... (5 Replies)
Discussion started by: mehimadri
5 Replies
6. Shell Programming and Scripting
hi
here my problem:
i have 2 file:
1.tmp
111
222
555
2.tmp
1*TEST1**111*LA
2*TEST2**112*LA
3*TEST3**222*LA
4*TEST4**333*LA
5*TEST5**555*LA (5 Replies)
Discussion started by: saw7
5 Replies
7. Shell Programming and Scripting
I had an immediate work to sort out the error code and error message which are associated within the log. But here im facing an problem to extract 3 different fields from the XML log can some one please help. I tried using different script including awk & nawk, but not getting the desired output.
... (18 Replies)
Discussion started by: raghunsi
18 Replies
8. Shell Programming and Scripting
not sure if i'm doing this right i'm new tho this but i'm trying to use a space as a delimiter with the cut command
my code is
size=$( du -k -S -s /home/cmik | cut -d' ' -f1 )
i've also tried -f2 and switching the -d and -f around if that does anything (3 Replies)
Discussion started by: Cmik
3 Replies
9. Shell Programming and Scripting
Hi ,
Please suggest me how do I use : (colon and one space) as a delimiter in awk
Best regards,
Vishal (2 Replies)
Discussion started by: Vishal_dba
2 Replies
10. Shell Programming and Scripting
We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below.
Current file (file.csv)
----------------------
empname,date_of_join,dept,date_of_resignation
ram,08/09/2015,sales,21/06/2016
"akash,sahu",08/10/2015,IT,21/07/2016
... (6 Replies)
Discussion started by: gopal.biswal
6 Replies
LEARN ABOUT REDHAT
spottopgm
spottopgm(1L) spottopgm(1L)
NAME
spottopgm - convert SPOT satellite images to Portable Greymap format
SYNTAX
spottopgm [-1|2|3] [Firstcol Firstline Lastcol Lastline] inputfile
OPTIONS
-1|2|3 Extract the given colour from the SPOT image. The colours are infra-red, visible light and ultra-violet, although I don't know
which corresponds to which number. If the image is in colour, this will be announced on standard error. The default colour is 1.
Firstcol Firstline Lastcol Lastline
Extract the specified rectangle from the SPOT image. Most SPOT images are 3000 lines long and 3000 or more columns wide. Unfortu-
nately the SPOT format only gives the width and not the length. The width is printed on standard error. The default rectangle is
the width of the input image by 3000 lines.
DESCRIPTION
Spottopgm converts the named inputfile into Portable Greymap format, defaulting to the first color and the whole SPOT image unless speci-
fied by the options.
INSTALLATION
You must edit the source program and either define BIG_ENDIAN or LITTLE_ENDIAN, and fix the typedefs for uint32_t, uint16_t and uint8_t
appropriately.
BUGS
Currently spottopgm doesn't determine the length of the input file; this would involve two passes over the input file. It defaults to 3000
lines instead.
Spottopgm could extract a three-color image (ppm), but I didn't feel like making the program more complicated than it is now. Besides,
there is no one-to-one correspondence between red, green, blue and infra-red, visible and ultra-violet.
I've only had a limited number of SPOT images to play with, and therefore wouldn't guarantee that this will work on any other images.
AUTHOR
Warren Toomey wkt@csadfa.cs.adfa.oz.au
SEE ALSO
The rest of the Pbmplus suite.
spottopgm(1L)