ARCHIVE

Excel - how to add a string after 2 or 3 position in columns

You need to write this macro in Visual Basic   Sub replaceat() Dim rng As Range Dim cl As Range Set rng = Range(Selection.Address)   For Each cl In rng.Cells cl.Formula = “=Replace(“”” & cl.Value & “”” ,3,0,””.””)” Next End Sub   Then you can execute it on any selection via the Developer > Macros […]
FFMPeg Normalize Audio mp3

We can use this command to find the max volume: ffmpeg -i sound.mp3 -af volumedetect -f null -y nul &> original.txt It will return something like [Parsed_volumedetect_0 @ 0x7fa4f7d00000] n_samples: 4997376 [Parsed_volumedetect_0 @ 0x7fa4f7d00000] mean_volume: -27.6 dB [Parsed_volumedetect_0 @ 0x7fa4f7d00000] max_volume: -12.3 dB [Parsed_volumedetect_0 @ 0x7fa4f7d00000] histogram_12db: 663 [Parsed_volumedetect_0 @ 0x7fa4f7d00000] histogram_13db: 1846 [Parsed_volumedetect_0 @ […]
{"type":"main_options","images_arr":"'#ffffff'","enable_ajax":"off","soundcloud_apikey":"","bg_isparallax":"off","bg_slideshow_time":"0","bg_transition":"slidedown","site_url":"http:\/\/digitalzoomstudio.net","theme_url":"http:\/\/digitalzoomstudio.net\/wp-content\/themes\/qucreative\/","blur_ammount":"26","width_column":"50","width_section_bg":"","width_gap":"30","border_width":"0","border_color":"#ffffff","translate_leave_a_comment":"Leave a comment","translate_leave_a_comment_to":"Leave a comment to","is_customize_preview":"off","width_blur_margin":"30","gallery_w_thumbs_autoplay_videos":"off","enable_native_scrollbar":"on","content_enviroment_opacity":"30","menu_enviroment_opacity":"70"}
{"type":"darkfull"}