Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Triming the data in a file.
Top Forums UNIX for Beginners Questions & Answers Triming the data in a file. Post 303036740 by Raghuram717 on Wednesday 10th of July 2019 03:55:15 AM
Old 07-10-2019
Triming the data in a file.
Hi, I have a big csv file with below data.

file:
Code:
La Cage Aux Folles (Widescreen)
Famous Mystics and Psychics
A Passion for Planning Financials  Operations  Marketing  Management  and Ethics
Precious Moments Holy Bible New King James Version Precious Angels Edition  Blue
Practical Recording 2 Pro Tools
Generals at Rest The Grave Sites of the 425 Official Confederate Generals
Getting the Most Out of Teaching With Newspapers Learning-Rich Lessons
Strategies  and Activities That Use the Power of Newspapers to Teach Current
Events and Build Skills in Reading  Writing  Math
Box Of The Blues (4CD)
The McDonaldization Thesis Explorations and Extensions
Film and Literature An Introduction and Reader
The Ecology of Eden
Jaroslav Rossler
The Complete Idiots Guide to Italian Level 1
Fresh Eggs
Energizer Lithium-Ion Digital Camera Battery ER-D210
Leaders That Last How Convenant Friendships Can Help Pastors Thrive
Krishnas Cosmos The Creativity of an Artist  Sculptor  Teacher
Numerical Simulation in Tunneling
Creating Sanctuary A New Approach to Gardening in the Washington Metropolitan
Area
Thelonious Monk Orchestra At Town Hall (Remaster)  The


I need to trim the data file like it should contain three or less i.e 1 or 2 or 3 words in a line. The three words can be the fisrt three words of the line or the last three words of the line. it should be random way some lines should consist first three words and some should consist last three words.
example as shown as below.

trimmed file having three words from every line (randomly first three words or last three words):
Code:
La Cage Aux 
Mystics and Psychics
Management  and Ethics
Precious Moments Holy
Recording 2 Pro Tools
Official Confederate Generals
Learning-Rich Lessons
to Teach Current
Reading  Writing  Math
Box Of The Blues
The McDonaldization Thesis
Film and Literature
Ecology of Eden
Jaroslav Rossler
The Complete Idiots
Fresh Eggs
Energizer Lithium-Ion
Help Pastors Thrive
Artist  Sculptor  Teacher
Numerical Simulation
the Washington Metropolitan
Area
Thelonious Monk Orchestra

can someone help me on this.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Triming spaces for any variable

Hi, I want to trim the spaces on left side of the variable value. For eg: if it is 4 spaces followed by value, All the spaces on the left should be supressed. Easy but want it quickly. Regards, Shiv@jad (6 Replies)
Discussion started by: Shiv@jad
6 Replies

2. Shell Programming and Scripting

Find and replace data in text file with data in same file

OK I will do my best to explain what I need help with. I am trying to format an ldif file so I can import it into Oracle oid. I need the file to look like this example. Keep in mind there are 3000 of these in the file. changetype: modify replace: userpassword dn:... (0 Replies)
Discussion started by: timothyha22
0 Replies

3. UNIX for Dummies Questions & Answers

How to get data only inside polygon created by points which is part of whole data from file?

hiii, Help me out..i have a huge set of data stored in a file.This file has has 2 columns which is latitude & longitude of a region. Now i have a program which asks for the number of points & based on this number it asks the user to enter that latitude & longitude values which are in the same... (7 Replies)
Discussion started by: reva
7 Replies

4. Shell Programming and Scripting

Triming a string

Hi i have an input " load /appss/asdfas/... I want to take the string present between first / / i.e appss Input is "load /appss/asdfas/..." Expected output is appss Thanks in advance Ananth (9 Replies)
Discussion started by: Ananthdoss
9 Replies

5. Shell Programming and Scripting

Putting two perl scripts together... triming whitespace off of recently parsed file

Thanks to people's help, I have composed a single line within a .sh script that Ports a file into a csv: perl -p -i -e... (5 Replies)
Discussion started by: Astrocloud
5 Replies

6. Shell Programming and Scripting

Triming spaces few columns

File contains 10 columns,i want trim the 2,4,10 columns using single unix command. Please suggest me how to do? Thanks (21 Replies)
Discussion started by: bmk
21 Replies

7. UNIX for Dummies Questions & Answers

Mapping a data in a file and delete line in source file if data does not exist.

Hi Guys, Please help me with my problem here: I have a source file: 1212 23232 343434 ASAS1 4 3212 23232 343434 ASAS2 4 3234 23232 343434 QWQW1 4 1134 23232 343434 QWQW2 4 3212 23232 343434 QWQW3 4 and a mapping... (4 Replies)
Discussion started by: kokoro
4 Replies

8. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

9. Shell Programming and Scripting

Extract header data from one file and combine it with data from another file

Hi, Great minds, I have some files, in fact header files, of CTD profiler, I tried a lot C programming, could not get output as I was expected, because my programming skills are very poor, finally, joined unix forum with the hope that, I may get what I want, from you people, Here I have attached... (17 Replies)
Discussion started by: nex_asp
17 Replies

10. Shell Programming and Scripting

Replace data of a file with data from another file using shell scripting.

Dears, I'm new to shell scripting and i was wondering if you can help me with following matter. I have a file containing 400,000 records. The file contains two columns like: 00611291,0270404000005453 25262597,1580401000016155 25779812,1700403000001786 00388934,1200408000000880... (1 Reply)
Discussion started by: paniklas
1 Replies

LEARN ABOUT DEBIAN

american-english

american-english(5)						   Users' Manual					       american-english(5)

NAME

       american-english - a list of English words

DESCRIPTION

       /usr/share/dict/american-english is an ASCII file which contains an alphabetic list of words, one per line.

FILES

       There  may  be  any  number  of	word lists in /usr/share/dict/.  /etc/dictionaries-common/words is a symbolic link to the currently-chosen
       /usr/share/dict/<language> file.  /usr/share/dict/words is a symbolic link to /etc/dictionaries-common/words, and  is  the  name  by  which
       other  software should refer to the system word list.  See select-default-wordlist(8) for more information, and/or to change the currently-
       chosen word list.

       The directory /usr/share/dict can contain word lists for many languages, with name of the language in English, e.g., /usr/share/dict/french
       and  /usr/share/dict/danish  contain respectively lists of French and Danish words if they exist.  Such lists should be coded using the ISO
       8859-1 character set encoding.

SEE ALSO

       ispell(1), select-default-wordlist(8), and the Filesystem Hierarchy Standard.

HISTORY

       The words lists are not specific, and may be generated from any number of sources.

       The system word list used to be /usr/dict/words.  For compatibility, software should check that location if /usr/share/dict/words does  not
       exist.

AUTHOR

       Word  lists  are  collected and maintained by various authors.  The Debian English word lists are built from the SCOWL (Spell- Checker Ori-
       ented Word Lists) package, whose upstream editor is Kevin Atkinson <kevina@users.sourceforge.net>.

Debian								   16 June 2003 					       american-english(5)
All times are GMT -4. The time now is 02:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy