Visit Our UNIX and Linux User Community


Text Convert


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Text Convert
# 1  
Old 04-14-2012
Text Convert

Hello,

I have a text file(utf8-bom). I want convert to following format. Thank you.

Code:
1***hello 35345 test test666
test 77 ? - test666


6//77
2***ktest 765
3***john6666 net 565433
nebb


I want this format.

Code:
1***hello 35345 test test666  test 77 ? - test666  6//77
2***ktest 765
3***john6666 net 565433  nebb


Last edited by Scrutinizer; 04-14-2012 at 06:15 PM.. Reason: code tags
# 2  
Old 04-14-2012
Try:
Code:
perl -0777 -ne 's/\s+/ /g;
print "$_\n" for /\d\*\*\*.*?(?=\d\*\*\*|$)/msg' FILE

# 3  
Old 04-14-2012
Thank you code works. but only outputs are between 1***-9***
I have the format.
Code:
1***j76j67
k87k
30***6h6
543***h6h6
9743***h6h6
16344***h66

Moderator's Comments:
Mod Comment How to use code tags

Last edited by Scrutinizer; 04-14-2012 at 06:15 PM..
# 4  
Old 04-14-2012
Code:
perl -0777 -ne 's/\s+/ /g;
print "$_\n" for /\d+\*\*\*.*?(?=\d+\*\*\*|$)/msg' FILE

# 5  
Old 04-14-2012
Thank you very much.

Previous Thread | Next Thread
Test Your Knowledge in Computers #789
Difficulty: Medium
Steve Wozniak was employed at Sun Microsystems before he founded Apple Computers.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Convert text to columns

Hi. I need an input file of a single word pr. line converted in into a list of random pairs. i need input like this word1 word2 word3 word4 to be outputted like this: word3 word1 word2 word4 My attempt is a tedious while loop like this: nfiles=$(cat inputfile | wc -l) ... (4 Replies)
Discussion started by: BotHead
4 Replies

2. Shell Programming and Scripting

Convert text to csv

Hi, Is there somebody there to post an idea on how to convert this 5 liner row to 1 liner or tab delimiter to be import to database. Here the text file format: Description: Description1 Link: https://www.google.com Date: June 2, 2018 Time: 00:07:44 Age: 1 days ago Description:... (2 Replies)
Discussion started by: lxdorney
2 Replies

3. Shell Programming and Scripting

How to convert Text data to xls?

Hi Team, I have created a script to output DB Query data to a text file. It displays output as follows for 2 different queries appended to same file. I want help to convert this data to xls format so that the output of first query is in 1 tab and the other in second tab. Please help. ... (14 Replies)
Discussion started by: srkmish
14 Replies

4. Shell Programming and Scripting

Convert text to CSV

Hi Gurus I need urgent help to convert a flat log file into csv format to load into database. Log looks like: a=1 b=2 c=3 a=4 b=5 c=6 Only the values at right side of = will come into csv and it should create a new line once it receives "a" field. (8 Replies)
Discussion started by: sandipjee
8 Replies

5. Shell Programming and Scripting

Text Convert

Hello, I have a text file(utf8-bom). I want convert to following format. Thank you. 1***hello 35345 29***hello test6 380***bill33 4327***hello test6 47829***hull55 65644***hello test6 I want this format. 1***hello 35345 29***hello test6 380***bill33 4327***hello test6 2... (8 Replies)
Discussion started by: kata33
8 Replies

6. UNIX for Dummies Questions & Answers

How to convert text to columns in tab delimited text file

Hello Gurus, I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem? The input file example, ... (6 Replies)
Discussion started by: Unilearn
6 Replies

7. Programming

convert text file to csv

hi all, i have a select query that gives me the output in the following way... SYSTYPE -------------------------------------------------------------------------------- Success Failures Total RFT ---------- ---------- ---------- ---------- TYP 1 0 ... (3 Replies)
Discussion started by: sais
3 Replies

8. Shell Programming and Scripting

convert Text to Excel

I have some text data generated by a perl script and want to put it into an excel sheet. Is there a perl script that can do this for me, i.e, convert text data to excel? (1 Reply)
Discussion started by: Pavankk
1 Replies

9. Shell Programming and Scripting

Convert text to numerical

Hi folks, I am trying to convert one character to a numeric format, for example : " 1" to number 1 :cool: Ups forgot to tell you .. !!! I am trying to do it with kornshell !!! ;) (4 Replies)
Discussion started by: nzq71k
4 Replies

10. UNIX for Dummies Questions & Answers

How do I convert unix text to to win text?

How do I convert unix text files into readable text for windows. Dave (1 Reply)
Discussion started by: nucca
1 Replies

Featured Tech Videos