nice to hear that you worked your way through and thanks for giving feedback.
Some comments:
That's why I pointed out XPath for you twice and presented you links for a good and short tutorial. Read the great manuals out there! Read it and you will be lesser dependant on others.
I would suggest to avoid that. With this step, the complexity of the task had risen for no good reason. I understand why you did it(just to get the task done - did that myself in the past), but I recommend to better invest the time to get the data out of the original format. That's most likely possible with jq - even if it needs the work to get familiar with jq. Otherwise you carry the increased complexity, increased error possibility, increased resource footprint with that task from now on.
An alternative to jq may be a small php script, that generates the csv.
If you like, show the original json...
(and sometimes a quick and dirty hack is just fine too)
It's more like the approach that didn't work with xml. ;-)
I did find those links you gave me but they where still a bit confusing and i would say limited in what i needed. Too be honest i did not have that much time either as i spend already almost a week on this with xmlstarlet alone.
As you mention this was a cheat but transforming the json to xml but this was also because i am severly limited in time and knowledge of jq. I actually did try a couple days and then i gave up because of the time constraints. Seeing your code however makes it look quite easy and even less fault sensitive. When i have some time i will actually try it out and let you know here about the (hopefully) success of the jq way.
I just tested jq but something seems not to work. I edited your piece of code to work with the json string:
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
I am trying to check each line and based on first two digits, the comma needs to be place. I checked in the earlier post where the text is converted to csv with a tab delimited.
Here is the test file that needs to be changed to csv
11 051701
22 051701
330123405170105170112345... (13 Replies)
I'm new to shell scripting and I have a file with positional columns. The rows look like this:
222 3333 44444 55 55 55 55 5555 59999
222 3333 44444 55 55 55 55 5555 59999
Not every row has the same number of spaces between the seven columns. They can range anywhere... (11 Replies)
Hello Friends,
I am new to UNIX shell scripting. Using bash....Could you please help me in converting a flat file into an XML style output file.
Flat file: (Input File entries looks like this)
John Miller: 617-569-7996:15 Bunting lane, staten Island, NY: 10/21/79: 60600
The... (4 Replies)
Hej All,
I have a file like this which is a comma dilimited:
input:
6000318,-263.011520678,-59.05869872409,587.67924868792
6000319,-265.6996842902,-50.24902479999,590.65693082607
6000320,-238.1333898366,-288.801232595,633.75332173496... (5 Replies)
Hi Friends,
I want to convert a XML file to flat file.
Sample I/p:
<?xml version='1.0' encoding='UTF-8' ?>
<DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen
.xsd'>
<Contact... (3 Replies)
I have a table as following
Archive id Line Author Time Text
1fjj34 3 75jk5l 03:20 this is an evidence regarding ...
1fjj34 4 gjhhtrd 03:21 we have seen those documents before
1fjj34 10 645jmdvvb 04:00 Will you consider such an offer?... (0 Replies)
Hi,
I have a xml script, I converted it to .txt with values comma seperated using awk function. But I want the output values should be inside double quotes
My xml script (Workorders.xml) is shown like below:
<?xml version="1.0" encoding="utf-8" ?>
<scbm-extract version="3.3">... (8 Replies)
Discussion started by: Viswanatheee55
8 Replies
LEARN ABOUT MOJAVE
footprint
FOOTPRINT(1) BSD General Commands Manual FOOTPRINT(1)NAME
footprint -- gathers memory information about one or more processes
SYNOPSIS
footprint [-j path] [-f bytes|formatted|pages] [-p name|pid] [-x name|pid] [-t] [-s] [-v] [-y] [-w] [--swapped] [--wired] [-a] process-name |
pid | memgraph [...]
footprint -h, --help
DESCRIPTION
The footprint utility gathers and displays memory consumption information for the specified processes or memory graph files.
footprint will display all addressable memory used by the specified processes, but it emphasizes memory considered 'dirty' by the kernel for
purposes of accounting. If multiple processes are specified, footprint will de-duplicate multiply mapped objects and will display shared
objects separately from private ones.
footprint must be run as root when inspecting processes that are not owned by the current user.
OPTIONS -a, --all
target all processes (will take much longer)
-j, --json path
also save a JSON representation of the data to the specified path
-f, --format bytes|formatted|pages
textual output should be formatted in bytes, pages, or human-readable formatted (default)
-p, --proc name
target the given process by name (can be used multiple times)
-p, --pid pid
target the given process by pid (can be used multiple times)
-x, --exclude name/pid
exclude the given process by name or pid (can be used multiple times)
often used with --all to exclude some processes from analysis
-t, --targetChildren
in addition to the supplied processes, target their children, grandchildren, etc.
-s, --skip
skip processes that are dirty tracked and have no outstanding XPC transactions (i.e., are "clean")
-v display vmmap-like output of address space layout
-y, --summary
print only regions with dirty memory, and condense __TEXT, __DATA, and __LINKEDIT regions into 'Other' subtotal
-w, --wide
show wide output with all columns (implies --swapped --wired)
--swapped
show swapped/compressed column, a subset of 'dirty'
--wired
show wired memory column, a subset of 'dirty'
-h, --help
display help and exit
SAMPLE USAGE
footprint Mail WindowServer
OS X January 29, 2018 OS X