Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need HELP with AWK split. Need to check for "special characters" in string before splitting the file
Top Forums Shell Programming and Scripting Need HELP with AWK split. Need to check for "special characters" in string before splitting the file Post 302679001 by shell_boy23 on Monday 30th of July 2012 06:29:28 AM
Old 07-30-2012
Sorry, Klashxx.
It gives the same output.

Code:
$ cat samp.txt
1,abc,def,1234,A *
2,bed,dec,342,* A
3,dec,345,23,*&^
4,sdf,fgh,234,
5,ert,345,ghj,C*2
6,ert,345,sdf,123

$ awk -F, '{if ($NF ~ /[0-9]$|[A-Za-z]$/) {print >"goodfile"} else {print >"badfile" }}' samp.txt

$ cat goodfile
2,bed,dec,342,* A
5,ert,345,ghj,C*2
6,ert,345,sdf,123

$ cat badfile
1,abc,def,1234,A *
3,dec,345,23,*&^
4,sdf,fgh,234,

---------- Post updated at 05:29 AM ---------- Previous update was at 05:28 AM ----------

I'm using korn shell. Maybe that makes a difference .??
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

split the string "Setview: arv-temp-view"

Hi experts, I would like to split the value of v and assign "arv-temp-view" to another variable d. I want to do it within shell script. My shell is "tcsh" v="Setview: arv-temp-view" split v and store d=arv-temp-view Please help Thanks Amit (2 Replies)
Discussion started by: amitrajvarma
2 Replies

2. UNIX for Dummies Questions & Answers

perl split funciton - special character "/"

HI, I have a directory structure. /abc/def/ghi/ I want to store it into array. So that if I do a pop function on that array I can easily go to previous directory. But how can i split and store it. @Directory = split(/\//,$DirectoryVarialbe) That doest works. Any other escape sequence... (5 Replies)
Discussion started by: deepakwins
5 Replies

3. Shell Programming and Scripting

how to split special characters "|" using awk

Hi friends I need to splict special character "|" here. Here is my script which giving error LINE=INVTRAN|cd /home/msgGoogle TraxFolderType=`awk -F"|" '{print $1}' $LINE` filePath=`awk -F"|" '{print $2}' $LINE` echo "TraxFolderType: "$TraxFolderType echo "filePath :"$filePath ... (3 Replies)
Discussion started by: krishna9
3 Replies

4. Shell Programming and Scripting

"sed" to check file size & echo " " to destination file

Hi, I've modified the syslogd source to include a thread that will keep track of a timer(or a timer thread). My intention is to check the file size of /var/log/messages in every one minute & if the size is more than 128KB, do a echo " " > /var/log/messages, so that the file size will be set... (7 Replies)
Discussion started by: jockey007
7 Replies

5. Shell Programming and Scripting

Splitting text string with "|" pipe delimiters

Hi, I need to split the fields in some text strings into separate variables. The fields are separated by pipes. The strings look roughly like this: CUSTNAME|hostname|userid|gecos field|staff|disabled||SUDO Currently I can do it using something like cut -d"|" -f1, but when I put that into... (4 Replies)
Discussion started by: alanp36
4 Replies

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

7. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

8. Shell Programming and Scripting

finding the strings beween 2 characters "/" & "/" in .txt file

Hi all. I have a .txt file that I need to sort it My file is like: 1- 88 chain0 MASTER (FF-TE) FFFF 1962510 /TCK T FD2TQHVTT1 /jtagc/jtag_instreg/updateinstr_reg_1 dff1 (TI,SO) 2- ... (10 Replies)
Discussion started by: Behrouzx77
10 Replies

9. UNIX for Dummies Questions & Answers

PuTTY displaying "special" characters

I'm not really sure which forum this question should go into, so I'm posting it here. I work with AIX and RHEL systems using PuTTY (Release 0.60_q1.129) from a Windows 7 workstation. Some of the files we get from z/OS use "special" characters as delimiters. These characters include Hex 18... (7 Replies)
Discussion started by: derndingle
7 Replies

10. Shell Programming and Scripting

Unable to identify the special characters beyond the range of "[\x80-\xFF]"

I want to filter out the special character whose ascii value doesn't fall within the range "" . Example:� or Ć. So in that case is there any defined range which will filter out this characters. I can filter those which falls withing "" . Need to filter those special chracter which doesn't... (14 Replies)
Discussion started by: Abhijit Sen
14 Replies

LEARN ABOUT SUNOS

iconv_pc_cyr

iconv_pc_cyr(5) 					Standards, Environments, and Macros					   iconv_pc_cyr(5)

NAME

       iconv_pc_cyr - code set conversion tables for Alternative PC Cyrillic

DESCRIPTION

       The following code set conversions are supported:

       +---------------------------------------------------------------------+
       |		   Code Set Conversions Supported		     |
       +--------------+--------+--------------+--------+---------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |    Target Output    |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |KOI8-R	      |koi8    | KOI8-R 	     |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |MS 1251       |win5    | Windows Cyrillic    |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |Mac Cyrillic  |mac     | Macintosh Cyrillic  |
       +--------------+--------+--------------+--------+---------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   PC Cyrillic to ISO 8859-5
       For the conversion of PC Cyrillic to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   |  ISO 8859-5	| PC Cyrillic	 |  ISO 8859-5	 |
       |24	       | 4		|231		 |311		 |
       |200	       | 260		|232		 |312		 |
       |201	       | 261		|233		 |313		 |
       |202	       | 262		|234		 |314		 |
       |203	       | 263		|235		 |315		 |
       |204	       | 264		|236		 |316		 |
       |205	       | 265		|237		 |317		 |
       |206	       | 266		|240		 |320		 |
       |207	       | 267		|241		 |321		 |
       |210	       | 270		|242		 |322		 |
       |211	       | 271		|243		 |323		 |
       |212	       | 272		|244		 |324		 |
       |213	       | 273		|245		 |325		 |
       |214	       | 274		|246		 |326		 |
       |215	       | 275		|247		 |327		 |
       |216	       | 276		|250		 |330		 |
       |217	       | 277		|251		 |331		 |
       |220	       | 300		|252		 |332		 |
       |221	       | 301		|253		 |333		 |
       |222	       | 302		|254		 |334		 |
       |223	       | 303		|255		 |335		 |
       |224	       | 304		|256		 |336		 |
       |225	       | 305		|257		 |337		 |
       |226	       | 306		|260-337	 |255		 |
       |227	       | 307		|360		 |241		 |
       |230	       | 310		|362-376	 |255		 |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to KOI8-R
       For the conversion of PC Cyrillic to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   |    KOI8-R	| PC Cyrillic	 |    KOI8-R	 |
       |24	       | 4		|242		 |327		 |
       |200	       | 341		|243		 |307		 |
       |201	       | 342		|244		 |304		 |
       |202	       | 367		|245		 |305		 |
       |203	       | 347		|246		 |326		 |
       |204	       | 344		|247		 |332		 |
       |205	       | 345		|250		 |311		 |
       |206	       | 366		|251		 |312		 |
       |207	       | 372		|252		 |313		 |
       |210	       | 351		|253		 |314		 |
       |211	       | 352		|254		 |315		 |
       |212	       | 353		|255		 |316		 |
       |213	       | 354		|256		 |317		 |
       |214	       | 355		|257		 |320		 |
       |215	       | 356		|260-337	 |255		 |
       |216	       | 357		|340		 |322		 |
       |217	       | 360		|341		 |323		 |
       |220	       | 362		|342		 |324		 |
       |221	       | 363		|343		 |325		 |
       |222	       | 364		|344		 |306		 |
       |223	       | 365		|345		 |310		 |
       |224	       | 346		|346		 |303		 |
       |225	       | 350		|347		 |336		 |
       |226	       | 343		|350		 |333		 |
       |227	       | 376		|351		 |335		 |
       |230	       | 373		|352		 |337		 |
       |231	       | 375		|353		 |331		 |
       |232	       | 377		|354		 |330		 |
       |233	       | 371		|355		 |334		 |
       |234	       | 370		|356		 |300		 |
       |235	       | 374		|357		 |321		 |
       |236	       | 340		|360		 |263		 |
       |237	       | 361		|361		 |243		 |
       |240	       | 301		|362-376	 |255		 |
       |241	       | 302		|		 |		 |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to MS 1251
       For the conversion of PC Cyrillic to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   |    MS 1251	| PC Cyrillic	 |   MS 1251	 |
       |24	       | 4		|242		 |342		 |
       |200	       | 300		|243		 |343		 |
       |201	       | 301		|244		 |344		 |
       |202	       | 302		|245		 |345		 |
       |203	       | 303		|246		 |346		 |
       |204	       | 304		|247		 |347		 |
       |205	       | 305		|250		 |350		 |
       |206	       | 306		|251		 |351		 |
       |207	       | 307		|252		 |352		 |
       |210	       | 310		|253		 |353		 |
       |211	       | 311		|254		 |354		 |
       |212	       | 312		|255		 |355		 |
       |213	       | 313		|256		 |356		 |
       |214	       | 314		|257		 |357		 |
       |215	       | 315		|260-337	 |210		 |
       |216	       | 316		|340		 |360		 |
       |217	       | 317		|341		 |361		 |
       |220	       | 320		|342		 |362		 |
       |221	       | 321		|343		 |363		 |
       |222	       | 322		|344		 |364		 |
       |223	       | 323		|345		 |365		 |
       |224	       | 324		|346		 |366		 |
       |225	       | 325		|347		 |367		 |
       |226	       | 326		|350		 |370		 |
       |227	       | 327		|351		 |371		 |
       |230	       | 330		|352		 |372		 |
       |231	       | 331		|353		 |373		 |
       |232	       | 332		|354		 |374		 |
       |233	       | 333		|355		 |375		 |
       |234	       | 334		|356		 |376		 |
       |235	       | 335		|357		 |377		 |
       |236	       | 336		|360		 |250		 |
       |237	       | 337		|361		 |270		 |
       |240	       | 340		|362-376	 |210		 |
       |241	       | 341		|		 |		 |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to Mac Cyrillic
       For the conversion of PC Cyrillic to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   | Mac Cyrillic	| PC Cyrillic	 | Mac Cyrillic  |
       |24	       | 4		|341		 |361		 |
       |240	       | 340		|342		 |362		 |
       |241	       | 341		|343		 |363		 |
       |242	       | 342		|344		 |364		 |
       |243	       | 343		|345		 |365		 |
       |244	       | 344		|346		 |366		 |
       |245	       | 345		|347		 |367		 |
       |246	       | 346		|350		 |370		 |
       |247	       | 347		|351		 |371		 |
       |250	       | 350		|352		 |372		 |
       |251	       | 351		|353		 |373		 |
       |252	       | 352		|354		 |374		 |
       |253	       | 353		|355		 |375		 |
       |254	       | 354		|356		 |376		 |
       |255	       | 355		|357		 |337		 |
       |256	       | 356		|360		 |335		 |
       |257	       | 357		|361		 |336		 |
       |260-337        | 40		|362-376	 |40		 |
       |340	       | 360		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						   iconv_pc_cyr(5)
All times are GMT -4. The time now is 09:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy