I need to use second column
$1,$2,$3,$4.....
if first char =='Y' then obtain $2,$4,'_',$6
else if first char =='D' then obtain $3_'KIOSK'
else if first char =='P' then obtain $2
else if first char =='G' then BRANI_GATE_2
else null
getting the result:
Hi guys, need an approach guide to the problem. I dont know how to start . Thanks.
Last edited by Scrutinizer; 09-25-2012 at 03:44 AM..
Reason: code tags and formatting
Hello,
I have a huge set of data that needs to be reformatted.
Here is a simple example to explain the process.
I have number n=5 and a input with many numbers separated with comma:
... (11 Replies)
Dear Sir,
I have file input
RGR001|108.28|-2.86489|100-120|RANGGAR
RGR002|108.071|-2.69028|80-100|RANNGAR
RGR003|108.168|-2.97053|50-80|RANNGAR
RGR007|108.192722222|-2.766138889|0-50|RANGGARI want to create files by joining each rows with each rows below
Output as below
... (4 Replies)
Hallo Team,
I need to manipulate existing data file. Have a look at current data and expected data:
Current Data:
27873517141
27873540000
27873515109
27873517140
27873540001
27873540000
27873501343
27873540000
27873517140
27873511292
27873645989
27873540000
27873540000... (7 Replies)
Dear all
I have a dataset (in text format,delimited by tab) which have 100 variables (say, var0-var99) and more than 100,000 observations. I want to do the following:
1. for variable var0-var49, I want to add "00" in front of each data (for example, "1" would become "001")
2. for variable... (8 Replies)
Hi all!
my first post here, so mods -- if this should ideally be in the scripts section, please move there. Thanks!
I have data in the following format:
key1:value1 key2:value2 key3:value3
A
B
C
D
key1:value4 key2:value5 key3:value6
A1
B1
key1: ...
and so on
I want an output... (2 Replies)
Hi everyone..
I am new here, hello.. I hope this doesn't come across to you folks as a stupid question, I'm somewhat new to scripting :)
I'm seeking some help in finding a way to manipulate data output for every two characters - example:
numbers.lst contains the following output:... (3 Replies)
Hello
I am currently having problems in mapulating a certain file which contains vaious data.
Belos is a sample content
Event=<3190>
Client IP=<151.111.11.143> DNS=<abc.sbc.com> TransCount=<139>
Client IP=<150.222.133.163> DNS=<xyz.yuu.com> TransCount=<3734>
Event=<3120>
Client... (11 Replies)
Hello guys,
I'm a new member here and I need some help with the Awk application. I'm using it through the Terminal app of OSX (I'm a Mac user).
I have a huge file with a large amount of data (rows of 3D cartesian coordinates). The data is typically like the following example (actually, the... (13 Replies)
I have a folder called {homedata}
Within this folder there are 12 subfolders 200601.......200612
Within each subfolder there are 8 sets of files
Each filename commences with A B C D E F G or H,
so {filename}* can be used.
I am trying to write a script which will from the top level
go... (1 Reply)