Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Split string after 4000 char

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Split string after 4000 char
# 1  
Old 07-18-2013
Split string after 4000 char
Hi everybody!

I have a large comma separated text file. This file incluede some column which largest than 4000 character(this is not the last column). I tried with sed but i can't do it.

I would like to split to 4000 char this column.

Thank You for your help!

for example:
Quote:
"fdsa","2013-06-26-fdsa","2013-06-26 16:42:11","gfds fsa","1","0","1","0","fdsa","fdsa","voice","fdsa","yes","no","fdsa","fdsa","oo","sa 610, fds","fe4332","321 3212 - 24","","","150 321","","","","","","2013-06-27 09:40:56","10","","321321","","2931","321321<91>","321321","321","6"," fdsa, 1 fsa, 10 AjtĂł","2931","321<91>","fs321","Ăşt","6"," Ă<89>fs, 1 Emelet, 10 AjtĂł","fdsa","AlmĂĄsfĂźzitĹ<91>","Afdady fds","Ăşt","6"," Ă<89>pĂźlet, 1 Emelet, fdsAjtĂł","","","","","","","","","","SzabĂł","fds","Ă<89>rsek MĂĄrta","Szentes","","fdsafdsa. 10. 06","NĹ<91>","magyar","SzemĂŠlyi igazolvĂĄny + LakcĂ*mkĂĄrtya","fs","","fdsa","","","MolnĂĄr Ilona","","","+fdsa","fdsa@fdsa.com","","","0","","","","micro","fdsafsafdsafdsadfsafdsafsafdsafdsad fsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafd safsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsa fdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsaf dsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadf safdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafds afsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsaf dsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafd sadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfs afdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsa fsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafd safdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafds adfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsa fdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsaf safdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafds afdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsa dfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsaf dsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafs afdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsafdsafsafdsafdsadfsa","","","","","","","","",""," ","","","",""
Last edited by snayper; 07-18-2013 at 10:32 AM..
# 2  
Old 07-18-2013
Try using awk:
Code:
awk -F, S=4000 '
        {
                for ( i = 1; i <= NF; i++ )
                {
                        if ( length ( $i ) > S )
                        {
                                $i = substr ( $i, 1, S ) OFS substr ( $i, S + 1 )
                        }
                }
                print
        }
' OFS=, file

# 3  
Old 07-18-2013
Thanks Your answer!

i got this message:
Code:
awk: syntax error near line 1
awk: bailing out near line 1

I'm use solaris(maybe important).
Last edited by Scott; 07-18-2013 at 11:44 AM.. Reason: Code tags
# 4  
Old 07-18-2013
Quote:
Originally Posted by snayper
I'm use solaris(maybe important).
Yes it is. Use nawk instead in solaris.
# 5  
Old 07-18-2013
i pasted into to command line:

Code:
nawk -F, S=4000 '{ for ( i = 1; i <= NF; i++ ) { if ( length ( $i ) > S ) { $i = substr ( $i, 1, S ) OFS substr ( $i, S + 1 ) } } print }' OFS=, textfile.lis

and i got this message now:
Code:
nawk: can't open file { for ( i = 1; i <= NF; i++ ) { if ( length ( $i ) > S ) { $i = substr ( $i, 1, S ) OFS substr ( $i, S + 1 ) } } print }
 source line number 1

Last edited by Scott; 07-18-2013 at 12:26 PM.. Reason: Code tags
# 6  
Old 07-18-2013
Oops. It should be:
Code:
nawk -F, -v S=4000 '

This User Gave Thanks to Yoda For This Post:
snayper
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

C++ Using open on a string instead of char*

I am using ifstream to open a file using std::fstream::open void open ( const char * filename, ios_base::openmode mode = ios_base::in ); However I want to use a string instead of a char* as follows but having a problem on how to do this string val_ifmodl = “fred.modl” ifstream ifs_modl;... (2 Replies)
Discussion started by: kristinu
2 Replies

2. Shell Programming and Scripting

Split a special char

Hello, I have some data in output file.In that i need to split the special char "(" and ")" and store it. This is example of o/p file. (OHC12345) (OHC12415) (OHC12765) (OHC12545) I need like OHC12345 OHC12415 OHC12765 OHC12545 --Thanks (5 Replies)
Discussion started by: rasingraj
5 Replies

3. Programming

PERL \c char in the string

Hi guys, I am stuck up in a situation. I have a SUN box with certain logs which I need to parse to draw a report using Perl. Now, when I load the text file using a perl degugger to see how the text looks like when the first line of the log file is read in a variable. below is the snapshot of... (2 Replies)
Discussion started by: Asteroid
2 Replies

4. Shell Programming and Scripting

How to loop through every char in a string

for example this string: gLZMQp8i Loop become easy if we add space between each char, How to do it? or other solutions are welcome. (9 Replies)
Discussion started by: honglus
9 Replies

5. Shell Programming and Scripting

Parsing char string

I am stumped! I need to parse an input parameter to a script that has the form '-Ort'. I basically need 'O', 'r' and 't', i.e. the individual characters in the string parsed. Since there are no delimiters, I don't know how awk could do this. Can someone tell how to do this, this should be a... (5 Replies)
Discussion started by: ALTRUNVRSOFLN
5 Replies

6. Shell Programming and Scripting

how to get number char from a string

for example: i hav a string like : /rmsprd/arch01/rmsprd/rmsprdarch72736.log how I can extract my_num=72736? I know I can echo "/rmsprd/arch01/rmsprd/rmsprdarch72736.log" | tr "/" " " | awk '{ print $4 }' to get rmsprdarch72736.log (4 Replies)
Discussion started by: netbanker
4 Replies

7. Shell Programming and Scripting

last char from a string

i have a script that reads a plain text file. (its a ksh, and i can use bash also) each line of the file is a fullpath of a file. that makes the list huge. i need to add a functionalitie to that script, i have to be able to add /usr/* or /usr/ and with that reference all the files and folders... (6 Replies)
Discussion started by: broli
6 Replies

8. Programming

replacing char with string

how we can replace char with a string example char *a="a.s" so finally what i ant to do raplace a with ant and s sree so in my array a i want to store the value as "ant.sree" thank u in advance (1 Reply)
Discussion started by: phani_sree
1 Replies

9. UNIX for Dummies Questions & Answers

string of 7 char length always...

Hi, I know, particular value in the variable should always be of lenth 7 , but the value that is present in thevariable might be of any no.of characters less than or equal to 7... if the no.of characters in the variable is less than 7, I want to add, zeroes at the starting of the field.. How can... (3 Replies)
Discussion started by: thanuman
3 Replies

10. Programming

Compare Char to String

This is actually a c++ question... Basically I am creating a program that asks for five characters. I have a dictionary file containing tons of words no long than five letters long, on a seperate line. I want to be able to take the five inputted letters and compare them to the words in the file... (3 Replies)
Discussion started by: Phobos
3 Replies
Login or Register to Ask a Question