Software Engineering Blog

What am i after in these days

  • Excel Tip: Lookup and return multiple values in one cell

    During another fun day of excel filling for program usages of Mainframe systems , i had program list ,which i fed into a jenkins search and got where they were used. Many programs were used in many modules and I wanted to show one program’s usages in single cell. So i google it. There were two options according to your excel version:

    1- For newer Excel versions ; you should use textjoin , unique and if functions combined. A column is for lookup , b for value.

    =TEXTJOIN(", ",TRUE,UNIQUE(IF(D2=$A$2:$A$20,$B$2:$B$20,"")))

    2- For older, poorer excel versions : You should be writing a VBA function. Unfortunately that was what i had to do. Put Alt + F11 and insert a module.

    'Code by Sumit Bansal (https://trumpexcel.com)
    Function SingleCellExtract(Lookupvalue As String, LookupRange As Range, ColumnNumber As Integer)
      Dim i As Long
      Dim Result As String
      For i = 1 To LookupRange.Columns(1).Cells.Count
      If LookupRange.Cells(i, 1) = Lookupvalue Then
      Result = Result & " " & LookupRange.Cells(i, ColumnNumber) & vbNewLine
      End If
      Next i
      SingleCellExtract = Trim(Trim(Left(Result, Len(Result) )))
      End Function

    Then you should call in the cell =SingleCellExtract and give parameters.

    Do not give unlimited range because that really hurts performance.

    Format your cells for WRAP TEXT option otherwise newlines are omitted.

    For more goto my reference:


  • No need to tell, see for yourself, Startup 149 ms

    |  \/  (_) ___ _ __ ___  _ __   __ _ _   _| |_ 
    | |\/| | |/ __| '__/ _ \| '_ \ / _` | | | | __|
    | |  | | | (__| | | (_) | | | | (_| | |_| | |_ 
    |_|  |_|_|\___|_|  \___/|_| |_|\__,_|\__,_|\__|
      Micronaut (v3.9.1)
    
    22:39:01.504 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
    22:39:01.511 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
    22:39:01.512 [main] INFO  i.m.flyway.AbstractFlywayMigration - Running migrations for database with qualifier [default]
    22:39:01.512 [main] INFO  o.f.c.i.license.VersionPrinter - Flyway Community Edition 8.5.13 by Redgate
    22:39:01.512 [main] INFO  o.f.c.i.license.VersionPrinter - See what's new here: https://flywaydb.org/documentation/learnmore/releaseNotes#8.5.13
    22:39:01.512 [main] INFO  o.f.c.i.license.VersionPrinter - 
    22:39:01.513 [main] INFO  o.f.c.i.d.base.BaseDatabaseType - Database: jdbc:h2:mem:devDb (H2 1.4)
    22:39:01.519 [main] INFO  o.f.core.internal.command.DbValidate - Successfully validated 1 migration (execution time 00:00.002s)
    22:39:01.523 [main] INFO  o.f.c.i.s.JdbcTableSchemaHistory - Creating Schema History table "PUBLIC"."flyway_schema_history" ...
    22:39:01.538 [main] INFO  o.f.core.internal.command.DbMigrate - Current version of schema "PUBLIC": << Empty Schema >>
    22:39:01.539 [main] INFO  o.f.core.internal.command.DbMigrate - Migrating schema "PUBLIC" to version "1 - create-schema"
    22:39:01.553 [main] INFO  o.f.core.internal.command.DbMigrate - Successfully applied 1 migration to schema "PUBLIC", now at version v1 (execution time 00:00.019s)
    22:39:01.610 [main] INFO  io.micronaut.runtime.Micronaut - Startup completed in 147ms. Server Running: http://localhost:8080
    

  • Intellij Gradle GraalVM NativeCompile Trick

    Intellij Gradle GraalVM NativeCompile Trick

    In previous post , we set java_home on mac. Now let’s compile graalVM native image but that gives no java launcher error.

    To get through environment errors , set explicitly Java_home setting on gradle tooling as shown below. Take care.


  • MACOS : libexec/java_home

    MACOS : libexec/java_home

    Nothing fancy , but on macOS

    /usr/libexec/java_home

    gives you default jdk and

    you can export JAVA_HOME by

    export JAVA_HOME=$(/usr/libexec/java_home)

    https://mkyong.com/java/how-to-set-java_home-environment-variable-on-mac-os-x/


  • Micronaut Ne yapar Ne yapmaz ?

    Micronaut Ne yapar Ne yapmaz ?

    Öncelikle micronaut jvm tabanlı spring alternatifi bir java framework üdür.

    Hızlıca ayağa kalkıp işine başlar (start up zamanı düşük)

    Her işini derleme zamanında bitirmeye çalışır. (Reflection sevilmez , Zilyon tane inspector inject etmez)

    Grails geliştiricilerinin hazırladığı bir frameworkt tür.

    Graals VM ile küçücük minnah native executable larınız olur.

    Şişko jar üretmez.

    Spring boot ile alıştığınız çoğu alışkanlığın bir karşılığı var ama öğrenmelisiniz.

    İsteklerinizi önceden belirlemelisiniz. Çorba pişmeden önce içinde ne olacağına karar vermelisiniz.

    Genelde Hintli IT pro amcalarımızın videolarını önerirdim ama bence gidin güzel dokümantasyonu bir okuyun veya bir LLM(chatgpt) açıp ona dokümandan yanıt ve örnek vermesini isteyerek sorun.


RSS
LinkedIn
LinkedIn
Share