How to append (or write) data into a file in column wise using SKILL/OCEAN

The only way to do this would be to read the file each time and re-write with the additional info appended on the end of each line. Given that you're modifying the file, you'd probably need to rename the file first, read it and write back to the original location as you go along.

Alternatively, keep all the data in memory and only write it out when you've collected all columns.

There's no file magic that allows you to append on the end of each line in an ASCII file (in any language) - the file is a sequential series of characters, and you're asking to insert a number of characters intermittently throughout the file - so really all you can do is read the existing file and re-write.

Regards,

Andrew.

Dear Andrew,

Thanks for your reply.

Could you please tell how one can store data in a matrix like MATLAB in OCEAN script.

Kind Regards,

There is no direct equivalent of a Matlab-style Matrix in SKILL. You can of course create a multi-dimension array - SKILL doesn’t provide a direct way of declaring a multi-dimensional array, but the SKILL code abMultiDimArray.il can do this (in this post).

Then you can easily populate the contents of such a multi-dimension array using simple syntax:

data=abMultiDimArray(nCols nRows)
for(col 0 nCols-1
  for(row 0 nRows-1
    data[col][row]=…
  )
)

The double array index you see above is because of the fact that the function I provided can create the multiple dimension arrays for you. You could then write into the array in your loop, and at the end, iterate over the rows and columns and write that data to a CSV file.

Regards,

Andrew.

Dear Andrew,

Thanks a lot. The SKILL script is really making life simpler.

Kind Regards

Dear Andrew,

Thanks a lot. The SKILL script is really making life simpler.

Kind Regards

Dear Andrew,

Though your .il script we are able to store data. There is also a need to plot let's say the the fist column of data vs the 2nd column of data in ViVA.

Can we use plot command for this. If so how it can be achieved ?

Kind Regards,

Do something like this (top is just to create some artificial data):

nCols=5 nRows=20
data=abMultiDimArray(nCols nRows)
for(col 0 nCols-1
  for(row 0 nRows-1
    if(col==0 then data[col][row]=row+0.0 else data[col][row]=random(500)+0.0)
  )
)

awvPlotList(
  currentWindow()
  list(
    vectorToList(data[1])
    vectorToList(data[2])
  )
  vectorToList(data[0])
 ?expr list("stuff" "nonsense")
)

The second argument to awvPlotList is a list of lists, where each is a list of y values to plot - you can just use vectorToList for the data column you want. The third argument is a list of the common x-values. If you only want to plot a single y slice versus x slice then it would be:

awvPlotList(
  currentWindow()
  list(
    vectorToList(data[2])
  )
  vectorToList(data[0])
 ?expr list("single")
)

The ?expr argument is a list with the same number of entries as there are y lists.

Regards,

Andrew.

Dear Andrew,

Can we use value() command for 'data[]'.  In other words, if I want to find vectorToList(data[2]) value at a given vectorToList(data[0]) value.

Similarly can cross() command be used ?

Kind Regards,

No. These are SKILL lists and not waveform objects which is what the value and cross function use. You could however use abMakeWaveform from this post to create a waveform from the data.

newWave=abMakeWaveform(vectorToList(data[2]) vectorToList(data[0]))

That creates a waveform object from a given y list (the first argument) and x list (the second argument). Having done that you can then do:

value(newWave 15)
cross(newWave 200)

(of course, the precise value or cross arguments will depend on the data).

Regards,

Andrew.

Dear Andrew,

It works nicely.

By the way, can we add axis label by using awvPlotList ?

Kind Regards,

If it's the axis units, you can do that using the code in these functions: https://community.cadence.com/cadence_technology_forums/f/custom-ic-design/23345/ocean-calculator-expressions-and-their-units/1313940#1313940 

You'd create a waveform using awvMakeWaveform and then use these functions before you plot the waveform object with (say) plot() . You can't (I think) do this with awvPlotList.

Regards,

Andrew.